INTRODUCTION

This project is all about software for Employee

management system. It helps to have a full-fledged
control over his/her employees. The project is divided
into 2 sections to make the programme easy to
understand.
It receives user name and password to log in and
register .It keeps the record of user salary ,his
department of working, his performance in the office.
It adds a new employee, his salary, department,
updates an existing salary ,list of employee, age and
his performance.

1
 OBJECTIVE

The objective of this project is to let the students

apply the programming knowledge into a real- world
situation/problem and exposed the students how
programming skills helps in developing a good
software.

1.Write programs utilizing modern software tools.

2.Apply object oriented programming principles

effectively when developing small to medium sized
projects.

3.Write effective procedural code to solve small to

medium sized problems.

4.Students will demonstrate a breadth of knowledge in

computer science, as exemplified in the areas of
systems, theory and software development.
5.Students will demonstrate ability to conduct a
research or applied Computer Science project,
requiring writing and presentation skills which
exemplify scholarly style in computer science.

2
 PROPOSED SYSTEM

Today one cannot afford to rely on the fallible human

beings of be really wants to stand against today’s
merciless competition where not to wise saying “to err
is human” no longer valid, it’s outdated to rationalize
your mistake. So, to keep pace with time, to bring
about the best result without malfunctioning and
greater efficiency so to replace the unending heaps of
flies with a much sophisticated hard disk of the
computer.

One has to use the data management software.

Software has been an ascent in atomization various
organisations. Many software products working are
now in markets, which have helped in making the
organizations work easier and efficiently. Data
management initially had to maintain a lot of ledgers
and a lot of paper work has to be done but now
software product on this organization has made their
work faster and easier. Now only this software has to
be loaded on the computer and work can be done.

3
 SYSTEM DEVELOPMENT LIFE
CYCLE

The systems development life cycle is a project

management technique that divides complex projects
into smaller, more easily managed segments or
phases. Segmenting projects allows managers to
verify the successful completion of project phases
before allocating resources to subsequent phases.

Software development projects typically include

initiation, planning, design, development, testing,
implementation, and maintenance phases. However,
the phases may be divided differently depending on
the organization involved.
For example, initial project activities might be
designated as request, requirements-definition, and
planning phases, or initiation, concept-development,
and planning phases. End users of the system under
development should be involved in reviewing the
output of each phase to ensure the system is being
built to deliver the needed functionality.

4
PHASES OF SYSTEM DEVELOPMENT LIFE
CYCLE

INITIATION PHASE :

The Initiation Phase begins when a business sponsor

identifies a need or an opportunity.

The purpose of the Initiation Phase is to:

 Identify and validate an opportunity to improve

business accomplishments of the organization or
a deficiency related to a business need.

 Identify significant assumptions and constraints

on solutions to that need.

 Recommend the exploration of alternative

concepts and methods to satisfy the need
including questioning the need for technology,
i.e., will a change in the business process offer a
solution?

 Assure executive business and executive

technical sponsorship. The Sponsor designates a
Project Manager and the business need is
documented in a Concept Proposal. The Concept
Proposal includes information about the business
5
 process andthe relationship to the
Agency/Organization.

 Infrastructure and the Strategic Plan. A successful

Concept Proposal results in a Project
Management Charter which outlines the authority
of the project manager to begin

 the project.
Careful oversight is required to ensure projects
support strategic business objectives and resources are
effectively implemented into an organization's
enterprise architecture. The initiation phase begins
when an opportunity to add, improve, or correct a
system is identified and formally requested through
the presentation of a business case. The business case
should, at a minimum, describe a proposal’s purpose,
identify expected benefits, and explain how the
proposed system supports one of the organization’s
business strategies. The business case should also
identify alternative solutions and detail as many
informational, functional, and network requirements
as possible.

6
SYSTEM CONCEPT DEVELOPMENT PHASE

The System Concept Development Phase begins after

a business need or opportunity is validated by the
Agency/Organization Program Leadership and the
Agency/Organization CIO.

The purpose of the System Concept Development

Phase is to:

 Determine the feasibility and appropriateness of

the alternatives. Identify system interfaces.

 Identify basic functional and data requirements to

satisfy the business need. Establish system
boundaries; identify goals, objectives, critical
success factors,

 and performance measures.

 Evaluate costs and benefits of alternative

