A PROJECT REPORT

ON

ONLINE EMPLOYEE MANAGEMENT SYSTEM

for partial fulfillment for the degree
Of

BACHELOR OF COMPUTER APPLICATION

Submitted by

JAI KUMAR (6617002)

KALU GIRI (6617003)
KM.SUMAN (6617004)
Under the guidance of
(Internal Guide)
Mr. UmaKant Singh
(RJ Institute Of Higher Education Chondera)

CERTIFICATE

Certified that Jia Kumar,Kalu Giri &Km.Sumanhas carried out the project work
presented in this report entitled Online Employee Management System for the
award of Batchlor Of Computer Application from CCS University, Meerut
under the Guide of Umakant Singh. The report embodies result of original work
and studies carried out by Student himself and the contents of the report do not
form the basis for the award of any other degree to the candidate or to anybody
else.

Mr. Umakant Singh

(Lecturer)

DECLARATION

I hereby declare that the project work entitled ONLINE EMPLOYEE

MANEGEMENT SYSTEM submitted to the CCS University, Meerut, is a record
of an original work done by us under the supervision of Mr.Umakant singh,Project
guidance , and this project work is submitted in the partial fulfillment of there
requirements for the award of the degree of Master of Computer Application. The
results embodied in this thesis have not been submitted to any other University or
Institute for the award of any degree or diploma.

Umakant Singh
(Date: June 1, 2016)

ACKNOWLEDGEMENT

I owe a great many thanks to a great many people who helped and supported me
during the writing of this book.
My deepest thanks to Umakant Singh the under Guidence of the project for
guiding and correcting various documents of mine with attention and care. He has
taken pain to go through the project and make necessary correction as and when
needed.
I express my thanks to the Director of H3- Technologies Greater Noida
extending his support.

for

I would also thank my Institution and my faculty members without whom this
project would have been a distant reality. I also extend my heartfelt thanks to my
Friends and well wishers.

TABLE OF CONTENTS

S.No.
1.

Topic

Page No.

Introduction
1.1 Existing system

2.

Company profile

3.

Proposed System
3.1
3.2
3.3
3.4

4.

Objective
Project scope
Features
Impact analysis

System development Methodologies

4.1 SDLC phases
4.2 SDLC objectives

5.

Requirement analysis
5.1 Identification of need
5.2 Preliminary investigation

6.

Feasibility study
6.1
6.2
6.3
6.4
6.5

7.

Economic feasibility
Technical feasibility
Time feasibility
Operational feasibility
Behavioral feasibility

Platform used
7.1 Hardware requirements
7.2 Software requirements
7.3 Technologies used
5

8.

System design

8.1
8.2
8.3
8.4
8.5
9.

Output design
Input design
Database design
Code design
Process design

Diagrams

10.

9.1 DFD
Testing and security

11.

Implementation

12.

Maintenance

13.

Conclusion

14.

Bibliography

INTRODUCTION TO EXISTING SYSTEM

Many organizations wants to store its employees records in security manner, but
proper management of per employee is a complex task. The software design provides
a user friendly system that facilitates quick and efficient operation to cover larger
section of Employee in Organization.
It also manages the Time-Track, Employee progress report and Attendance of
Employees whose are access the Organization.
The main problem of existing system without Employee Management Software is to
record and manage the employees in proper way.

COMPANY PROFILE
h3 Technologies is a female and minority owned comprehensive staffing and
software development firm. We can provide consultants for contract, contract to
hire, direct placements and custom software development. We have been
recognized as one of the top Fast 55 in the greater Cincinnati area and are among
the top 30 emerging companies designated by Northern Kentucky Chamber of
Commerce.
We bring over 36 years of technical expertise in Oracle and Java Technologies.
Although our core competencies are Oracle and Java, we also support any other
major technologies including Microsoft based products, Business Intelligence or
Data Warehouse across multiple platforms. Our consultants leverage leading edge
technologies and business experience to identify opportunities and drive business
process improvements.
We spend a significant amount of time with our clients to truly understand their
business. Once we have identified the organization's information technology
needs our goal is to come back with a solution that exceeds their expectations.
We are really considered a total solution provider. Our core values of honesty,
integrity and quality, determine how we interact with our clients and consultants
in adapting to their corporate and individual needs.

PROPOSED SYSTEM
1: Objective
Many organizations wants to provide the additional subsidized facility to
their employees as a welfare measure. The usage of this software by the employees
and the administrator depends on many factors like centralized records distribution
center with swift and simplicity in operations.

2: Project Scope

Online Management System design

provides

user

friendly

system

that

facilitates quick and efficient operations to cover larger section of employees time.
EMS is paperless. This system is also compatible in an environment where multiple
employee Records can manage in organization environment.

3: Features
EMS can be integrated with multiple records depending on the
Organization needs.
Exact information of daily total nos of employee working in organization.
Exact information about the each Employee.
Distribution becomes easier of exact calculation of total no of hours of particular
employee in each day.
Advance information on the usage of online employee management system is too
save the details of employee regarding of performance which are helpful for the
salary confirmation.

