Employee paroll system

1

1. ABSTRACT This project is for all information of employee in a company it ha has s a se sec curit ity y le leve vell fo forr ev ever ery y use serr th thro rou ugh whic ich h unauthorized user is not allowed to enter and view data. In future easy enhancement may be possible. So this system provides the facility to auto mate data processing making the system error free and easy to access. Platform independency-

.

Since on a net Since networ work, k, use users rs can use dif differ ferent ent ope operat rating ing system.We are implementing in java to fulfill.

Employee Payroll System

2

2. INTRODUCTION


3

2.1 PROJECT PROFILE Today almost every organization or educational institute has its own payroll system to support its work within the organization.

The organizations need to maintain the record all the employee, so that no one can misuse the resources allocated to the users in the organization.

Our payroll record system is such a system that can be used to solve this purpose.

This system can be used in organizations to maintain the work of its emp employ loyees ees,, in edu educat cation ional al ins instit titute utes, s, org organi anisat sation ion to maintain the record of all employee.


4

A. OBJECTIVE Our objective is to learn the concept behind the payroll system, and an d to le lear arn n ne new w te tech chno nolo logi gies es li like ke Sw Swin ings gs pr prog ogra ramm mmin ing g by implementing this concept practically.

The ultimate aim is achieved through-

1. Understanding and analyzing the problem statement. 2. Identify the input and output requirements of the system.

3. Des Design igning ing a use user-f r-frie riendl ndly y int interf erface ace to int intera eract ct wit with h the

system Implementing and deploying the system. 4. Preparing a well-organized documentation of the project to

understand the system and it’s working.

B. PURPOSE Employee Payroll System

5

Almost every organization or educational institute has its own Staff to support its work within the organization. The orga or gani niza zati tion ons s ne need ed to wo work rk an and d ev ever ery y em empl ploy oyee ee ge gett pe perf rfec ectt sallary. so that no one can misu sa sus se the resources in the organization. We need to develop such a payroll system that can perform following tasks-

•

Can enter the new employee entry.

•

Can see the exit employee detail.

•

Can maintain the exit employee salary record.

•

Can make a new month salary.

That system should support organizations to maintain the salary record of its employees


6

3. SYSTEM ANALYSIS

3.1 PRESENT SYSTEM & ITS LIMITATION


7

It will work in one portal. We have now a great solution for payroll system in our hand, but still it have some limitations. We can run this system and maintain all pay record of employee and employee can’t open because the region of user name password The other limitation of the system is that the client should have Java installed on it otherwise the system will not work. Further Enhancements and Suggestions, we can maintain the record up ten year past & ten year future. We will try to resolve this limitation in our future work.

3.2 NEED OF THE SYSTEM Employee Payroll System

8

The system will be used for following purpose in any organization•

•

•

•

To maintain the payroll system of the employee. To To rest restri rict ct empo empoly lyee ee from from perf perfor ormi ming ng ille illega gall task task and and misuse resources.

To get the performance.

information

regarding

the

employee

To communicate with the employee for giving instructions or other reasons.


9

3.3 PROPOSED SYSTEM AND IT’S ADVANTAGE

In thi his s pr proj ojec ectt we ar are e lo look okin ing g to pr prov ovid ide e the fac acil ilit ity y to Admi Ad mini nist stra rato torr to ma main inta tain in th the e pa pay y re reco cord rd of em empo poly lyee ee.. A registered user can work freely.They can change the record of the employee .This is the most important advantage because administrator can deal this task on sitting.


10

3.5 HARDWARE AND SOFTWARE REQUIREMENT Hardware Infrastructure Required: System Type

:

Personal Computer.

Processor Type

:

Celeron 1.79 GHz or higher.

RAM

:

256 MB or higher.

HDD

:

At least 1000 Mb of free space for Good performance. 25 Mb space required to install.

SVGA Modes

:

256 color or higher and 800*600 Resolution.

Software Infrastructure Required: Operating System

:

Windows 9x, NT, Me or XP

Other Software

:

JDK1.5 and Above

Developed on

:

JAVA


11

