ccccccccccccccccccccccccccccccccccccccccccc c
c c cccccccccccccccccccccccccccccccccccccccccccccc
c
A study or a project of this volume can never be the outcome of a single person or just a mere group of dedicated students. We are indebted to our subject teacher c for beingcthe epitome of guidance during the entire project. We are also thankful to ccc cc c for their encouragement. Without their help this project would not have seen the light of day. we are happy to present a vote of thanks to them for their sincere advice and co-operation that they have lent us unconditionally. c c c
c c c c c c c c ccccccccccccccccccc c c cccccccccccccccccccccccccc
ccccccccccccccccccccccccccccccccccccccccccc c c ccccccccccccccccccccccccccccccc cc c
c c c ! c "# cc # cc cc "c c $ c %& c c '# (c c ) c "cc"'# " cc * c ccccc"cc " c cccc ccc " c cccc cc " cc " c cccc cc "%c c + c c c , c
c-c
c
c . c# #"cc *c c / c " *%c0c"" c c
ccccccccccccccccccccccccccccccccccccccccccc ccccccccccc
c c c c c9o
c
c
assist and ease the works of the Retail Outlet of Any 9ype of Companies, in particular,
Payroll Management System is being developed. 9his would comprise the features that can be operated easily. *12 33c 114c 2cwould take care of the day to day Attendance of All Employee. It covers activities from keeping the details of day to day In, Out, OD etc. 9he master and transaction activities are divided in modules so that the activities can be operated easily. 9he regular backup to the data can be taken and the backup data can be restored effectively. So, the Payroll Management System assists the employees of Company in each and every aspect of In and Out. 9he Payroll Management System is customized software and developed according to the needs of Any 9ype Company.c c
ccccccccccccccccccccccccccccccccccccc ccccccc c c c c c c c c c
ccccccccccccccccccccccccccccccccccccccccccc c c c "# c c 5c * %"c % c c 6c c 11c 1c 3c 7c 328c 1c 166 c 16c 32c7 1c16cc6cc 1932c1331c16c c12 33c5:.
c 9 9;cc 9he purpose of this section is to obtain agreement regarding the objectives the system must meet. Ultimately this segment defines the boundaries of the effort. 9he ³ Payroll system´ helps administrator honor their professional commitments by following a tailored version of the organization¶s standard process. 9his application is supported by a database consisting of employee¶s salary details and their leave allowances. Based on these details at the end of every month the application automatically credits the employee¶s bank account with their salary. 9he amount of salary credited into employees account is a variant of their leave allowances .9his *12 33c * 4c application also considers employee¶s income tax regulations and loan payment details. Based on these considerations the salary of each employee is deducted at the source. 9aking into account all these aspects the appropriate accounts of each employee are credited. 9his application also includes generation of salary slips to every employee.
c c 9he payroll Processing System is an application of LBRCE±JKC. Its target user group consists of Admin, Employees.
c * cc 9he Purpose of the project is to maintain the information regarding the employee and generates the pay slip.
ccccccccccccccccccccccccccccccccccccccccccc c c c c ccc enerating ID¶s and pay slips for the employees 9his project is a distributed endeavor that strives to employ languages that promote platform independence and make it possible to support desktop and laptop systems in traditional and wireless networking infrastructures .Efforts must be focused on business logic issues rather thanc Event Driven Web based System PPS System Business Logic Data Access Personal Persistent Data Repository Storage Subsystem Application Layer Interface Application Layer needlessly duplicating user interface software, database software, etc. Its main focus is on the generation of reports at any time.c
ccccccccccccccccccccccc ccccccccccccccccccccccccccc c c c c c c c c c c c
ccccccccccccccccccccccccccccccccccccccccccc c c c c cccccccccccccccccccccc %c& c-c '# (c "c c " "c"'# " cc ´c 7;1 c"< c Ãc 9URBO C++ Ãc MS DOS Ãc WINDOWS XP Ãc MICROSOF9 OFFICE ACCESS 2003 ´c c1 6;1 c"< c Ãc CPU ± Intel Core 2 Duo E7300 Ãc RAM ± 1 B (MIN) Ãc ard disk ± 160 B Ãc Operating System ± Windows XP with Service Pack 3 (C9) c
c c
ccccccccccccccccccccccccc c c c
ccccccccccccccccccccccccccccccccccccccccccc c c c cccccccccc ccccccccccccccc "c"'# " c * c c c 13c"< c
c
"# =c c Requirements analysis is usually the first phase of large-scale software development project. It is undertaken after a feasibility study has been performed to define the precise costs and benefits of a software system. 9he purpose of this phase is to identify and document the exact requirements for the system. 9he customer, the developer, a marketing organization or any combination of the three may perform such study. In cases where the requirements are not clear e.g., for a system that is never been defined, more interaction is required between the user and the developer. 9he requirements at this stage are in end-user terms c
6 1 c63c c c c1=c4c :cID, Password.c * c=cClick on the login link. If administrator enters ID and password correct it goes to the admin services otherwise displays the same page with an error message. c=cDisplays the admin services page.
ccccccccccccccccccccccccccccccccccccccccccc ! c c1=c 66c;c32cc c: Name, Id, designation, Date of joining. * c= A new employee can be added into the system and admin can update his details. c: 9he employee can be credited salary based upon his details.
c $ c c1=c 131 2c613 c: Id, designation, basic salary, PF, DA, RA. * c: 9he admin can update his salary details c: Employee salary details will be updated to the database.
) c c1=c1c613c c: Id, Loan number, EMI, Repaid amount, Balance amount. * c: Administrator can update a particular employee¶s loan details. c: Employee Loan details will be updated to the database.
c + c c1=c19c613c c: Id, 9ype of leave, Number of Leaves. * c: Administrator updates the leave details. c: Employee Leave details will be updated to the database.
c , c c1=c 1>c613c c: Id, Basic salary, 9ax percentage, income tax. * c: 9he tax details of an employee can be updated by the administrator. c: Employee 9ax details will be updated to the database.
c . c c1=c 131 2c3c c: Id, Basic salary, Designation, Net pay. * c: Based on the leave, loan , tax details the slip will be generated c: Salary slip will be generated.
ccccccccccccccccccccccccccccccccccccccccccc c c c c / c c1=c1:c613c c: Id, Designation, salary * c: 9he employee¶s salary is credited to bank. c: Employee can View and receive the salary.
c 32c63c c c c1=c4c c=cID, Password.c * c=cClick on the login link. If Employee enters ID and password correct it goes to the other page otherwise displays the same page with an error message. c=cDisplays the Information to be viewed by an employee.
! c c1=c#61c 73c c: Id, Name, Designation, Email-id, Mobile number, Address, key skills, qualification * c: 9he employee can update his profile if any modifications occur in his details c: 9he details of an employee can be updated
$ c c1=c514c1; 6c c: Id, Old password, New password * c: Employee can be able to change his password by using this test case c: Employee new password will be updated
c
ccccccccccccccccccccccccccccccccccccccccccc ) c c1=c ;c1 4c c: ID, Month, Year. * c: 9he earnings can be displayed by this test case c: 9he total earnings of an employee for the specified month and year can be viewed
c + c c1=c ;c66c c: Id, Month, Year * c: 9he deductions can be known by using this test case c: 9he total deductions of an employee for the specified month and year can be viewed
c , c c1=c ;c131 2c3c c: Id, Month, Year. * c: 9he employee can view the salary slip. c: 9he salary slip of an employee for the specified month and year can be viewed.
> 13c 71c"< c c # c 71c 1. Login Screenc 2. Menu selection Screen 3. Employee Salary Details 4. Employee Loan Details 5. Employee Leave Details 6. Employee 9ax Details 7. enerate Salary Slip 8. Employee Bank Details c c c
ccccccccccccccccccccccccccccccccccccccccccc 1 6;1 c 71c Server Configuration: Minimum 2 B ard Disk P-III processor or equivalent Ram 512 MB Windows with Apache preloaded. Client Configuration A terminal with Internet Explorer and Printer. 7;1 c 71 Operating system ± WindowsXP/2000c Language -- JSP Database ± Oracle Network -- LAN c 1c 71c Communications interfaces can be provided through e-mail, web browser, network server communications protocols, electronic forms, and so on. For this we can use communication standards such as F9P or 99P to provide security using encryption algorithms and synchronization mechanisms
c * 7 1c"< c System can withstand even though many number of users requested desired service. As we are keeping office level server of the automated payroll system. And access is given to the only registered users of office who requires the services of viewing, Updating etc. It can withstand the load.
172c-c"31?32c"< c By incorporating a robust and proven SQL into the system, reliable performance and integrity of data is ensured. 9here must be a power backup for server system.
ccccccccccccccccccccccccccccccccccccccccccc 2c"< c Sensitive data is protected from unwanted access by users appropriate technology and implementing strict user- access criteria.
c c c c c " c c 161 6c31c c 5cc32c;5c5c 161 6=c c All Organisations who pay employees. Payroll Practitioners: - Payroll Managers, Payroll Supervisors, Payroll Officers and Payroll System Administrators. Payroll Accountants and Finance / Accounting staff responsible for the management of Payroll. uman Resources staff responsible for the management of Payroll. Payroll Management - Consultants and Compliance Professionals. Payroll Management Auditors ( internal and external)c c
1 6;1 c31c c 9he other big problem associated with in sourcing payroll is that it forces companies to take on the burdens associated with hardware upgrades as well as the personnel costs linked to system maintenance.. ardware must be purchased for data storage and processing. c
c c
ccccccccccccccccccccccccccccccccccccccccccc ?c Menu-driven programs with user friendly interface with simply hyper links. It is very easy to use.
c
2c Sensitive data is protected from unwanted access by users appropriate technology and implementing strict user- access criteria. companies in this situation also struggle to secure data,a growing concern given some of the high profile cases reported in the media involving lost,breached and stolen data.
c
111?32c c Backup mechanisms are considered for maintainability of software as well as database. As it is object oriented reusability exists. As project is based on MVC architecture, testability existsJc
c c c c c c c c c c c c c c c
ccccccccccccccccccccccccccccccccccccccccccc c c c c c c c c "c@c " cc c
c c Drawing Entity Relationship diagram between the various entities of any Payroll System.Example relationship between departments and employee, Leaves and Employee, etc., Drawing the same will help to normalize and improve the Database Design.
c
ccccccccccccccccccccccccccccccccccccccccccc 1@ 1c614 1c State-transition diagrams (S9D) show how the system behaves as a consequence of some external event. For this purpose the S9D represents the state of the system and the transitions into different states when an external event happens. 9he structure of the data items within these models may be described in more detail within the data dictionary. Similarly, the models will contain a more detailed description of the key processes taking place
c c c c c c c c c c c c c c c c c c c c
ccccccccccccccccccccccccccccccccccccccccccc "c =c
c c c c
ccccccccccccccccccccccccccccccccccccccccccc "c *%c=c c
c c c c
ccccccccccccccccccccccccccccccccccccccccccc c "%: 9he Payroll Data Element Dictionary contains all the elements found in the U-M Data Warehouse Payroll 9ables, ordered alphabetically by element name. ere is a description of the information that the dictionary provides for each element. Physical Element NameU Name for the element you can use in SQL queries. Logical Element NameUDescriptive name of the element. Format 9ypeU9ype of value of the element (for example: character, number, or date). Data SetsU9he names of the data sets that contain the element. 9able LocationsU9he names of the tables in which the element is located. Security CodeU9he level of security imposed on the element. Values are: Public data: Data with no access restriction that may be released to the general public. Private/Confidential data: Data available to University employees who need to access these data to perform their official University duties. Unless otherwise noted, all institutional data is designated as Private/Confidential. Sensitive data: Data available only to University employees who have specific authorization for access. Never release sensitive data in a manner that enables identifying data element values with a specific person or persons. Element DefinitionUDescription of the element.
c c c
ccccccccccccccccccccccccccccccccccccccccccc cc " c=c
93cAc7 c12 33cc
ccccccccccccccccccccccccccccccccccccccccccc ccccccccccccccccccccccccccccc
1c7c5c Bc
Not supports web based operations Multiprocessing not allowed. Extensive help is not provided. Not support in the OS lower than windows
ccccccccccccccccccccccccccccccccccccccccccc 69114c7c>4c2c It is very simple in nature & doesn¶t provide much functionality, thus reducing complexity of the system.It doesn¶t require employees to know about computers at all i.e. it doesn¶t require training its employees any special technique except of simple bill preparation and book keeping. Because of manual work it doesn¶t require any investment in computers or any other peripherals. Since there is no systems at all there is no need to keep available the facilities like 24- hour power backup or other facilities.
169114c7c>4c2c 9he disadvantages of current system are all those associated with manual working systems. It is time consuming to produce bills or reports as compared to any other computerized system. umans are more probes to errors so always possibility of errors in producing results. As all the work done is written on registers if any register is missed or damaged it is simply very difficult to produce to present accurate figures.Employees can make fraud by writing wrong entries on register and take away the money and it is simply impossible to catch the defaulter because there is no proof.
c c c c c c
ccccccccccccccccccccccccccccccccccccccccccc c c c 9his project has many future applications like it can be used in any of the Retail Outlet of Any 9ype companies. 9his project was build keeping in mind all the requirements of these outlets and they can be implemented in any such type of organization with very few modification. With modifications it can be possible for Employee Attendance to control all retail outlets by connecting them through a network. Because of this software all they need is a Server application and any type of connectivity to that server.
cccccccccccccccccccccccccccccccccccccccc c c c c c c c c c
ccccccccccccccccccccccccccccccccccccccccccc ccccccccccccccccccccccccccccccccc"" c0c " *%c c
c c JJc J Jc J Jc
! ?:c Software engineering - Shalini puri Software engineering - Pressman Software engineering - Saumerwilli [ [
[
c c
c