approaches to satisfy the basic functional
requirements

7
 Assess project risks

 Identify and initiate risk mitigation actions,

andDevelop high-level technical architecture,
process models, data models, and a concept of
operations. This phase explores potential
technical solutions within the context of the
business need.

 It may include several trade-off decisions such as

the decision to use COTS software products as
opposed to developing custom software or
reusing software components, or the decision to
use an incremental delivery versus a complete,
onetime deployment.

 Construction of executable prototypes is

encouraged to evaluate technology to support the
business process. The System Boundary
Document serves as an important reference
document to support the Information Technology
Project Request (ITPR) process.
 The ITPR must be approved by the State CIO
before the project can move forward.

8
 PICTORIAL REPRESENTATION OF
SDLC

PLANNING PHASE

9
The planning phase is the most critical step in
completing development, acquisition, and
maintenance projects. Careful planning, particularly in
the early stages of a project, is necessary to coordinate
activities and manage project risks effectively. The
depth and formality of project plans should be
commensurate with the characteristics and risks of a
given project. Project plans refine the information
gathered during the initiation phase by further
identifying the specific activities and resources
required to complete a project.

A critical part of a project manager’ sjob is to

coordinate discussions between user, audit, security,
design, development, and network personnel to
identify and document as many functional, security,
and network requirements as possible. During this
phase, a plan is developed that documents the
approach to be used and includes a discussion of
methods, tools, tasks, resources, project schedules,
and user input. Personnel assignments, costs, project
schedule, and target dates are established.

A Project Management Plan is created with

components related to acquisition planning,
configuration management planning, quality assurance
planning, concept of operations, system security,
10
verification and validation, and systems engineering
management planning.

This phase formally defines the detailed functional

user requirements using high-level requirements
identified in the Initiation, System Concept, and
Planning phases. It also delineates the requirements in
terms of data, system performance, security, and
maintainability requirements for the system. The
requirements are defined in this phase to alevel of
detail sufficient for systems design to proceed. They
need to be measurable, testable, and relate to the
business need or opportunity identified in the
Initiation Phase. The requirements that will be used to
determine acceptance of the system are captured in the
Test and Evaluation MasterPlan.

THE PURPOSES OF THIS PHASE ARE TO:

 Further define and refine the functional and data

requirements and document them in the
Requirements Document,

 Complete business process reengineering of the

functions to be supported (i.e., verify what
information drives the business process, what
information is generated, who generates it, where
does the information go, and who processes it),
11
  Develop detailed data and process models