3.6 FEASIBILITY STUDY

•

Technical Feasibility The project uses the technologies that are best and easily available to us, so it is technically feasible.

•

Economical Feasibility

Many times it creates problem when someone tries to harm the system with malicious intensions. Economically, it costs almost nothing in comparison of those harms. •

Behavioral Feasibility

Many times creates problem when someone tries to harm the system with malicious intensions. For this reason many people need some kind of network monitoring system.


12

4. SYSTEM DESIGN


13

4.1Data Flow Diagram 0-Level

Payroll information

system

Apply to login

Denied permission

Approve

Access the information Add,modify,delete

Registration


Report,view

Data

base

14

5.ER DIAGRAM


15

emp_name

emp_reg

Emp id

sex

payrool primdet

e m e p o l h a y e s

addres s

fnam e

years el

empolyee secdet

Salar y

photo

emp_i d

l o g i n

User name

Login_det


password

16

6. TECHNICAL SPECIFICATION


17

6.1 TECHNOLOGY UESD We will implement our project in JAVA, one of the most powerful languages.

Java Development Kit When the java programming language was introduced in 1995, the only development tool available was the JDK from sun. This set of command line tools makes it possible to write, compile and debu de bug g JA JAVA VA pr prog ogra rams ms.. Ho Howe weve ver, r, th the e JD JDK K is th the e fa farr cr cry y fr from om integrated integ rated development development environment environment such as Visua Visuall Basic and Borland c++. An integrated development environment (IDE) is software that combines several development tools into a single, cohesive package. The assortment usually includes a source code editor, compiler debugger and other utilities. These tools work togeth tog ether er the dev develo elopme pment nt pro proces cess; s; mo most st pac packag kages es are hig highly hly visual and rely on windows, drag and drop, and other graphical elem el emen ents ts.. Th The e go goal al is to ma make ke so soft ftwa ware re de desi sign gn fa fast ster er,, mo more re efficient, and easier to debug.


18

Characteristics of Java •

JAVA is object oriented

Object oriented programming is a power full way of organizing and developing software. Object oriented programming uses a set of components called objects. These objects exist independently of each other and communicate with each other. That’s why object oriented program are more adoptable and more bug proof.

•

JAVA is small and simple

The most complex parts of c++ were excluded from java, such as pointers and memory management. These elements are complicated to use and are thus easy to se incorrectl incorrectly. y.

•

JAVA is safe

Another thing essential to java’s success is that it is safe. Java provides security and several different levels. Before a java program is run, a verifier check each by code to make sure nothing suspicious is going on.

•

JAVA is platform independent

Platform independence is another way of saying that java is architectural neutral. The basically means that java programs don’t care what system they are running on.


19 •

JAVA is architectural neutral

The JAVA designers made several hard decisions in the java languages and JVM is an attempt to alter the situation programs not running on the same machine after few days. Their goal was “Write once; run anywhere, anytime, forever”.

•

JAVA is Distributed

Java is designed for the distributed environment of Internet beca be caus use e it ha hand ndle les s TC TCP/ P/IP IP pr prot otoc ocol ols. s. Th The e fe feat atur ure e of in inte terraddres add ress-s s-spac pace e mes messag saging ing is don done e wit with h the hel help p of pac packag kage e Remo Re mote te Me Meth thod od In Invo voca cati tion on (R (RMI MI). ). Th This is fe feat atur ure e br brin ings gs an unpa un parral alllel eled ed

lev evel el

of

ins nstr tru ucti tion ons s

to

the

clie ien nt/ t/se serrve verr

programming.

•

JAVA is dynamic

Java Java pro progra grams ms car carry ry wit with h the them m su subst bstant antial ial amo amount unts s of run time ti me ty type pe inf nfor orm mat atiion tha hatt is use to ve verrif ify y and res eso olv lve e accesses to objects at run time. This is crucial to the robustness to the applet environment.


20