4: Impact analysis

EMS is independent of the technology used for identification of

Employees.
Provides paperless work.
Provides facility to the employee to check the personal details attendance and
salary details.
Provides Add/Edit salary details for Administrator.
Provide to track the total no. s of working hours.
Provides a fast and efficient service.
Reduces wastage time.
10

SDLC PHASES

Phases in SDLC are Planning, Analysis, Design, Implementation, and Maintenance

11

1: Project planning
The main goal of software design provides a user friendly system that
facilitates quick and efficient management to cover larger section of organizations
records.
2:

Project analysis

Login Admin Employee

Add Department
Add Employee Details.
Provides the credential for Every Employee.
Attendance records
Add/Edit Salary records.
Time-Track while Employee login and logout.
Employee report.
Employee Progress report.
Employee Login
Check personal details, attendance and salary details .
Send work status and leave request for administrator.
3: Project design
It generally includes various processes of the project such as .
Employee Details
Attendance details
Employee work status.
Time -track
12

 Credential

4: Project Implementation (Development):

Integration and testing
Acceptance, installation on the System, deployment.

5: Maintenance
It is easy to changes, correction, additions, moves to a different computing platform
and more.

13

REQUIREMENT ANALYSIS

1: Identification of need
Easy to integrate with companys existing ID Card System (Barcode, Proximity,
Smart card)
Photograph verification system avoids proxy punching
Maintain and Generate Employee report of individual employee on daily basis.

2: Preliminary investigation

Daily /weekly/monthly/yearly report of Login and Logout.

Total nos of working hours in particular day.
Daily/weekly/monthly/yearly report of work status by employee .
Report of Monthly salary.
Attendance details daily /weekly /monthly/yearly.
Account details on daily/ weekly/ monthly basis.

14

FEASIBILITY STUDY
Depending on the results of the initial investigation the survey is now expanded to a
more detailed feasibility study. FEASIBILITY STUDY is a test of system proposal
according to its workability, impact of the organization, ability to meet needs and
effective use of the resources. It focuses on these major questions:
1. What are the users demonstrable needs and how does a candidate system
meet them?
2. What resources are available for given candidate system?
3. What are the likely impacts of the candidate system on the organization?
4. Whether it is worth to solve the problem?
During feasibility analysis for this project, following primary areas of interest are to be
considered. Investigation and generating ideas about a new system does this.
Steps in feasibility analysis
Eight steps involved in the feasibility analysis are:

Form a project team and appoint a project leader.

Prepare system flowcharts.
Enumerate potential proposed system.
Define and identify characteristics of proposed system.
Determine and evaluate performance and cost effective of each proposed
system.
Weight system performance and cost data.
Select the best-proposed system.
Prepare and report final project directive to management.
1: Technical feasibility
A study of resource availability that may affect the ability to achieve an acceptable
System. This evaluation determines whether the technology needed for the proposed
15

System is available or not.

Can the work for the project be done with current equipment existing software
technology & available personal?
Can the system be upgraded if developed?
If new technology is needed then what can be developed?
This is concerned with specifying equipment and software that will successfully
satisfy the user requirement.
The technical needs of the system may include:

Front-end and back-end selection

An important issue for the development of a project is the selection of suitable front-end
and back-end. When we decided to develop the project we went through an extensive
study to determine the most suitable platform that suits the needs of the organization as
well as helps in development of the project.
The aspects of our study included the following factors.
Front-end selection:
1. It must have a graphical user interface that assists employees that are not from IT
background.
2. Scalability and extensibility.
3. Flexibility.
4. Robustness.
5. According to the organization requirement and the culture.
6. Must provide excellent reporting features with good printing support.
7. Platform independent.
8. Easy to debug and maintain.
9. Event driven programming facility.
10. Front end must support some popular back end like Ms Access.
According to the above stated features we selected VB6.0 as the front-end for
developing our project.
Back-end Selection:
1. Multiple user support.
2. Efficient data handling.
3. Provide inherent features for security.
4. Efficient data retrieval and maintenance.
16

5. Stored procedures.
6. Popularity.
7. Operating System compatible.
8. Easy to install.
9. Various drivers must be available.
10. Easy to implant with the Front-end.
According to above stated features we selected Ms-Access as the backend.
The technical feasibility is frequently the most difficult area encountered at this stage. It
is essential that the process of analysis and definition be conducted in parallel with an
assessment to technical feasibility. It centers on the existing computer system
(Hardware, software etc.) and to what extent it can support the proposed system.

2: Economical feasibility
Economic justification is generally the Bottom Line consideration for most systems.
Economic justification includes a broad range of concerns that includes cost benefit
analysis. In this we weight the cost and the benefits associated with the candidate
system and if it suits the basic purpose of the organization i.e. profit making, the project
is making to the analysis and design phase.
The financial and the economic questions during the preliminary investigation are
verified to estimate the following:
The cost to conduct a full system investigation.
The cost of hardware and software for the class of application being
considered.
The benefits in the form of reduced cost.
The proposed system will give the minute information, as a result the
performance is improved which in turn may be expected to provide
increased profits.
This feasibility checks whether the system can be developed with the
available funds.
The Canteen Management System does not require enormous amount of money to
be developed. This can be done economically if planned judicially, so it is economically
feasible. The cost of project depends upon the number of man hours required.
3: Operational Feasibility
17

