Category: CSE Mini Projects

• Department Master
• Leave Register
• Employee Master
• Pay Slip
• Staff Appointment Master
• Staff Relive Master 

Table Name: Department 

Field Name	Data Type	Constrains	Description
Dcode	Text	P/K	Department Code
Dname	Text	NOT NULL	Department Name

 Table Name: Employee 

Field Name	Data Type	Constrains	Description
Ecode	Text	P/K	Employee Code
Ename	Text	NOT NULL	Employee Name
Dname	Text	NOT NULL	Department Name
Shift	Number	NOT NULL	Shift
Salaryday	Number	NOT NULL	Salaryday
Apno	Number	NOT NULL	Appoinment Number
Esiper	Number	NOT NULL	Esi Percentage
Pfper	Number	NOT NULL	Pf Percentage
Esino	Text	NOT NULL	Esi Number
Pfno	Text	NOT NULL	Pf Number

 Table Name: Leave Register 

Field Name		Data Type	Constrains	Description
Ecode	Text		NOT NULL	Employee Code
Ename	Text		NOT NULL	Employee  Name
Monthyear	Text		NOT NULL	Month Year
Flag	Text		NOT NULL	Flag
Nod	Number		NOT NULL	No Of Days

 Table Name: Pay slip

Field Name		Data Type	Constrains	Description
Ecode	Text		R/K	Employee Code
Ename	Text		NOT NULL	Employee Name
Sdate	Date/Time		NOT NULL	Salarydate
Myear	Number		NOT NULL	Month Year
Sday	Number		NOT NULL	Salary Day
Noofday	Number		NOT NULL	No Of Day
Pay	Number		NOT NULL	Pay
Esino	Text		NOT NULL	Esi Number
Pfno	Text		NOT NULL	Pf Number
Pfper	Number		NOT NULL	Pf Percentage
Esiper	Number		NOT NULL	Esi Percentage
Pfamt	Number		NOT NULL	Pf Amount
Hramt	Number		NOT NULL	Hra Amount
Daamt	Number		NOT NULL	Da Amount
Taamt	Number		NOT NULL	Travel Amount
Oaamt1	Number		NOT NULL	Other Amount 1
Oaamt2	Number		NOT NULL	Other Amount 2
Totalsal	Number		NOT NULL	Total Salary
Canteen	Number		NOT NULL	Canteen
Sadvance	Number		NOT NULL	Salary Advance
Netpay	Number		NOT NULL	Net Pay

 Table Name: Staff Appointment 

Field Name		Data Type	Constrains	Description
Apno	Number		P/K	Appoinment Number
Apdate	Date/Time		NOT NULL	Appoinment Date
Name	Text		NOT NULL	Name
Sex	Text		NOT NULL	Sex
Dob	Date/Time		NOT NULL	Date Of Birth
Addr	Text		NOT NULL	Address
Quality	Text		NOT NULL	Quality
Salary	Text		NOT NULL	Salary
Fname	Text		NOT NULL	Father Name
Martialst	Text		NOT NULL	Marital Status
Appas	Text		NOT NULL	Appointed As
Std	Text		NOT NULL	Standard
Prevexp	Text		NOT NULL	Previous Experience

 Table Name: Relive 

Field Name		Data Type	Constrains	Description
Relno	Number		P/K	Releive Number
Apno	Number		R/K	Appoinment Number
Ename	Text		NOT NULL	Employee Name
Reason	Text		NOT NULL	Reason

In this phase the existing system has been studied, the problem is identified, the alternative solutions are analyzed and the best solution has been selected after the feasibility analysis. 

In this step the following steps are carried out: 

                                      1. Existing System

                                      2. Proposed System

                                      3. Comparative System 

              The need for the system stems from the nature of the organization.  In order to justify and appreciate the need for the system, we have to study the existing system.  By conducting the system study, we are able to find out what are the goals specified, whether all the objectives are satisfier, what are the disadvantages of the existing system etc. Here the existing system is maintained manually.  So to computerize this, we must bind the system by identifying the scope of the function and performance that are desired.

                The existing system is maintained manually. In the present system whenever the customer gives an order it is maintained manually in the notebook. Manually they have to update the production order, production plan of items, production monitoring etc.  So the present system is not good enough for the company.

      The disadvantage of the existing system is

• File maintenance is extremely difficult as every thing is done manually.
• Information retrieval is difficult and time consuming.
• Quick analysis of delivery is not possible.
• Not enough security and privacy.
• Requires much human effort.
• Information need not be accurate. 

          The proposed “Payroll Management System” is developed to systematically maintain the employee details and their Appointment Details and their Payroll calculations. This system reduces the Manual File Maintenance and easy to view the details about the particular employee details. This system reduces the manual calculation for employee pay slip. 

Comparative Systems Study

While Comparing the Existing system and proposed system, proposed system is best due to the following reasons 

• Speed of process increases.
• After performing a long period human becomes tired, but computer works for a long time continuously (Diligence).
• Accuracy is more.
• Deleting, Copying, Updating is possible.
• Processing Time will be decreased.
• More Security. 
• Backup is available.