6.2 TECHNICAL INFORMATION Swings Swing is set of classes that provide more powerful and flexible functionality than is possible with the standard AWT components. In addition to the familiar components, such as buttons, check boxes, boxes, and labels labels,, Swings Swings suppli supplies es severa severall exciti exciting ng additi additions ons including tabbed panes, scroll panes, trees, and a button may have have both both imag image e and and text text stri string ng asso associ ciat ated ed with with it. it. Also Also the the image can be changed as the state of the button changes. Swin Swing g is buil builtt upon upon the the foun founda dati tion on of the the AWT. AWT. Unli Unlike ke AWT AWT components, Swing component are not implemented by platform spec sp ecif ific ic code code.. Inst Instea ead d they they are are writ writte ten n enti entire rely ly in Java Java and and therefore are platform independent. The term lightweight is used to describe such elements. The class Swing Utilities, which provides methods that, facilitates the use of Swing. The Swing related classes are contained in javax.swing.tree javax.swing.tree and its sub packages, such as javax.swing.tree. javax.swing.tree. Swi Swing is a large arge sy syst stem em,, and and it has has many any feat featur ures es.. Swi Swing prov provid ides es tool toolba bar, r, tool tool tips tips,, and and prog progre ress ss bars bars.. Also Also swin swing g component can provide a pluggable look and feel, which means that it is easy to substitute another appearance and behavior for an element. This can be also done dynamically. We may design our own look and feel. Because of the power of swing, it has become the approach of first choice by many programmers for creating GUIs


21

SQL SERVER DATABASE

A database management, or DBMS, gives the user access to their data and helps them transform the data into information. Such Such databa database se manag manageme ement nt syste systems ms includ include e dBase, dBase, parado paradox, x, IMS, SQL Server Server and SQL Server. Server. These systems systems allow allow users to create, update and extract information from their database.

A database is is a structured structured collection of of data. Data refers to to the charac character terist istics ics of people, people, things things and events. events.

SQL Server Server

stores stores each data item item in its own fields. fields. In SQL Server, Server, the fields fields rela relati ting ng to a part partic icul ular ar pers person on,, thin thing g or even eventt are are bund bundle led d together to form a single complete unit of data, called a record (it can also be referred to as raw or an occurrence). occurrence). Each record is made up of a number number of fields. No two fields fields in a record can can have the same field name.

During an SQL Server Database design project, the analysis of your business needs identifies all the fields or attributes of intere interest. st.

If your busines business s needs change change over time, time, you define define

any additional fields or change the definition of existing fields.


22

SQL Server Tables SQL Server stores records records relating relating to each other in a table. table. Different tables are created for the various groups of information. Related tables are grouped together to form a database.

Primary Key Every table in SQL Server has a field or a combination of fiel fields ds that that unique uniquely ly iden identi tifi fies es each each record record in the the tabl table. e.

The The

Unique identifier is called the Primary Key, or simply the Key. The primary key provides the means to distinguish one record from from all other other in a table. table.

It allows allows the user user and the databa database se

system to identify, locate and refer to one particular record in the database.

Relational Database Some Someti time mes s all all the the info inform rmat atio ion n of inte intere rest st to a busi busine ness ss operation operation can be stored stored in one table. table. SQL Server Server makes makes it very easy to link the data in multiple tables. Matching an employee to the department in in which they they work is one example. This is what what makes SQL Server a relational database management system, or RDBMS. RDBMS. It stores stores data in two two or more tables tables and and enables enables you to define relationships between the table and enables you to define relationships between the tables.


23

Foreign Key When When a fiel field d is one one tabl table e matc matche hes s the the prim primar ary y key key of another another field field is referred referred to as a foreign foreign key. key. A foreign foreign key is a field or a group of fields in one table whose values match those of the primary key of another table.

Referential Integrity Not only does SQL Server allow you to link multiple tables, it also also mainta maintains ins consist consistenc ency y betwee between n them. them.

Ensur Ensuring ing that the

data among related tables is correctly matched is referred to as maintaining referential integrity.

Data Abstraction A major purpose of a database system is to provide users with with an abstract abstract view view of the data. data. det details

of how the

This This system system hides certai certain n

data is stored and maintained. Data

abstraction is divided into three levels.

Physical level: This is the lowest level of abstraction at which one describes how the data are actually stored.