It is mainly related to human organizations and political aspects. The points to be

considered are:
What changes will be brought with the system?
What organization structures are disturbed?
What new skills will be required? Do the existing staff members have these
skills? If not, can they be trained in due course of time?
The system is operationally feasible as it very easy for the End users to operate it. It
only needs basic information about Windows platform.
4: Schedule feasibility
Time evaluation is the most important consideration in the development of project. The
time schedule required for the developed of this project is very important since more
development time effect machine time, cost and cause delay in the development of
other systems.

18

PLATFORM USED

1: Hardware requirements
512 MB Space in RAM
Dual core Processor
10 GB Space in Hard Disk
2: Software requirements
Operating System

Window XP SP2,3,(Vista & Window 7)

Language

C#

Data Base

SQL Server 2008

3: Technologies used
ASP.Net and Telerik

19

SYSTEM DESIGN

1: OUTPUT DESIGN

LOGIN FORM

20

Forgot Password Form

21

Home Page

22

Add Department Form

23

Add Employee Form

24

Add Credential Form

25

Time Track

26

Add/Edit Salary

27

Attendance Form

28

Add Progress Form

29

Employee Report

30

Employee Portal

Home Page

31

Employee Detail

Personal Detail

32

Attendance

33

2:DataBase Design

MAST_DEPARTMENT

34

MAST_EMPLOYEE

35

MAST_CREDENTIAL

36

MAST_ATTENDANCE

37

MAST_TIME_TRACK

38

MAST_SALARY

39

MAST_PROGRESS

40

FLOW DIAGRAM

ADMINISTRATOR PORTAL

CHECK
EMPLOYEE

EXCEPTION

ACCESS
METHO
D?

ADMINSTRATOR

SORRY

UNAUTHORIZED
AGAIN

41

YOU
AND

ARE
TRY

ADMINSTRATOR PORTAL

ADD DEPARTMENT

ADD EMPLOYEE

CREATE CREDENTIAL

ADD / EDIT SALARY

ATTENDANCE

TIME-TRACK

EMPLOYEE REPORT

EMPLOYEE PROGRESS
REPORT

42

EMPLOYEE PORTAL

EMPLOYEE DETAIL
PERSONAL DETAIL
ATTENDANCE
SALARY INFO
SEND WORK STATUS

REQUEST
LEAVE REQUEST
SALARY
REQUEST
EMPLOYEE REPORT

43

INCREMENT

ADD DEPARTMENT

ADD

UPDATE

SEARCH

CANCEL

DELETE

DEPARTMENT
MASTER

44

ADD EMPLOYEE

ADD

UPDATE

SEARCH

CANCEL

DELETE

EMPLOYEE MASTER

45

CREDENTIAL

ADD

CANCE

SEARCH

UPDATE & SEND

CREDENTIAL

E-MAIL & SMS

MASTER

SEND
E-MAIL & SMS
PC

MOBILE DEVICE

46

ATTENDANCE

TRACH ATTENDANCE
(BY PARTICULAR DATE & MONTH)

ATTENDANCE
MASTER

47

TIME TRACK

TRACK

DELETE

(BY PARTICULAR DATE & OTHER

DATES)

MASTER
TIME TRACK

48

ADD / EDIT SALARY

ADD SALARY DETIL

ADD BANK DETAILS

UPDATE

SEARCH
CANCEL

DELETE

SALARY MASTER
& BANK MASTER

49

ATTENDANCE

EVERY EMPLOYEE

SEARCH
DAY/DATE/MONTH
WISE

ATTENDANCE
MASTER
50

EMPLOYEE REPORT

PERSONAL DETAILS

BANK DETAILS
SHOW
ATTENDENCE
DETAIL
TOTAL NO,S HOURS
PROGRESS REPORT

MASTER DATABASE

51

ADD PROGRESS

ADD PROGRES FOR

ACHIEVMENT

WORKSATUS
SAVE
PREFORMANCE
EXPEREINCE

PROGRESS
MASTER

52

CONCLUSION

The project Online Employee management System (EMS) is for computerizing the
working in Organization where multiple nos of employee are working. The software
takes care of all the records of an average employee and is capable to provide easy and
effective storage of information related to employee and provides the sufficient way of
work profile.
It generates reports; provide prescription details including progress of employee, daily
Attendance. It also provides total nos of working and Salary facility on the basis of
employee status whether it is a weekly or monthly employee.
The system also provides the facility of backup as per the requirement.

53

BIBLIOGRAPHY

BOOKS
The Wrox 3.5
APress
Ebalaguruswamy

WBSITES
www.google.com
www.w3schools.com
www.dotnetspider.com
www.msdn.microsoft.com
www.sql-server-helper.com

54