07-11-2016, 09:18 AM
[attachment=74680]
PREFACE
Computers have become an important media in each & every field, since last few years. The features of computers like speed, accuracy & many others attract almost all the categories of people, & so there are no fields that are not affected by the impact of computers. Many new sorts are discovered & will still be discovered due to its rapid development.
In this project, EIS, we have tried our best to use computers in real time application. The project provides capability to access the database using the functionality of SQL-SERVER 2005at back-end but providing a nice GUI to the users using ASP.NET as the front-tool. This project can be particularly useful in the application where we can get information about records of an employee in the particular institution and can calculate the salary.
Finally, we wish to thank all those persons who have been directly or indirectly helping us in preparing this project. We are also very thankful to collage for providing the platform to put our knowledge in practice. We would also like to express our gratitude towards our faculty members who have been always encouraging & co-operating us during the preparation of our project.
ABSTRACT
Title:
“EMPLOYEE INFORMATION SYSTEM”
Definition :
We can get information of the employee working in the college and this can used in the companies.
Abstract of the project :
This project is aimed at developing an ‘Employee Information System’ for the facilities in getting ‘information of an employee’ and can ‘calculate salary’. This system can be used to automate the workflow of service requests for the various facilities in the ‘HR MODULE’. This is an easy way to understand Employee Management system. These requests will be sent to the concerned people, who are also valid users of the system, to get them resolved.
There are three kinds of users for this system:
1. Those who use the system to create a request (end-users).
2. Those who look at the created requests and assign them to the concerned people (facility-heads).
3. Those who work on the assigned requests and update the status of the same on the system (assignees).
ROLES & RESPONSIBILITES
The project, EIS, is prepared to give information regarding employees in rather convenient way. It uses SQL-SERVER as back-end & ASP.NET as front-end.
So the management of the particular institute can maintain the records of employees of the different departments of the institute including the salary also.
So, this project can be quite useful to ‘management system’ who wishes to maintain records & who wishes to know the strategy of the institute and can calculate the salary of the employee.
HARDWARE SPECIFICATION
The machine: Internet Connectivity
Processor: Pentium IV
RAM: 512MB DDR
HDD: 80 GB
FDD: 1.44
SOFTWARE SPECIFICATION
Operating System: Windows XP Server
System Architecture: .NET Framework
Database SQL Server 2005
Connectivity: ADO.NET
Server: IIS Server 2003
Presentation Layer: ASP.NET
Business logic: C#.NET
ADO.NET :
ADO.NET is the latest in a long line of data access technologies released by Microsoft. ADO.NET differs somewhat from the previous technologies, however, in that it comes as part of a whole new platform called the .NET Framework. This platform is set to revolutionize every area of development, and ADO.NET is just one aspect of that. The ADO.NET classes are divided into two components: the Data Providers (sometimes called Managed Providers), which handle communication with a physical data store, and the Dataset, which represents the actual data. Either component can communicate with data consumers such as Web Forms and Win Forms.
Data Providers :
The Data Provider components are specific to a data source. The .NET Framework includes two Data Providers: a generic provider that can communicate with any OLEDB data source, and a SQL Server provider that has been optimized for Microsoft SQL Server versions 7.0 and later. Data Providers for other databases such as Oracle and DB2 are expected to become available. The two Data Providers included in the .NET Framework contain the same objects, although their names and some of their properties and methods are different. The Connection object represents the physical connection to a data source. Its properties determine the data provider (in the case of the OLE DB Data Provider), the data source and database to which it will connect, and the string to be used during connecting. Its methods are fairly simple:
We can open and close the connection, change the database, and manage transactions. The Command object represents a SQL statement or stored procedure to be executed at the data source. Command objects can be created and executed independently against a Connection object, and they are used by Data Adapter objects to handle communications from a Dataset back to a data source. Command objects can support SQL statements and stored procedures that return single values; one or more sets of rows, or no values at all.
A Data Reader is a fast, low-overhead object for obtaining a forward-only, read-only stream of data from a data source. They cannot be created directly in code; they are created only by calling the Execute Reader method of a Command.
The Data Adapter is functionally the most complex object in a Data Provider. It provides the bridge between a Connection and a Dataset. The Data Adapter contains four Command objects: the Select Command, Update Command, Insert Command, and Delete Command. The Data Adapter uses the Select Command to fill a Data Set and uses the remaining three commands to transmit changes back to the data source, as required.
Dataset :
The Dataset is a memory-resident representation of data. The Dataset can be considered a somewhat simplified relational database, consisting of tables and their relations. It’s important to understand, however, that the Dataset is always disconnected from the data source—it doesn’t “know” where the data it contains came from, and in fact, it can contain data from multiple sources.
C #. NET :
C# was built from scratch as the .NET language. While it has features familiar to C programming, and it has some of the great RAD features so beloved by Visual Basic programmers, it is completely new. Some have said that C# is Microsoft’s “me too” language to compete with Sun’s Java.
Microsoft has introduced a new language especially for .NET, called C#. As this is now Microsoft’s flagship language, and the most likely language to be supported by Open Source projects.
All the functionality and support of the .NET Framework is available to any of the .NET languages, and in addition, objects written under one language can be used, inherited, and extended under any of the others. This is a very powerful concept and introduces the idea of language independence. This is achieved through the Common Language Runtime technology.
The CLR takes our .NET language code and converts it into an intermediate language (Microsoft Intermediate Language [MSIL]), and this intermediate language is then compiled to target machine-specific binary code.
C# is a truly modern language with all the features we could wish for, such as full object-orientation, automatic memory management, and housekeeping.
ASP.NET :
The .Net by Microsoft Company is to overcome the difficulties in the ASP. Microsoft ensured the asp scripts execute without modification on the machine with the .Net Framework.
Advantages :
• Separation of code from the content.Asp.Net allows the developer to separate script code from html. This allows for a clean.
• Separation of code from content and formatting and promotes code reuse.
• Support for compiled languages. While ASP.Net still supports the traditional set of scripting languages, support is also provided for fully compiled language, Instead of using vbscript the developer can use VB.NET and access features such as strong typing and object oriented programming.Asp.Net pages are precompiled to byte code and just in time compiled when first requested.
• Greater support for different browsers via server side controls and events. Following object oriented design principles, ASP.NET pages make use of server side controls called ASP.NET Web controls. These controls are instantiated on the server, and like regular objects they have associated methods, properties, and events. The advantage of the server side controls is that they render themselves on the client as standard HTML 3.2 (optionally DHTML), depending on the capabilities of the client browser.
Introducing Dynamic Web Pages :
The client-to-server-to-client process described is important because it happens each time a client contacts the server to get some data. That’s distinctly different from the stand-alone or client-server model we are familiar with already. Because the server and the client don’t really “know” anything about one another, for each interaction, we must send, initialize, or restore the appropriate values to maintain the continuity of our application.
In a site that allows anonymous connections, we can only authenticate users if we can compare the login/password values entered by the user with the “real” copies stored on the server. While HTML is an adequate layout language for most purposes, it isn’t a programming language. It takes code to authenticate users.
Because of the ever-changing nature of information also, dynamic pages became popular. Static pages are all very well for articles, scholarly papers, books, and images-in general, for information that rarely changes. But static pages are simply inadequate to capture employee and contact lists, calendar information, news feeds, sports score-in general, and the type of data we interact with every day. The data changes far too often to maintain successfully in static pages.
SQL Server Enterprise Manager :
SQL Server Enterprise Manager is a graphical tool that allows for easy, enterprise-wide configuration and management SQL Server and SQL Server objects.
It provides:
• A scheduling engine.
• Administrator alert capability.
• Drag-and-drop control operations across multiple servers.
• A built-in replication management interface.
We can also use SQL Server Enterprise Manager to:
• Manage logins, permissions, and users.
• Create scripts.
• Manage devices and databases.
• Back up databases and transaction logs.
• Manage tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types.
Creating and Maintaining Database :
Designing your Microsoft SQL Server database structure involves creating and maintaining a number of interrelated components.
ANALYSIS PHASE & FEASIBILITY ANALYSIS
Requirement Analysis :
Requirement analysis bridges the gap between the system engineering and software design.
Feasibility Study :
The feasibility of deigning the system is determined by evaluating alternate methods of converting available input data into the outputs to fulfill the system objectives. The purpose of feasibility is to identify various candidate systems and evaluate the system by technical, economical and operational feasibility and to recommend the best candidate system. The most eventual task performed by feasibility analysis are:
• Identification and description of candidate systems.
• Evaluation of best candidate system.
• The selection of best candidate system.
Economic Feasibility :
The developing system must be justified by cost and benefit criteria to ensure that effort is concentrated on project, which will give best returns at the earliest. One of the factors, which effect the development of a new system, is the cost it would require. Since the system is developed as part of the project work, no manual cost needs to be spend on the proposed system. Also, no need for extra hardware or software for implementing the current project and the cost of other resources need for development is minimum. The cost of errors is acceptable and the errors are mostly solvable.
Technical Feasibility :
The study must be evaluated from the technical point of view. The assessment of this feasibility must be based on an online design of the system requirement in terms of input, output, programs, procedures and staff having identified an outline system. The proposed system has the technical capacity to hold the data required to use the new system. The system can be expanded further according to the changes in the organizational system and with respect to the changes in the environment.
Operational Feasibility :
The proposed system is a graphical user interface. So it can be easily imported. It is a user-friendly system where the user can easily operate or use the system in an efficient manner. The result produced is accurate and optimized. The proposed system will take care of current activities and it causes no harm to organization
Behavioral Feasibility :
People are inherently resistant to change and computers have been known to facilitate change. An estimate should be made of how strong a reaction the user staff is likely to have towards the development of a computerized system. The introduction of a candidate system requires special effort to educate, sell & train the staff on new ways of conducting business.
Existing System :
Employment procedures are documented and kept up-to-date, they are kept in computer itself and also kept in the papers so that there is no problem if the file is being deleted from the computer . Every person-facing employee should have full knowledge of the service process and also have access to updated information. Non-electronic storage of processed information makes it more difficult to update and distribute process information. If the information is stored in the non-electronic storage, it is also difficult to provide a better service. So the work will become more tedious if it is not computerized. It requires a lot of manpower and paper works.
Proposed System :
A central goal of every business is to serve its customers. For as long as there have been merchants, success or failure has hinged on this simple rule. Employement Informatiom System (EIS) is a way of using technology to do just that. There are many pieces of software available that offer Employement management features, but in reality, EIS goes beyond software implementation. It’s a business strategy that often involves using multiple pieces of software, as well as implementing policies that promote
(1) The collection of Employement information, and
(2) The use of that information by individuals throughout the company in order to maximize service and decrease the man power.
The Employment management system is an enterprise system, which means that it spans multiple departments. The goal of EIS is to collect that information in a central repository, analyze it, and make it available to all departments.
Features of EIS:
Using EIS, a business can:
• Provide better service
• Help sales staff close deals faster
• Make call centers more efficient
• Simplify management and Record processes
DESIGN PHASE
Design and Development Process :
Design is a creative process; a good design is the key to effective system. The term “Design” is defined as “The process of applying various techniques and principles for the purpose of defining a process or a system in sufficient detail to permit its physical realization”. Various design features are followed to develop the system. The design specification describes the features of the system, the components or elements of the system and their appearance to end-users.
In system design high-end decisions are taken regarding the basic system architecture, platforms and tools to be used. The system design transforms a logical representation of what a given system is required to be in to the physical specification. Design starts with the system’s requirement specification and converts it into a physical reality during the development. Important design factors such as reliability, response time, throughput of the system, maintainability, expandability, etc should be taken into account.
Data Flow Diagram :
The data flow diagram (DFD) is one of the most important tools used by system analysts. Data flow diagrams are made up of a number symbols, which represent system components. Most data flow modeling methods use four kinds of symbols. These symbols are used to represent four kinds of system components. Processes, data stores, data flows and external entities. Processes are represented by circles in dfd. Data Flow represented by a thin line in the dfd and each data store has a unique name and represented by open rectangles and square or rectangle represents external entities.
Unlike detailed flowchart, Data Flow Diagrams do not supply detailed description of the modules but graphically describes a system’s data and how the data interact with the system.
To construct a Data Flow Diagram, we use,
• Arrow
• Circles
• Open End Box
• Squares
TABLE DESIGN
Database Design :
A database is a collection of interrelated data stored with minimum redundancy to serve many users quickly and efficiently. The general objective of database design is to make the data access easy, inexpensive and flexible to the user.
PREFACE
Computers have become an important media in each & every field, since last few years. The features of computers like speed, accuracy & many others attract almost all the categories of people, & so there are no fields that are not affected by the impact of computers. Many new sorts are discovered & will still be discovered due to its rapid development.
In this project, EIS, we have tried our best to use computers in real time application. The project provides capability to access the database using the functionality of SQL-SERVER 2005at back-end but providing a nice GUI to the users using ASP.NET as the front-tool. This project can be particularly useful in the application where we can get information about records of an employee in the particular institution and can calculate the salary.
Finally, we wish to thank all those persons who have been directly or indirectly helping us in preparing this project. We are also very thankful to collage for providing the platform to put our knowledge in practice. We would also like to express our gratitude towards our faculty members who have been always encouraging & co-operating us during the preparation of our project.
ABSTRACT
Title:
“EMPLOYEE INFORMATION SYSTEM”
Definition :
We can get information of the employee working in the college and this can used in the companies.
Abstract of the project :
This project is aimed at developing an ‘Employee Information System’ for the facilities in getting ‘information of an employee’ and can ‘calculate salary’. This system can be used to automate the workflow of service requests for the various facilities in the ‘HR MODULE’. This is an easy way to understand Employee Management system. These requests will be sent to the concerned people, who are also valid users of the system, to get them resolved.
There are three kinds of users for this system:
1. Those who use the system to create a request (end-users).
2. Those who look at the created requests and assign them to the concerned people (facility-heads).
3. Those who work on the assigned requests and update the status of the same on the system (assignees).
ROLES & RESPONSIBILITES
The project, EIS, is prepared to give information regarding employees in rather convenient way. It uses SQL-SERVER as back-end & ASP.NET as front-end.
So the management of the particular institute can maintain the records of employees of the different departments of the institute including the salary also.
So, this project can be quite useful to ‘management system’ who wishes to maintain records & who wishes to know the strategy of the institute and can calculate the salary of the employee.
HARDWARE SPECIFICATION
The machine: Internet Connectivity
Processor: Pentium IV
RAM: 512MB DDR
HDD: 80 GB
FDD: 1.44
SOFTWARE SPECIFICATION
Operating System: Windows XP Server
System Architecture: .NET Framework
Database SQL Server 2005
Connectivity: ADO.NET
Server: IIS Server 2003
Presentation Layer: ASP.NET
Business logic: C#.NET
ADO.NET :
ADO.NET is the latest in a long line of data access technologies released by Microsoft. ADO.NET differs somewhat from the previous technologies, however, in that it comes as part of a whole new platform called the .NET Framework. This platform is set to revolutionize every area of development, and ADO.NET is just one aspect of that. The ADO.NET classes are divided into two components: the Data Providers (sometimes called Managed Providers), which handle communication with a physical data store, and the Dataset, which represents the actual data. Either component can communicate with data consumers such as Web Forms and Win Forms.
Data Providers :
The Data Provider components are specific to a data source. The .NET Framework includes two Data Providers: a generic provider that can communicate with any OLEDB data source, and a SQL Server provider that has been optimized for Microsoft SQL Server versions 7.0 and later. Data Providers for other databases such as Oracle and DB2 are expected to become available. The two Data Providers included in the .NET Framework contain the same objects, although their names and some of their properties and methods are different. The Connection object represents the physical connection to a data source. Its properties determine the data provider (in the case of the OLE DB Data Provider), the data source and database to which it will connect, and the string to be used during connecting. Its methods are fairly simple:
We can open and close the connection, change the database, and manage transactions. The Command object represents a SQL statement or stored procedure to be executed at the data source. Command objects can be created and executed independently against a Connection object, and they are used by Data Adapter objects to handle communications from a Dataset back to a data source. Command objects can support SQL statements and stored procedures that return single values; one or more sets of rows, or no values at all.
A Data Reader is a fast, low-overhead object for obtaining a forward-only, read-only stream of data from a data source. They cannot be created directly in code; they are created only by calling the Execute Reader method of a Command.
The Data Adapter is functionally the most complex object in a Data Provider. It provides the bridge between a Connection and a Dataset. The Data Adapter contains four Command objects: the Select Command, Update Command, Insert Command, and Delete Command. The Data Adapter uses the Select Command to fill a Data Set and uses the remaining three commands to transmit changes back to the data source, as required.
Dataset :
The Dataset is a memory-resident representation of data. The Dataset can be considered a somewhat simplified relational database, consisting of tables and their relations. It’s important to understand, however, that the Dataset is always disconnected from the data source—it doesn’t “know” where the data it contains came from, and in fact, it can contain data from multiple sources.
C #. NET :
C# was built from scratch as the .NET language. While it has features familiar to C programming, and it has some of the great RAD features so beloved by Visual Basic programmers, it is completely new. Some have said that C# is Microsoft’s “me too” language to compete with Sun’s Java.
Microsoft has introduced a new language especially for .NET, called C#. As this is now Microsoft’s flagship language, and the most likely language to be supported by Open Source projects.
All the functionality and support of the .NET Framework is available to any of the .NET languages, and in addition, objects written under one language can be used, inherited, and extended under any of the others. This is a very powerful concept and introduces the idea of language independence. This is achieved through the Common Language Runtime technology.
The CLR takes our .NET language code and converts it into an intermediate language (Microsoft Intermediate Language [MSIL]), and this intermediate language is then compiled to target machine-specific binary code.
C# is a truly modern language with all the features we could wish for, such as full object-orientation, automatic memory management, and housekeeping.
ASP.NET :
The .Net by Microsoft Company is to overcome the difficulties in the ASP. Microsoft ensured the asp scripts execute without modification on the machine with the .Net Framework.
Advantages :
• Separation of code from the content.Asp.Net allows the developer to separate script code from html. This allows for a clean.
• Separation of code from content and formatting and promotes code reuse.
• Support for compiled languages. While ASP.Net still supports the traditional set of scripting languages, support is also provided for fully compiled language, Instead of using vbscript the developer can use VB.NET and access features such as strong typing and object oriented programming.Asp.Net pages are precompiled to byte code and just in time compiled when first requested.
• Greater support for different browsers via server side controls and events. Following object oriented design principles, ASP.NET pages make use of server side controls called ASP.NET Web controls. These controls are instantiated on the server, and like regular objects they have associated methods, properties, and events. The advantage of the server side controls is that they render themselves on the client as standard HTML 3.2 (optionally DHTML), depending on the capabilities of the client browser.
Introducing Dynamic Web Pages :
The client-to-server-to-client process described is important because it happens each time a client contacts the server to get some data. That’s distinctly different from the stand-alone or client-server model we are familiar with already. Because the server and the client don’t really “know” anything about one another, for each interaction, we must send, initialize, or restore the appropriate values to maintain the continuity of our application.
In a site that allows anonymous connections, we can only authenticate users if we can compare the login/password values entered by the user with the “real” copies stored on the server. While HTML is an adequate layout language for most purposes, it isn’t a programming language. It takes code to authenticate users.
Because of the ever-changing nature of information also, dynamic pages became popular. Static pages are all very well for articles, scholarly papers, books, and images-in general, for information that rarely changes. But static pages are simply inadequate to capture employee and contact lists, calendar information, news feeds, sports score-in general, and the type of data we interact with every day. The data changes far too often to maintain successfully in static pages.
SQL Server Enterprise Manager :
SQL Server Enterprise Manager is a graphical tool that allows for easy, enterprise-wide configuration and management SQL Server and SQL Server objects.
It provides:
• A scheduling engine.
• Administrator alert capability.
• Drag-and-drop control operations across multiple servers.
• A built-in replication management interface.
We can also use SQL Server Enterprise Manager to:
• Manage logins, permissions, and users.
• Create scripts.
• Manage devices and databases.
• Back up databases and transaction logs.
• Manage tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types.
Creating and Maintaining Database :
Designing your Microsoft SQL Server database structure involves creating and maintaining a number of interrelated components.
ANALYSIS PHASE & FEASIBILITY ANALYSIS
Requirement Analysis :
Requirement analysis bridges the gap between the system engineering and software design.
Feasibility Study :
The feasibility of deigning the system is determined by evaluating alternate methods of converting available input data into the outputs to fulfill the system objectives. The purpose of feasibility is to identify various candidate systems and evaluate the system by technical, economical and operational feasibility and to recommend the best candidate system. The most eventual task performed by feasibility analysis are:
• Identification and description of candidate systems.
• Evaluation of best candidate system.
• The selection of best candidate system.
Economic Feasibility :
The developing system must be justified by cost and benefit criteria to ensure that effort is concentrated on project, which will give best returns at the earliest. One of the factors, which effect the development of a new system, is the cost it would require. Since the system is developed as part of the project work, no manual cost needs to be spend on the proposed system. Also, no need for extra hardware or software for implementing the current project and the cost of other resources need for development is minimum. The cost of errors is acceptable and the errors are mostly solvable.
Technical Feasibility :
The study must be evaluated from the technical point of view. The assessment of this feasibility must be based on an online design of the system requirement in terms of input, output, programs, procedures and staff having identified an outline system. The proposed system has the technical capacity to hold the data required to use the new system. The system can be expanded further according to the changes in the organizational system and with respect to the changes in the environment.
Operational Feasibility :
The proposed system is a graphical user interface. So it can be easily imported. It is a user-friendly system where the user can easily operate or use the system in an efficient manner. The result produced is accurate and optimized. The proposed system will take care of current activities and it causes no harm to organization
Behavioral Feasibility :
People are inherently resistant to change and computers have been known to facilitate change. An estimate should be made of how strong a reaction the user staff is likely to have towards the development of a computerized system. The introduction of a candidate system requires special effort to educate, sell & train the staff on new ways of conducting business.
Existing System :
Employment procedures are documented and kept up-to-date, they are kept in computer itself and also kept in the papers so that there is no problem if the file is being deleted from the computer . Every person-facing employee should have full knowledge of the service process and also have access to updated information. Non-electronic storage of processed information makes it more difficult to update and distribute process information. If the information is stored in the non-electronic storage, it is also difficult to provide a better service. So the work will become more tedious if it is not computerized. It requires a lot of manpower and paper works.
Proposed System :
A central goal of every business is to serve its customers. For as long as there have been merchants, success or failure has hinged on this simple rule. Employement Informatiom System (EIS) is a way of using technology to do just that. There are many pieces of software available that offer Employement management features, but in reality, EIS goes beyond software implementation. It’s a business strategy that often involves using multiple pieces of software, as well as implementing policies that promote
(1) The collection of Employement information, and
(2) The use of that information by individuals throughout the company in order to maximize service and decrease the man power.
The Employment management system is an enterprise system, which means that it spans multiple departments. The goal of EIS is to collect that information in a central repository, analyze it, and make it available to all departments.
Features of EIS:
Using EIS, a business can:
• Provide better service
• Help sales staff close deals faster
• Make call centers more efficient
• Simplify management and Record processes
DESIGN PHASE
Design and Development Process :
Design is a creative process; a good design is the key to effective system. The term “Design” is defined as “The process of applying various techniques and principles for the purpose of defining a process or a system in sufficient detail to permit its physical realization”. Various design features are followed to develop the system. The design specification describes the features of the system, the components or elements of the system and their appearance to end-users.
In system design high-end decisions are taken regarding the basic system architecture, platforms and tools to be used. The system design transforms a logical representation of what a given system is required to be in to the physical specification. Design starts with the system’s requirement specification and converts it into a physical reality during the development. Important design factors such as reliability, response time, throughput of the system, maintainability, expandability, etc should be taken into account.
Data Flow Diagram :
The data flow diagram (DFD) is one of the most important tools used by system analysts. Data flow diagrams are made up of a number symbols, which represent system components. Most data flow modeling methods use four kinds of symbols. These symbols are used to represent four kinds of system components. Processes, data stores, data flows and external entities. Processes are represented by circles in dfd. Data Flow represented by a thin line in the dfd and each data store has a unique name and represented by open rectangles and square or rectangle represents external entities.
Unlike detailed flowchart, Data Flow Diagrams do not supply detailed description of the modules but graphically describes a system’s data and how the data interact with the system.
To construct a Data Flow Diagram, we use,
• Arrow
• Circles
• Open End Box
• Squares
TABLE DESIGN
Database Design :
A database is a collection of interrelated data stored with minimum redundancy to serve many users quickly and efficiently. The general objective of database design is to make the data access easy, inexpensive and flexible to the user.