Conceptual Level: At this level of database abstraction all the attrib attribute uted d and what what data data are actual actually ly stored stored is descri described bed and entries and relationship among them.

View level: This is the highest level of abstraction at which one describes only part of the database. Employee Payroll System

24

Advantages of RDBMS

•

Redundancy can be avoided

•

Inconsistency can be eliminated

•

Data can be Shared

•

Standards can be enforced

•

Security restrictions restrictions ca be applied

•

Integrity can be maintained

•

Conflicting requirements can be balanced

•

Data independence can be achieved.

Disadvantages of DBMS

A significan significantt disadvantag disadvantage e of the DBMS system system is cost. cost. In addition to the cost of purchasing of developing the software, the hardware has to be upgraded to allow for the extensive programs and and the the work worksp spac ace e requ requir ired ed for for thei theirr exec execut utio ion n and and stor storag age. e. While centralization reduces duplication, the lack of duplication requires that the database be adequately backed up so that in case of failure the data can be recovered.


25

FEATURES OF SQL SERVER (RDBMS )

SQL SERVER is one of the leading database management systems (DBMS) because it is the only Database that meets the unco uncomp mpro romi misi sing ng

requ requir irem emen ents ts

informati information on systems. systems.

of

toda today’ y’s s

most most

dema demand ndin ing g

From complex complex decisio decision n support support systems systems

(DSS) to the most rigorous online transaction processing (OLTP) application, even application that require simultaneous DSS and OLTP OLTP acce access ss to the the same same crit critic ical al data data,, SQL SQL Serv Server er lead leads s the the industry in both performance and capability

SQL SERVER is a truly portable, distributed, and open DBMS that deliv deliver ers s unma unmatc tche hed d perf perfor orma manc nce, e, cont contin inuo uous us oper operat atio ion n and and support for every database.

SQL SERVER SERVER RDBMS RDBMS is high high perfor performan mance ce fault fault tolera tolerant nt DBMS DBMS which is specially designed for online transactions processing and for handling large database application.

SQL SQL SERV SERVER ER with with tran transa sact ctio ions ns proc proces essi sing ng opti option on offe offers rs two two feat featur ures es whic which h cont contri ribu bute te to very very high high leve levell of tran transa sact ctio ion n processing throughput, which are

•

The row level lock manager


26

Enterprise wide Data Sharing The The unri unriva vale led d port portab abil ilit ity y and and conn connec ecti tivi vity ty of the the SQL SQL SERVER DBMS enables all the systems in the organization to be linked into a singular, integrated computing resource.

Portability SQL SQL SERV SERVER ER is full fully y port portab able le to more more than than 80 dist distin inct ct hard hardwa ware re and and oper operat atin ing g sy syst stem ems s plat platfo form rms, s, incl includ udin ing g UNIX UNIX,, MSDOS, MSDOS, OS/2, OS/2, Macint Macintosh osh and dozens dozens of propr propriet ietary ary platf platform orms. s. This portability gives complete freedom to choose the database sever platform that meets the system requirements.

Open Systems SQL SERVER offers a leading implementation of industry – standard standard SQL. SQL.

SQL Server’ Server’s s open architec architecture ture integrat integrates es SQL

SERV SERVER ER and and non non –SQL –SQL SERV SERVER ER DBMS DBMS with with indu indust stri ries es most most compre comprehen hensiv sive e collec collectio tion n of tools, tools, applic applicati ation, on, and third third party party soft softwa ware re prod produc ucts ts SQL SQL Serv Server er’s ’s Open Open arch archit itec ectu ture re prov provid ides es transparent access to data from other relational database and even non-relational database.


27

Distributed Data Sharing SQL

Server’s

networking

and

distributed

database

capabilities to access data stored on remote server with the same ease as if the information was stored on a single local computer. A single SQL statement can access data at multiple sites. You can store store data data where where system system requir requireme ements nts such such as perfor performan mance, ce, security or availability dictate.

Unmatched Performance The most advanced architecture in the industry allows the SQL SERVER DBMS to deliver unmatched performance.