(system inputs, outputs, and the process.

 Develop the test and evaluation requirements that

will be used to determine acceptable system
performance.

DESIGN PHASE

The design phase involves converting the

informational, functional, and network requirements
identified during the initiation and planning phases
into unified design specifications that developers use
to script programs during the development phase.
Program designs are constructed in various ways.
Using a top-down approach, designers first identify
and link major program components and interfaces,
then expand design layouts as they identify and link
smaller subsystems and connections. Using a bottom-
up approach, designers first identify and link minor

12
program components and interfaces, then expand
design layouts as they identify and link larger.

Systems and connections. Contemporary design

techniques often use prototyping tools that build
mock-up designs of items such as application screens,
database layouts, and system architectures. End users,
designers, developers, database managers, and
network administrators should review and refine the
prototyped designs in an iterative process until they
agree on an acceptable design. Audit, security, and
quality assurance personnel should be involved in the
review and approval process. During this phase, the
system is designed to satisfy the functional
requirements identified in the previous phase. Since
problems in the design phase could be very expensive
to solve in the later stage of the software development,
a variety of elements are considered in the design to
mitigate risk. These include:

 Identifying potential risks and defining mitigating

design features. Performing a security risk
assessment.

 Developing a conversion plan to migrate current

data to the new system. Determining the
operating environment.

13
  Defining major subsystems and their inputs and
outputs. Allocating processes to resources.

 Preparing detailed logic specifications for each

software module. The result is a draft System
Design Document which captures the preliminary
design for the system.

 Everything requiring user input or approval is

documented and reviewed by the user. Once these
documents have been approved by the Agency
CIO and Business Sponsor, the final System
Design Document is created to serve as the
Critical/Detailed Design for the system.

 This document receives a rigorous review

byAgency technical and functional
representatives to ensure that it satisfies the
business requirements. Concurrent with the
development of the system design, the Agency
Project Manager begins development of the
Implementation Plan, Operations and
Maintenance Manual, and the Training Plan.

DEVELOPMENT PHASE

14
The development phase involves converting design
specifications into executable programs. Effective
development standards include requirements that
programmers and other project participants discuss
design specifications before programming begins. The
procedures help ensure programmers clearly
understand program designs and functional
requirements. Programmers use various techniques to
develop computer programs. The large transaction
oriented programs associated with financial
institutions have traditionally been developed using
procedural programming techniques. Procedural
programming involves the line-by-line scripting of
logical instructions that are combined to form a
program. Effective completion of the previous stages
is a key factor in the success of the Development
phase. The Development phase consists of:

 Translating the detailed requirements and design

into system components. Testing individual
elements (units) for usability.

 Preparing for integration and testing of the IT

system.

INTEGRATION AND TEST PHASE

15
Subsystem integration, system, security, and user
acceptance testing is conducted during the integration
and test phase. The user, with those responsible for
quality assurance, validates that the functional
requirements, as defined in the functional
requirements document, are satisfied by the developed
or modified system. OIT Security staff assess the
system security and issue a security certification and
accreditation prior to installation/implementation.

Multiple levels of testing are performed, including:

 Testing at the development facility by the

contractor and possibly supported by end users

 Testing as a deployed system with end users

working together with contract personel

 Operational testing by the end user alone

performing all functions.

 Requirements are traced throughout testing,a final

Independent Verification & Validation evaluation
is performed and all documentation is
reviewedand accepted prior to acceptance of the
system.

16
IMPLEMENTATION PHASE

This phase is initiated after the system has been tested

and accepted by the user. In this phase, the system is
installed to support the intended business functions.
System performance is compared to performance
objectives established during the planning phase.
Implementation includes user notification, user
training, installation of hardware, installation of
software onto production computers, and integration
of the system into daily work processes. This phase
continues until the system is operating in production
in accordance with the defined user requirements.

OPERATIONS AND MAINTENANCE PHASE

The system operation is ongoing. The system is

monitored for continued performance in accordance
with user requirements and needed system
modifications are incorporated. Operations continue
as long as the system can be effectively adapted to
respond to the organization’s needs. When
modifications or changes are identified, the system
may reenter the planning phase.

17
The purpose of this phase is to:

 Operate, maintain, and enhance the system.

 Certify that the system can process sensitive

information.

 Conduct periodic assessments of the system to

ensure the functional requirements continue to be
satisfied.

 Determine when the system needs to be

modernized, replaced, or retired.

SYSTEM REQUIREMENTS

 Operating system : Windows 7 and above

 Processor : Pentium(any) or Amd

athalon(3800+- 4200+ dual core)

18
 Motherboard : 1.845 or 915,995 for
pentium or msi k9mm-v via k8m800+8237r
plus chipset for amd athalon

 Ram : 512 mb+

 Hard disk : sata 40 gb or above

 cd/dvd r/w multi drive combo: (if back up

required)

 Software:

i) Python

ii) Windows os

SOURCE CODE

19
================================================
================

#table creation

import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',passwd='manager',dat
ab ase='employees')

cur = conn.cursor()

#cur.execute('create table user_table(username varchar(25) primary

key,passwrd varchar(25) not null )')
print('=========================WELCOME TO START
EMPLOYEE MANAGEMENT
SYSTEM=========================================
===================')

import datetime as dt print(dt.datetime.now()) print('1.REGISTER')

print() print('2.LOGIN') print()

n=int(input('enter your choice=')) print()

if n== 1:

name=input('Enter a Username=') print()

passwd=int(input('Enter a 4 DIGIT Password=')) print()

V_SQLInsert="INSERT INTO log_id (user_id,password) values ("

+ str (passwd) + ",' " + name + " ') "

cur.execute(V_SQLInsert) conn.commit()

print()

20
print('USER created succesfully') import mainp

if n==2 :

name=input('Enter your Username=') print()

passwd=int(input('Enter your 4 DIGIT Password='))

V_Sql_Sel="select * from log_id where password='"+str (passwd)

+"' and user_id= ' " +name+ " ' "

cur.execute(V_Sql_Sel)

if cur.fetchall() is None: print()

print('Invalid username or password') else:

print() import mainp

++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++

# MAINP.PY FILE #

import time

print ("\t\t\t",time.ctime())

import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',password='manager',d
at abase='employees')

