C V RAMAN GLOBAL UNIVERSITY,
BHUBANESHWAR
ODISHA
Department Of Computer Science
Engineering
Course Name: - Database Management
System
Topic: Employee Management System
Name: Saswat Seth
Regn. No.: 20010352
Roll No.: CAM20023
Group: 3(A)
1|P a g e
Branch: CSE (AI & ML)
Contents
Abstract 3
Introduction 4
System study 5
Study of existing system 5
Benefits of the system 6
System requirements 6
List of Entities & Attributes 7
ER Diagram (Conceptual Model) 8
Schema Diagram 9
Normalization & Final List of Relations 9
Employee table 10
2NF: Functional Dependency 11
Create & Insert SQL Queries 10
SQL Queries related to Report Generation 12
Conclusion 13
Reference 14
2|P a g e
Abstract
Employee Management System is an application-based framework, having
two applications created, one for bosses to oversee representative
subtleties and one more for workers to check their participation. Each
association whether government or private purposes a data system to store
information of their staff. In any case, in India it is found that many limited
scope businesses use pen and paper to keep a record. Nonetheless,
there are many trend setting innovation frameworks accessible that can
accomplish this work however they all are exorbitant for these low-level
ventures. This paper talks about making a framework for tackling issues for
them at a less expensive expense.
This framework will stamp participation of every worker and ascertain the
compensation of them toward the finish of month. It likewise ascertains
additional time and complete working hours of every worker. As in limited
scope each organization has their own days off inclination and variable
week off for workers, so everything this power is given to the business to
oversee occasions and weekdays of every worker independently.
It saves loads of time and has no blunder in pay estimation thus forestalling
conflicts between HR Team and workers. So, both business and
representative can zero in on their work to foster their organization.
3|P a g e
Introduction
Each association tracks their staff. Staff records assume a pivotal part in
staff the board. Each association requires these records to ascertain pay,
oversee labour force, and see execution of workers. The board of all
these records is a difficult assignment and time consuming cycle for the HR
group, which can be decreased by utilizing EMS that is the Employee
management system. HR are a significant piece of any association and
mindful for the progress of an association. Associations contribute
profoundly on the administration of workers. HRIS is a human asset data
framework that oversees stock control and bookkeeping. EMS is
additionally an informatics framework that is valuable in saving time,
influence and cash of proprietor, HR’s, and chief. All associations both
private and public, have necessities of worker the executives frameworks.
However, from years they have been utilizing an old traditional technique
that is pen and paper to keep up with record, but in the beyond couple of
years there has been a huge increment toward utilizing programmed
frameworks that can oversee compensation estimation by their own. In
numerous region it's a troublesome assignment to execute these
frameworks as they are exorbitant and require legitimate upkeep. In this
way, to tackle this issue I have this EMS, which is versatile application
based. It will work out the compensation of every representative and day to
day participation. This framework was grown with the end goal that it very
well may be utilized by little associations moreover. It's less expensive than
different frameworks what's more, assists limited scope ventures with
dealing with their representatives. As in little areas there are heaps of
work as a specialist, there are bunches of questions too seen, because of
inappropriate computation of pay additional time, this framework intends
to address this issue, so that the HR group can zero in on different cycles
instead of settling questions. It assists an association with working on the
course of record maintenance. To make their work more viable,
associations should execute this representative the executives framework .
This contextual analysis examines the improvement strategy, issues
confronted and advantages of utilizing the framework.
4|P a g e
System Study
Framework concentrates on targets laying out demands for the framework
to be obtained, improvement and introduced. It includes examining and
dissecting the methods of an association as of now handling the
information to create data. Breaking down the issue completely shapes the
imperative piece of the framework study. In framework examination,
winning circumstance of issue is painstakingly inspected by breaking them
into sub issues. Hazardous regions are distinguished, and data is gathered.
Information gathering is fundamental for any examination of solicitations. It
is vital that this investigation acclimates the originator with goals, exercises,
and the capacity of the association where the framework is to be carried
out.
Study Of Existing System
The issue definition for planning the framework is to keep up with
information of worker, to make simple controlling representatives, to
isolate occupations and access control of workers, to utilize innovation for
exact and opportune handling by completely security and full power
access. The objective of the task is to set up representative data
framework about status of worker and participation of worker and month
to month compensation cycle and conveyance. To dispose of or diminish
however much as could be expected the difficulties of existing framework
and stay away from mistakes while entering information. In existing
technique representative administration are worker record are keeping up
with in records. It's a manual cycle. Muddled to look through the
representative compensation.
Disadvantages:
• Needs for additional manual exertion.
• In existing framework is independent interaction ordinary
representative can't follow their worker status.
• Less Accuracy Danger of losing a few documents.
• Certain necessary report isn't accessible Time consuming interaction.
5|P a g e
Benefits Of This System
An EMS enjoys bunches of benefits. The framework is exceptionally basic
in plan and to carry out. The framework requires exceptionally low
framework assets, and the framework will work in practically all setups. It
has got following elements:
• Portability
• Compatibility
• Secure
• User Friendly
• Generosity
• Runtime Compactness and Speed
• Straightforwardness to all the client of framework.
• Less paper use and evacuation of overt repetitiveness.
• Less inclined to mistakes.
• The entire framework is intuitive.
System Requirements
• WINDOWS XP/7/8.1/10/11
• RAM-1GB
• PROCESSOR-INTEL DUAL CORE OR LATER
• MYSQL/ORACLE DB/MS ACCESS/SQL
Software Requirements
The EMS software personal database model will support the MySQL
environment as DBMS
6|P a g e
List Of Entities And Attributes
Entities Attributes
Employee ● em_id(PK)
● emp_name
● em_dep_id(FK)
● em_mail
● em_age
● em_mobile
Department ● salary_range
● dep_title
● dep_desc
● emp_dep_id(PK)
Leave ● leave_id(PK)
● em_id(FK)
● from_date
● to_date
● reason
Salary ● amount
● em_id(FK)
● em_dep_id(FK)
● Bonus
● slalry_id(PK)
Qualification ● qual_id(PK)
● em_id(FK)
● position
● date_in
7|P a g e
ER Diagram (Conceptual Model)
8|P a g e
Schema Diagram
Normalization :
em_id em_age emp_name em_mobile em_mail
512365875
946544651
9|P a g e
Employee table:-
Here we only took attributes of the Employee Table.
Here, em_mobile is a multivalued attribute.
=>The entity is not in 1NF.
For converting in 1NF , we can decompose the employee entity in :-
employee_BasicInfo :-
em_id em_age emp_name em_mail
1 20 Saswat [email protected]
2 21 Hoba [email protected]
3 21 Jooning [email protected]
4 22 Tete [email protected]
employee_PhoneNo.:-
em_id em_mobile
1 9090956356
1 9512365875
2 9455961351
3 9090909090
10 | P a g e
3 8946544651
4 9849815113
2NF: Functional Dependency
For employee_BasicInfo -
em_id -> em_age , em_name
em_mail -> em_age , em_name
For employee_PhoneNo.-
em_id -> em_mobile
From the above Functional Dependencies, we can find that the entities are
in Full Dependency i.e. no partial dependency is present.
So, the above 2 entities are in 2NF.
All other attributes present in the table of the schema diagram are not
multivalued so they need not to be decomposed.
Final List Of Relationships
• works_in- Relationship between Employee and Job_Department
• Has- Ternary relation Between Employee,Job_Department,Salary
and Qualification
• takes- Between Employee and leave
11 | P a g e
Create & Insert SQL Queries
CREATE COMMANDS:
CREATE TABLE Employee( em_id int primary key,constraint foreign
key(em_dep_id) references Department(em_dep_id), em_name
varchar(50), em_age int,em_mail varchar(20), em_mobile bi(50));
CREATE TABLE leave(leave_id int primary key,constraint foreign
key(em_id) references Employee(em_id),reason varchar(50),from_date
date,to_date date);
CREATE TABLE Department(em_dep_id int primary key, dep_title
varchar(50),dep_desc varchar(50),salary_range int);
CREATE TABLE Salary(salary_id int primary key,amount int,bonus
int,constraint foreign key(em_id) references Employee(em_id).constraint
foreign key(em_dep_id) references Department(em_dep_id));
CREATE TABLE Qualification(Qual_id int primary key,constraint foreign
key(em_id) references Employee(em_id),position varchar[20],date_in date);
12 | P a g e
Conclusion
This system will help the organisations develop their system and will help
in managing employees. The representative administration framework is
intended to set aside cash, time, and power. In an association to improve
on the course of record support it is exceptionally useful. As employees are
the foundation of any association so it is fundamental to keep them blissful.
This idea will bring straightforwardness in their wage’s estimation. It will
likewise make the HR work simple so they can zero in on some other work.
This representative administration framework deals with the general
exhibition and unique parts of a representative in an association.
In general, the framework is valuable for every one of the clients to keep up
with data at various levels. It associates administrator and worker and
consequently it’s not difficult to keep up with. Presently administrator can
effortlessly set the errand or any warnings to the workers without having an
individual to ship off representatives and workers can apply for leave or
answer with task designated to them. It has been an incredible joy for me
to deal with this astonishing and testing project. This project demonstrated
great for us as it gave viable information on not just programming in Oracle
MySQL Server Developer working of electronic application, yet
additionally pretty much all taking care of methodology related with
Advance and new innovation. It likewise gives information about the most
recent innovation utilized in creating web empowered application and
client server innovation that will be overwhelming interest in future. This
will give better open doors and direction in future in creating projects
freely.
13 | P a g e
Reference
• https://www.researchgate.net/publication/347615091_Employee_M
anagement_System
• https://www.academia.edu/Documents/in/Employee_management
_system
• https://portal.bazeuniversity.edu.ng/student/assets/thesis/2020100
1233150617474894.pdf
• https://www.ijser.org/researchpaper/Employee-Management-
System.pdf
• http://www.ijmtst.com/volume6/issue12/42.IJMTST0612105.pdf
• https://www.irjet.net/archives/V6/i5/IRJET-V6I538.pdf
14 | P a g e