Sophisticated Concurrency Control Real Real World World applic applicati ations ons demand demand access access to criti critical cal data. data. With most database database Systems Systems applicati application on becomes becomes “content “contention ion bound” – which which performa performance nce is limited limited not by the the CPU power power or by disk I/O, but user waiting on one another for data access . SQL Server employs full, unrestricted row-level locking and contention free queries to minimize and in many cases entirely eliminates contention wait times.


28

No I/O Bottlenecks SQL Server’s fast commit groups commit and deferred write techno technolog logies ies drama dramatic ticall ally y reduce reduce dis disk k I/O bottle bottlenec necks. ks. While While some database write whole data block to disk at commit time, SQL Server commits transactions with at most sequential log file on disk disk at comm commit it time time,, On high high thro throug ughp hput ut sy syst stem ems, s, one one sequential sequential writes writes typically typically group group commit commit multiple multiple transacti transactions. ons. Data read by the transaction remains as shared memory so that other transactions may access that data without reading it again from from disk.

Since Since fast commit commits s write write all data data necessar necessary y to the

recovery to the log file, modified blocks are written back to the database independently of the transaction commit, when written from memory to disk.


29

7. TESTING

Soft So ftw war are e te test stin ing g is a cr criiti tica call

ele el eme men nt of sof ofttwar are e qu qual alit ity y

assurance assur ance and repr represent esents s the ulti ultimate mate revi review ew of speci specificat fication, ion, design and code generation. Once source code has been generated, software must be tested to un unco cove verr as ma many ny er erro rors rs as po poss ssib ible le be befo fore re de deli live very ry to th the e customer. Our goal is to design a series of test cases that have a high like li keli liho hood od of fi fin ndi ding ng er erro rors rs.. Th That at’s ’s wh wher ere e so soft ftwa ware re te test stin ing g techniques come into the picture. These techniques provide systematic guidance for designing tests that th at ex exer erci cise se th the e in inte tern rnal al lo logi gic c of so soft ftwa ware re co comp mpon onen ents ts an and d exercise the input and output domains of the program to uncover errors in program function, behavior and performance.

