jsh aditya kiran_employee information system
TRANSCRIPT
-
8/17/2019 JSH Aditya Kiran_Employee Information System
1/35
1
PROJECT :
EMPLOYEE
INFORMATION SYSTEM
NAME : J.S.H.Aditya Kiran
PROJECT GUIDE : P.Pramod Kumar
-
8/17/2019 JSH Aditya Kiran_Employee Information System
2/35
2
CERTIFICATE
This is to certify that the project report titled “Employee information
system” submitted by J.S.H Aditya Kiran of IMD 2nd
year, Dept of Applied
Physics, IT-BHU is record of a bonafide work carried out by him under my
guidance during the period May 15th
,2012 to July 5th
,2012 at Institute of
Development and Research in Banking Technology, Hyderabad.
The project work has been completed as per the set objectives.
P.Pramod kumar
IDRBT, Hyderabad
-
8/17/2019 JSH Aditya Kiran_Employee Information System
3/35
3
TABLE OF CONTENTS
1.Introduction
1.1 Introduction and Objective
1.2 Project Scope
1.3 Deliverables
1.4 Project Overiew
2. SYSTEM ANALYSIS
3. MODULE DESCRIPTION
4. SYSTEM DEVELOPMENT ENVIRONMENT
4.1. Java Script
4.2 Database system
5. SYSTEM DESIGN
5.1 Input and output screens
6.SYSTEM TESTING
7.CONCLUSION
-
8/17/2019 JSH Aditya Kiran_Employee Information System
4/35
4
INTRODUCTION
1.1 INTRODUCTION & OBJECTIVE
Employee information system is a database which keeps the record of all the
details pertaining to employees in an organization.
Organizations have always had to collect and use personal information from and
about employees to comply with tax and other laws, to administer benefits, to
operate their businesses.
The objective of the project is to improve and enhance the “Employee information
system” module available in IDRBT’s intranet for deployment on virtualized
server.
The same could not be migrated to the virtualized environment owing to
incompatibility of the existing code with the virtualized environment.
CHANGES MADE TO THE EXISTING PROJECT
The intranet which existed earlier was originally written in vb.net about ten years
ago. As the time progressed, the technology has developed and there was a need to
bring new servers for handling databases.
-
8/17/2019 JSH Aditya Kiran_Employee Information System
5/35
5
New servers were procured and the same code could not be migrated because ofitsincompatibility of the existing code with the virtualized environment
ADVANTAGES OF JSP
•
The dynamic part is written in Java, not VBScript or another ASP-specific
language, so it is more powerful and better suited to complex applications that
require reusable components.
•
Second, JSP is portable to other operating systems and Web servers; you aren’t
locked into Windows.
SOFTWARE AND HARDWARE SPECIFICATIONS
HARDWARE SPECIFICATION –MINIMUM REQUIREMENTS
Pentium III processor
128 MB Ram
Hard disk 40 GB
Microsoft Compatible 101 or more Key Board
SOFTWARE SPECIFICATION
JDK 1.5 Enterprise Edition (J2EE)
Apache Tomcat
NET Beans 7.1.2
JDBC/ODBC drivers installed.
-
8/17/2019 JSH Aditya Kiran_Employee Information System
6/35
6
Functional Java enabled browser.
Data Base (Oracle 10g ).
Operating System (Windows).
1.2. Project Scope:
The scope of the project is to store and access the database consisting of
employee’s personal details and the database can be shared with the concerned
department to complete joining formalities
We can also store and access the database consisting of program details.
1.3 Project Deliverables
We can store the employee’s personal details for internal accessibility.
We can post the program details on intranet and we can also prepare
the program timetable.
1.4 Project Overview
The intranet consist of many different modules like Management, Activities, formats,Employee module, etc.
All the above mentioned modules also have many sub-modules inside each of them.Thus, to store all the data, the database used is oracle.
Most of the data tables are interlinked with the employee module and hence the
employee module is developed first.
-
8/17/2019 JSH Aditya Kiran_Employee Information System
7/35
7
The employees will be having limited access to the website based on their
department, designation and role.
The program module keeps a record of all the upcoming programs and the program
timetablesThis module is also linked with employee module
The admin will have all the rights and full accessibility to intranet i.e he has the right
to add, modify ,or delete any data .
2.MODULE DESCRIPTION
The modules I have done are
Employee module
1)
Department module2)
Designation module3)
Role module
4) Employee details5) Termination module
Program module
1) Program details
2) Program management module
-
8/17/2019 JSH Aditya Kiran_Employee Information System
8/35
8
Employee module
As mentioned above, this module will be having links with almost every other
module .
It consists of 4 tables
1)Department
2)Designation
3)Role
4)Employee
DEPARTMENT
INPUT
Department id
Department
DESIGNATION
INPUTDesignation
ROLE
INPUTRole
-
8/17/2019 JSH Aditya Kiran_Employee Information System
9/35
9
EMPLOYEE
All the above added fields are stored in the database and are
retrieved in dropdown boxes in the employee table.
The employee table contains the following fieldsand after enteringthese details a unique employee id will be generated for every
employee .
INPUT
Department
Designation
Name
Gender
Date of birth
Address
Email
Contact number
Category
Joining date
Valid date
Deputation from
Deputation to
Work area
Reporting to
TERMINATION
.When any employee resigns his/her employee record will be terminated with the help ofTERMINATE table and this record will be sent via email to the technical staff
The employee id will be taken as input and all corresponding employee record will be
terminated.
INPUT
Empid.
-
8/17/2019 JSH Aditya Kiran_Employee Information System
10/35
10
PROGRAM MODULE
The program module consists of all the details about the upcoming programs.
These details include program name, coordinator, objective of the program, nature
of the program, starting and ending dates of the program, fee structure, etc
INPUT
Program nameCoordinator
Objective of the programNature of the program
From dateTo date
TimetableFeedback
Fee structureAmount
There are options for modifying or deleting the program table. These options are
available only for admin.
PROGRAM MANAGEMENT MODULE
This module is used to prepare timetables for different programs.
The admin is required to enter the following details first
INPUT
Program name
Number of sessions
Depending on the number of sessions entered the page is accordingly redirected
For example if the number of sessions entered is 4,the page is redirected to a page which
has 4 textboxes for 4 sessions.
The input details are as follows
Duration (number of days )
-
8/17/2019 JSH Aditya Kiran_Employee Information System
11/35
11
Select program date
Session1
Faculty1
Session2
Faculty2
Session3
Faculty 3
Session 4
Faculty 4
Duration of the program is calculated by subtracting from date and to date which are
entered in the program module.
The program date is dropdown column with options as dates from ‘from date’ to ‘to
date’.
Faculty is also a dropdown column which has the employee names from the employee
table as options
ADD PARTICIPANT
The details of participants who are participating in the programs can be added.
The input details are as follows
Pass number
Date
Participant Name
Program name
Status
Program code
Organization
Start date
Designation
End date
Address
-
8/17/2019 JSH Aditya Kiran_Employee Information System
12/35
12
City
Vehicle number
Time
PUBLISH
Every program will have dates allotted for group photograph and special
lunch .
All the related details will be entered into publish table
The input details are as follows
Program name
According to the program name entered, the page will be redirected to
another page which checks the program name from the program table and
the values of from date ,to date and the program coordinator are returned
to the page.
After this the following details should be given as input
GROUP PHOTOGRAPH
Date
Time
Venue
SPECIAL LUNCH
Date
Time
Venue
-
8/17/2019 JSH Aditya Kiran_Employee Information System
13/35
13
SYSTEM DEVELOPMENT ENVIRONMENT
3. System Development Environment
3.1. JAVA SCRIPT
Java Script is Netscape’scross-platform, object-oriented scripting language. Core
Java Script contains a core set of objects, such as Array, Date and Math and a core set oflanguage elements such as operators, control structures, and statements. Core Java Script
can be extended for a variety of purposes by Supplementing it with additional objects; forexample:
Client-side Java Script extends the core language by supplying objects to control a
browser (Navigator or another web browser) and its Document Object Model (DOM).For example, client-side extensions allow an application to Place elements on an HTML
form and respond to user events such as mouse clicks, Form input, and page navigation.
Server-side Java Script extends the core language by supplying objects relevant torunning Java Script on a server. For example, server-side extensions allow an
Application to communicate with a relational database, provide continuity of Informationfrom one invocation to another of the application, or perform files Manipulations on a
server.
-
8/17/2019 JSH Aditya Kiran_Employee Information System
14/35
14
Java Script lets you create applications that run over the Internet. Client applicationsrun in a browser, such as Netscape Navigator, and Server applications run on a server,
such as Netscape Enterprise Server.Using Java Script, you can create dynamic HTML pages that process user input and
maintain persistent date using special objects files, and relational databases.
Through Java Script’s Life Connect functionality, you can let Java and Java Scriptcode communicate with each other. From Java Script, you can instantiate Java objects
and access their public methods and fields. From Java, you can access Java Scriptobjects, properties, and methods. Netscape invented Java Script, and Java Script was first
used in Netscape browsers.
.
4.2 DATA BASE SYSTEM
A Database System is essentially nothing more then a computerized record keeping
system. Its overall purpose is to maintain information and to make that informationavailable on demand.
The component of the database system is:
• DATA
• HARDWARE
• SOFTWARE
• USERS
The users of a database system will be given facilities to perform a variety ofoperations on files, which include:
Adding new files to the data base
Inserting new data into existing files Retrieving data from existing files
Updating data in existing files
Deleting data from existing files
-
8/17/2019 JSH Aditya Kiran_Employee Information System
15/35
15
Removing existing files empty or otherwise from the databaseA database consists of some collection of persistent data that is used by the application
system of given enterprise.
SYSTEM DESIGN
5.1INPUT AND OUTPUT SCREENS
SCREENS
-
8/17/2019 JSH Aditya Kiran_Employee Information System
16/35
16
LOGIN PAGE1)Login Table contains user name and password
Field Name Data Type/Size Description
UNAME Varchar(20) User name
PASSWORD Varchar(20) Password
-
8/17/2019 JSH Aditya Kiran_Employee Information System
17/35
17
HOME PAGE
-
8/17/2019 JSH Aditya Kiran_Employee Information System
18/35
18
ADD DEPARTMENT
DEPMT Table contains details of different departments
Field Name Data Type/Size DescriptionDEPTID Number Department id
DEPT Varchar(20) Department
-
8/17/2019 JSH Aditya Kiran_Employee Information System
19/35
19
VIEW DEPARTMENT
-
8/17/2019 JSH Aditya Kiran_Employee Information System
20/35
20
ADD DESIGNATION
DESGN Table contains details of different designations
Field Name Data Type/Size Description
DESIGID Number Designation id
DESIG Varchar(20) Designation
-
8/17/2019 JSH Aditya Kiran_Employee Information System
21/35
21
ADD ROLES
ROLES Table contains details of different rolesField Name Data Type/Size Description
SNO Number Serial number
ROLES Varchar(20) Role
-
8/17/2019 JSH Aditya Kiran_Employee Information System
22/35
22
ADD EMPLOYEE
EMPLOYEE4 Table contains the details of employees
Field Name Data Type/Size DescriptionEID Number Employee id
DEPT Varchar(20) Department
DESIG Varchar(20) Designation
ENAME Varchar(20) Employee name
GENDER Varchar(20) Gender
DOB Varchar(20) Date of birth
ADDRESS Varchar(50) Address
MAIL Varchar(20) Email address
CONT Varchar(20) Contact number
CATEGORY Varchar(20) Category
JD Varchar(20) Joining dateVALIDDATE Varchar(20) Valid date
DEPTFROM Varchar(20) Deputation from
DEPTTO Varchar(20) Deputation to
WORKAREA Varchar(20) Work area
REPTTO Varchar(20) Reporting to
-
8/17/2019 JSH Aditya Kiran_Employee Information System
23/35
23
EMPLOYEE VIEW
-
8/17/2019 JSH Aditya Kiran_Employee Information System
24/35
24
-
8/17/2019 JSH Aditya Kiran_Employee Information System
25/35
25
ADD PROGRAMS
PROGRAMS Table contains the details of programs
Field Name Data Type/Size Description
ID Number Serial Number
PROGRAM Varchar(20) Program name
CORD Varchar(20) Coordinator
OBJ Varchar(20) Objective
NATURE Varchar(20) Nature of the program
FD Date From Date
TD Date To Date
TT Varchar(20) Timetable
FB Varchar(20) FeedbackFEE Varchar(20) Fee
AMOUNT Varchar(20) Amount
-
8/17/2019 JSH Aditya Kiran_Employee Information System
26/35
26
MODIFY PROGRAM
-
8/17/2019 JSH Aditya Kiran_Employee Information System
27/35
27
PROGRAM MANAGEMENT
-
8/17/2019 JSH Aditya Kiran_Employee Information System
28/35
28
PREPARE PROGRAM TIMETABLE BY ENTERING NUMBER OF
SESSIONS.
-
8/17/2019 JSH Aditya Kiran_Employee Information System
29/35
29
PREPARE PROGRAM TIMETABLE
SESS4-This table is used to manage programs when there are 4 sessions
Field Name Field Name Description
PROGRAM Varchar(20) Program name
DURATION Varchar(20) Duration of the program
PROGDATE Date Program Date
SESS1 Varchar(20) Session 1
FAC1 Varchar(20) Faculty
SESS2 Varchar(20) Session2
FAC2 Varchar(20) Faculty
SESS2 Varchar(20) Sesssion
FAC2 Varchar(20) Faculty
SESS3 Varchar(20) Session
FAC3 Varchar(20) Faculty
SESS4 Varchar(20) SessionFAC4 Varchar(20) Faculty
-
8/17/2019 JSH Aditya Kiran_Employee Information System
30/35
30
ADD PARTICIPANT
ATTENDEELOGIN-This table is used to enter the details of the participants who will be
participating in the programs
Field Name Field Name Description
PNO Varchar(20) Program name
DATE1 Date Duration of the program
PNAME Varchar(20) Program Date
PROGNAME Varchar(20) Session 1
STATUS Varchar(20) Faculty
CODE Varchar(20) Session2
ORG Varchar(20) Faculty
SD Date Sesssion
DESIG Varchar(20) Faculty
ED Date Session
ADDRESS Varchar(20) Faculty
CITY Varchar(20) Session
VNO Varchar(20) Faculty
TIME TimeStamp(6) Session
FAC5 Varchar(20) Faculty
-
8/17/2019 JSH Aditya Kiran_Employee Information System
31/35
31
These are the other tables used in my project
TERMINATE Table contains the details of employees
Field Name Data Type/Size Description
EID Varchar(20) Employee id
DEPT Varchar(20) DepartmentDESIG Varchar(20) Designation
ENAME Varchar(20) Employee name
GENDER Varchar(20) Gender
DOB Varchar(20) Date of birth
ADDRESS Varchar(50) Address
MAIL Varchar(20) Email address
CONT Varchar(20) Contact number
CATEGORY Varchar(20) Category
JD Varchar(20) Joining date
VALIDDATE Varchar(20) Valid date
DEPTFROM Varchar(20) Deputation from
DEPTTO Varchar(20) Deputation to
WORKAREA Varchar(20) Work area
REPTTO Varchar(20) Reporting to
PROG1 –This table is used to add any new programs
Field Name Field Name Description
SNO Number Serial Number
PROGRAM Varchar(20) Program name
NATURE Varchar(20) Nature of the program
DURATION –This table is used to store the duration of the programs.
Field Name Field Name DescriptionSNO Number Serial Number
DURATION Varchar(20) Duration of the program
-
8/17/2019 JSH Aditya Kiran_Employee Information System
32/35
32
SESS5-This table is used to manage programs when there are 5 sessions
Field Name Field Name Description
PROGRAM Varchar(20) Program name
DURATION Varchar(20) Duration of the programPROGDATE Date Program Date
SESS1 Varchar(20) Session 1
FAC1 Varchar(20) Faculty
SESS2 Varchar(20) Session2
FAC2 Varchar(20) Faculty
SESS2 Varchar(20) Sesssion
FAC2 Varchar(20) Faculty
SESS3 Varchar(20) Session
FAC3 Varchar(20) Faculty
SESS4 Varchar(20) Session
FAC4 Varchar(20) FacultySESS5 Varchar(20) Session
FAC5 Varchar(20) Faculty
SESS6-This table is used to manage programs when there are 6 sessions
Field Name Field Name DescriptionPROGRAM Varchar(20) Program name
DURATION Varchar(20) Duration of the program
PROGDATE Date Program Date
SESS1 Varchar(20) Session 1
FAC1 Varchar(20) Faculty
SESS2 Varchar(20) Session2
FAC2 Varchar(20) Faculty
SESS2 Varchar(20) Sesssion
FAC2 Varchar(20) Faculty
SESS3 Varchar(20) Session
FAC3 Varchar(20) Faculty
SESS4 Varchar(20) Session
FAC4 Varchar(20) Faculty
SESS5 Varchar(20) Session
FAC5 Varchar(20) Faculty
SESS6 Varchar(20) Session
FAC6 Varchar(20) Faculty
-
8/17/2019 JSH Aditya Kiran_Employee Information System
33/35
33
PUBLISH-This table is used to add the date ,time and venue for group photograph and
special lunch.
Field Name Field Name DescriptionPROG Varchar(20) Program name
CORD Varchar(20) Duration of the program
FD Date Program Date
TD Date Session 1
DATE1 Date Faculty
TIME1 TimeStamp(6) Session2
VENUE1 Varchar(20) Faculty
DATE2 Date Sesssion
TIME2 TimeStamp(6) Faculty
VENUE2 Varchar(20) Session
-
8/17/2019 JSH Aditya Kiran_Employee Information System
34/35
34
SYSTEM TESTING
SOFTWARE TESTING TECHNIQUES:
Software testing is a critical element of software quality assurance and represents
the ultimate review of specification, designing and coding.
TESTING OBJECTIVES:
1.
Testing is process of executing a program with the intent of finding an error.
2. A good test case design is one that has a probability of finding an as yet undiscovered
error.
3.
A successful test is one that uncovers an as yet undiscovered error.
These above objectives imply a dramatic change in view port.
Testing cannot show the absence of defects, it can only show that software errors
are present.
-
8/17/2019 JSH Aditya Kiran_Employee Information System
35/35
35
CONCLUSION
The project titled as EMPLOYEE INFORMATION SYSTEMwas deeply studied and
analyzed to design the code and implement. It was done under the guidance of the
experienced project guide. All the current requirements and possibilities have been taken
care during the project time.
Employee information system is used for daily operations in any organization to
maintain or access employee related information for internal administration purposes.