mycursor=conn.cursor()

def menu():

print(" EMPLOYEES MANAGEMENT SYSTEM ")

21
c='yes'

c=input("do you want to continue or not(yes or No):")

while(c=='yes'):

print("1.login") print("2.employee registeration") print("3.employee

details") print("4.update salary") print("5.employees list")

print("6.know the number of employees") print("7.work

experience") print("8.know your salary") print("exiting")

choice=int(input(" enter the choice: ")) if choice==1:

login() elif choice==2:

register() elif choice==3:

details() elif choice==4:

em_salary() elif choice==5:

em_list() elif choice==6:

em_count()

elif choice==7: em_perform()

elif choice==8: salary()

else:

print ("exit") break

else : print("Thank You")

def login():

import sys

22
user_id=input("enter USER ID :") pwd=int(input("enter the
password :")) if user_id == 'vishal'and pwd == 6054:

print("welcome to EMPLOYEE MANAGEMENT SYSTEM ")

else:

print("invalid user id and password") sys.exit()

def register():

import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',password='manager',d
at abase='employees')

mycursor=conn.cursor() v_em_no=int(input("enter your employee

ID")) v_em_name=input ("enter your name:")

v_em_dept=input( "enter department you want to join : ")

v_em_salary=input ("enter your salary:")
v_em_age=int(input("enter your age:"))

v_sql_insert="insert into office values("+int(v_em_no)+",'"

+v_em_name+"','"+v_em_dept+"',"+str(v_em_salary)
+","+str(v_em_age)+"

)"

mycursor.execute(v_sql_insert) conn.commit()

print("congrats you have joined suuceessfully") print(" registerd

suyccessfully ")

def details():

import mysql.connector as sql

23
conn=sql.connect(host='localhost',user='root',password='manager',d
at abase='employees')

mycursor=conn.cursor() mycursor.execute("select* from OFFICE")

results=mycursor.fetchall() conn.commit()

for x in results: print(x)

def em_salary():

import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',password='manager',d
at abase='employees')

mycursor=conn.cursor() nam=input("enter your name")

mycursor.execute("update office set

em_salary=em_salary+em_salary*10/100 where
em_name='{}'".format(nam))

conn.commit()

def em_list():

import mysql.connector as sql try:

conn=sql.connect(host='localhost',user='root',password='manager',d
at abase='employees')

mycursor=conn.cursor()

mycursor.execute("select em_name from office order by em_name

asc")

list_=mycursor.fetchall() for x in list_:

print (x) a=mycursor.rowcount() print("total employees are",a)

24
except:

print ("unable to show the list") def em_count():

import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',password='manager',d
at abase='employees')

mycursor=conn.cursor()

mycursor.execute("select count(distinct em_name) from office")

count=mycursor.fetchall()

for x in count:

print(" numbr of employees:",x) conn.commit()

def salary():

nam=input("enter your name :") a=mycursor.execute("select

em_salary from office where

em_name='{}'".format(nam)) mycursor.execute(a)
salary=mycursor.fetchall() for x in salary:

print(x,"is your current salary",nam ) conn.commit()

def em_perform():

v_em_no=int(input("enter your employee ID")) v_em_name=input

("enter your name:")

v_em_dept=input( "enter department you want to join : ")

v_em_performance=input("enter your performance:")

v_em_work=input ("enter your experience(YEARS):")
v_sql_insert="insert into em_performance
25
values("+str(v_em_no)+",'"

+v_em_name+"','"+v_em_dept+"','"+v_em_performance+"',"+str(v
_em_work

)+")"

print(v_sql_insert) mycursor.execute(v_sql_insert) conn.commit()

print("performance added")

menu() # PYTHON MODULE :Tables_in_mysql

================================================
====================

OUTPUT

26
27
28
CONCLUSION

29
Employee management is all about people – but that
implies managing the data about these people too.
New technologies emerge on a regular basis and this
leads to employee management systems becoming
more advanced. Thus, there is a big chance for
modern development companies to come up with an
innovative approach and offer an efficient and
scalable solution.

30
 BIBILIOGRAPHY

 Class 12 NCERT book

 www.coderspacket.com
 www.itsourcecode.com
 www.cbsepython.in

31