For this testing techniques are used. These techniques provide systematic guidance for designing tests that (1) Exercise the internal logic of software components and (2)) Ex (2 Exer erci cise se th the e in inpu putt an and d ou outp tput ut do doma main ins s of th the e pr prog ogra ram m to uncover errors in program function, behavior and performance.


30

Testing objective

A number of rules that can serve as testing objectives are: 1. Testi Testing ng is a process of executi executing ng a program program with the intent intent of finding an error. 2. A good test case case is one that that a high probabili probability ty of finding finding an as-yet-undiscovered as-yet-undiscover ed error. 3. A

successful

test

is

one

that

uncovers

an

as-yet-

undiscovered error.

Testing Methods All tests should be traceable back to some requirements of the customer. The test should be planned before testing testing begin begins s and as soon as requirements model is complete. The The ea earl rlie ierr te test st pl plan anne ned d an and d ex exec ecut uted ed fo focu cus s on in indi divi vidu dual al components. As testing progresses, focus shifts in an attempt to find errors in integrated cluster of components and ultimately in entire system. Exhaustive testing is not possible because it is impossible to execute every combination of paths during testing.


31

White Box Testing It is also called Glass Box Testing. It is a test case design method that uses control structure of the procedural design to deri derive ve test test case cases. s. Usin Using g Whit White e Box Box Test Testin ing g meth method ods, s, the the software engineer can derive test cases that guarantee that all inde indepe pend nden entt paths aths have ave been een exer exerc cised sed at leas leastt once. nce. Exer Exerci cise sed d all all rout routes es at thei theirr boun bounda dari ries es and and with within in thei theirr operational bounds. Exercised all logical decision on their true and false false sid sides. es. Exerci Exercised sed intern internal al data data struct structure ure to assure assure their validity.

Black Box Testing Black Box Testing focuses on the functional requirements of the sof ofttwa ware re.. Tha hatt is is,, Bl Bla ack Bo Box x Tes esti ting ng en enab able les s th the e software engineer to derive sets of input conditions that will fully ful ly exe exerc rcise ise all fun functi ctiona onall req requir uireme ements nts for a pro progra gram. m. Black Box Testing is not an alternative to White Box Testing. Rather, it is a complementary that is likely to uncover a different class of errors than White Box Testing. Black Box

Testing attempts to find errors on the following categories – 1. In-co In-correc rrectt or missing missing funct functions. ions. 2. Int Interf erface ace err errors ors.. 3. Err Errors ors in data structure structures s or external external database database access. 4. Per Perfor forman mance ce errors errors.. 5. Init Initializ ialization ation and and terminatio termination n errors. errors. 6. System Analysis


32

Process Model Used

Description Rapi Rapid d Ap Appl plic icat atio ion n Deve Develo lopm pmen entt is incr increm emen enta tall soft softwa ware re development process model that emphasizes an extremely short development cycle. The RAD model is a “high-speed” adapt daptat atio ion n

of line linear ar seque equen ntial tial model del

in

which ich

rapi apid

deve develo lopm pmen entt is achi achiev eved ed by us usin ing g comp compon onen entt-ba base sed d – construction.

•

Used Used primar primarily ily for inform informati ation on system systems s applic applicati ations ons,, the RAD approach encompasses the following phases:

•

Busine Business ss Modeli Modelingng- The inform informati ation on flow flow among among busine business ss functions is modeled in a way that answers the following questions: What information drives the business process? What information is generated? Who generates it? Where does the information go? Who processes it?

•

Data Modeling- The information defined as part the business modeling phase

refined into a set of data objects that

are needed to support the business. The

characteristics characteristics

of each object are identified and the relationship between these objects defined.

•

Proc Proces ess s mode modeli ling ng-- The The data data obje object cts s defi define ned d in the the data data-mode modeli ling ng phas phase e is info inform rmat atio ion n

flow flow

nece necess ssar ary y

tran transf sfor orme med d to achi achiev eve e the the to

impl implem emen entt


a

busi busine ness ss

33

funct function ion.. Proces Processin sing g descr descript iption ions s are creat created ed for adding adding,, modifying, deleting, or retrieving a data object. •

Appl Ap plic icat atio ion n gene genera rati tion on-- RAD RAD assu assume mes s the the us use e of four fourth th generation generation technique techniques. s. using

conventional

Rather Rather than creating creating software software third

generation

programming

languages the RAD process works to reuse existing program components or create reusable components. In all cases, automated tools are used to facilitate construction of the software.

Testing and turnoverSince RAD process emphasizes reuse many of the program components have have already been tested. This This reduces overall overall testing time. However new components must be tested and all interface must be fully exercised.


34

8.Forms


35


36


37


38


39

9. LIMITATIONS

We have now a great solution for network monitoring in our hand, but still it have some limitations. We can’t run this system in hidden mode i.e. client will know that he is being monitored. The other limitation of the system is that the client should have Java installed on it otherwise the system will not work.


40

10. FUTURE ENHANCEMENT Can be developed as a web based application. Many more modules can be added such as promotion. It can also include information about employee salary incensement.


41

11. CONCLUSION

This system is just an introduction to the world of software for employee payroll payroll information information system where every every record matter a lot and can make big difference can effect the employee carrier so this system provides the facility to automat employee data processing making the system error free and easy to access.


42

12. BIBLIOGRAPHY We have referred to lot of books as well as many websites that give us much information.

Except this we have in contact of many seniors as well as our faculty for getting some support related to our project. This is the list of books which we have referred-

1. JAVA The comple complete te reference reference By: Herbert shield 2. Java Ser Server ver Pag Pages es By: Larne Pekowsky 3. Java Servlet Servlet And JSP JSP Cookbook Cookbook By: O’Reilly 4. Softwa Software re Engineering Engineering A Practical Practical Approach Approach By: Roger S. Pressman 5. Java JavaSc Scrip riptt Pro Program grammin ming g By: Stephen Bucaro We referred following sites:

1. www.java.sun.com 2. www.java.com


Employee paroll system

Recommend Documents