Employee Management System

MY 6TH SEMESTER PROJECT PRESENTATION

1. EMPLOYEE MANAGEMENT SYSTEM
GEA Process Engineering (India) Private
Limited
Submitted By
Vivek S. Shah
Exam No-230
Developed
For :

2. 1. Project Profile
Project Title EMPLOYEE MANAGEMENT SYSTEM
Developed For GEA Process Engineering (India) private Limited
Project Description This Application Provide the Employee Self Service Employee
Management
Project Duration 6 Months.
Type Of Application Intranet (Multi User System )
Front end tools JAVA Technology (JSP, Servlets, JDBC) Using MVC Architecture
Back end tools ORACLE 10.2.1G
Tools IDE : Netbeans 6.8 Reporting Tool : Jasper Report

3. 2. About the Organization
GEAProcessEngineering(India)PrivateLimited,formerlyknownasL&T-NiroLimitedandFood
Division(Dairy)ofLarsen&ToubroLimited,India,arenowapartofGEAProcessEngineeringDivision
(Processing,MembraneFiltration,Concentration,Drying,PowderProcessing&Handling,andsupplies
customizedandadvancedplant&equipmentwithsafeandreliableprocesscontrols.GEAP-Divisionis
partoftheProcessEngineeringsegmentofGEAGroupAktiengesellschaft,Germany.
GEAProcessEngineering(India)PrivateLimitedhasastrongProjectManagementTeamandwehave
suppliedseveralhigh-techplantstotheleadingmanufacturersinFood&Dairy,BreweryandChemical
sectorsonaturnkeyandEPC(Engineering,Procurement&Construction)basis.Weoffertotal
solutions-from"ConcepttoCommissioning"withGEA'sintegratedstrengthinProcessTechnology,
Basic&DetailedEngineering,Equip-Division),worldleaderinliquidandsolidprocessing
technologies.GEAP-DivisionfocusesonLiquidentFabrication,Automation,Project
Management,Construction&Commissioningtobuildturnkeyprojectsforacompleterangeofplants
&systems.
GEAProcessEngineering(India)PrivateLimitedisapartoftheGEAProcessEngineeringDivision(P-
Division)ofGEAGroupGermany.GEAstandsforGlobalEngineeringAllianceandisaleadingglobal
technologygroup.

4. 3.1 Existing System
ExistingEMS(EmployeeManagementSystem)isbasedonStandalonesystem.
ItisdevelopedunderAccess95that’swhyitisnotcompatiblewithnewoperatingsystem.
TheHRAdministrationfallsshortofcontrollingtheemployee’sactivitiesinanalyzing
his/herstrengthsandweakness.
Thedecisionforappraisalofassigningnextprojecttotheemployeeortotrainhim/herto
enhancetheskills–wherelieswithproperprojection.
Heisnotprovidedwiththedetailedprojectinformationdoneortobeassignedbasedon
Application/Verticals
ExistingEMSisnotmuchuser-friendly.

5. 3.2 Drawback of existing
System
Needofextramanualeffort.
Ascurrentsystemisstandalonenormalemployeescannottracktheiremploymentstatus.
Itusedtotakemuchtimetofindanyemployee
Notverymuchaccurate.
SystemiscompatibleuptowindowsXP.
Dangeroflosingthefilesinsomecases.
Certainrequiredreportisnotavailable
itismuchcomplextointeractwithexistingEMS.

6. 4.1 Need For New System
Theproposedsystemisintranetbasedsystemsoemployeecanalsoparticipateinthis
systemandtracktheirstatus.
TheProposedsystemprovidesdomainloginasperorganizationrequirementsononeedto
rememberuseridorpassword.
Theproposedsystemprovidesdetailgeneralinformationabouttheemployeealongwith
Educational,Certification,SkillandProjectdetails.
ItenhancestheHRManagementinadding,viewingandupdatingemployees’detailsand
generatesvariousreportsregardingemployee’sskillandexperience.
TheproposedsystemofHRModuleistherightsoftwaretobeincorporatedintothe
AutomationofHRSoftwareforhelpingtheorganizationneedswithrespecttoskilful
HumanResource.

7. 4.2 Advantages of New System
AS it is intranet application it can be accessed by multiple user at a time.
Proposed system provides domain login facility so no need to remember user id and
password.
Very fast and accurate.
No need of any extra manual effort.
Just need a little knowledge to operate the system.
Doesn’t require any extra hardware device.

8. 5.1 Hardware Requirement
Component Web Server Database Server Client
System Dell Server Dell Server Dell Desktop
Processor Intel Xeon 2.8 GHZ Intel Xeon 2.8 GHZ Intel Pentium IV
Main Memory 512 GB 2 GB 512 GB
Hard Disk 8 GB IDE (Seagate) 30 GB IDE (Seagate) 2 GB IDE (Seagate)

9. 5.2 Software Requirement
WEB SERVER SYSTEM
Software Used Remark
Apache Tomcat 6.0 It is being used as application server as well as web server.
IE 7 or Later It is being used as front end of the system and even for testing
DATABASE SERVER SYSTEM
Software Used Remark
Oracle 10.2.1 G C Server It is being used as back-end which holds all the database
CLIENT SYSTEM
Software Used Remark
IE 7 or Later It is being used as front end of the system and even for testing

10. 6.1 Project Management |Project
Development
OursoftwareisbasedonWaterfallModel.
Thewaterfallmodelisasequentialsoftwaredevelopmentprocess,inwhichprogressisseenas
flowingsteadilydownwards(likeawaterfall).
Thewaterfalldevelopmentmodelhasitsoriginsinthemanufacturingand
constructionindustries;highlystructuredphysicalenvironmentsinwhichafter-the-factchanges
areprohibitivelycostly,ifnotimpossible.Sincenoformalsoftwaredevelopmentmethodologies
existedatthetime,thishardware-orientedmodelwassimplyadaptedforsoftware
development.
Tosolveactualproblemsinanindustrysetting,asoftwareengineerorateamofengineersmust
incorporateadevelopmentstrategythatencompasstheprocess,methods,andtoolslayers.

11. 6.1 Project Management |Project
Development
The unmodified "waterfall model". Progress flows from the top to the bottom, like a waterfall.

12. 6.2 Project Management |Project
Planning
ProjectManagementisthedisciplineofplanning,organizing,andmanagingresourcestoring
aboutthesuccessfulcompletionofspecificprojectgoalsandobjectives.
Theprimarychallengeofprojectmanagementistoachievealloftheprojectgoalsand
objectiveswhileadheringtoclassicprojectconstraints—usuallyscope,quality,timeandbudget.
Thesecondary—andmoreambitious—challengeistooptimizetheallocationandintegrationof
inputsnecessarytomeetpre-definedobjectives.

13. 6.2 Project Management |Project
Planning
Month Employee Information Manager Module
Dec
Learning MVC Architecture & other useful technologies Such as JavaScript, CSS, JSP, Servlets, EJB, Jasper
Report
Jan Analyzing companies existing automated standalone HRIS.
Analyzing company’s behavior to meet new requirements.
Prototyping of HRIS to meet new requirements.
Deciding the dataflow of system
Feb Database designing
System Designing
March Development of System (bean classes, Dao classes and Servlets)
AprilDevelopment of System (bean classes, Dao classes and Servlets)
Preparing Application server for deploying system
Deploying and testing system
May Integrating system with actual data
Designing report (using jasper report) required by company
integrating system with other module
Documentation
June Documentation

14. 6.3 Project Management |GANNT Chart

15. 7.1 System User | Introduction
For every web application complexity is directly proportional to the number of user’s categories for
the system.
Theusersof“GEAEIM(EmployeeInformationManager)”resideatthreelevelsintheorganization.
Asrequirementsofalllevelsusersareconsideredindevelopmentofthesystem,itcanbeeasilyfit
toallexpectationsofalltypesofsystemusersofanylevel.
There are three types of users:
Administrator.
Line Manager.
Employee.
Administrator : Can Add, Edit employee information. Permission to build different reports.
Line Manager: can access information of employee under his/her department.
Employee : can access his own details

16. 7.2 System User | User Hierarchy
Thecategoriesofend-userwhowillinteractwiththe“GEAEIM(EmployeeInformationManager)”web
application.Usercategoriesarerelativelylimited.However,whenthenumberofusercategories
grows,itisadvisabletodevelopauserhierarchyasshownbelow:

17. 8.1 System Analysis | Feasibility
Study
…noteverythingimaginableisfeasible,noteventhesoftwareasitmayappearbasicallya
softwareisacceptableifitistechnically,financiallyandoperationallyfeasible.
whatdoesTechnicallyFeasibilitymeans
whethersuggestedtechnologyexistorcanbeacquiredfromthemarketornot
whatdoesFinancialFeasibilitymeans
Itisfinanciallyfeasibleifitisbuildatcostwhichisaffordablebyitsclient
whatdoesOperationalFeasibilitymeans
shouldbeusedtoreducethedefectsorfulfilltherequirementsmatchingtheuser’sneeds.
&shouldnotaffecttheexistingoperationsoftheorganizationandcanbeputintouseby
easywithoutresistance(toacquirethenewskillsrequired).

18. 8.1 System Analysis | Feasibility
Study
TechnicalFeasibility:
TheminimumrequirementtoimplementthesystemisPentium-IVprocessorwith512MBRAM,
AnyOperatingSystem,JavaRunTimeEnvironment.Thesearethesoftware’swhicharemost
popularandeasilyavailableinthemarket.
EconomicalFeasibility:
Itismorecommonlyacost-benefitanalysisofthesystem.Theratioofonetimecostorrecurring
costshouldnotexceedthebenefitsfromthesystem.CostofacquiringMachine,Software,
OperationalSetup,trainingcost.AsSaidearlierCompanyisMultinationalanditiswell
infrastructure.NoExtracostforsetupofoperatingenvironmentneededasthecomputeris
alreadyinuseforotherpurposes.Andthestaffiswellconversantandfamiliarwiththecomputer
technology.Onlytheuseofthe‘GEAEIM’isneeded.ThesystemisUserfriendlyandneed
minimumdataentryfromtheendusers,thusiseasytouse.
OperationalFeasibility:
Thissystemwillreducetheworkloadandlossofinformation,savestimeandwouldhelptothe
systemgeneralizedratherthanpersondependent

19. 8.3 System Analysis | Activity
Diagram

20. 8.3 System Analysis |Use Case
Diagram
For Admin User :

21. 8.3 System Analysis |Use Case
Diagram
For Line Manager User :

22. 8.3 System Analysis |Use Case
Diagram
For Simple User :

23. 8.4 System Analysis |Data Flow DiagramEmployee
Information
Manager
Administrator
View Employee
Edit employee
Report building
Add Employee
Trace Employee
Line Manager
Access own profile
View employee
Report builder
Simple Employee
Access own profile
Context Diagram :

24. 8.4 System Analysis |Data Flow DiagramDomain
Login
Administrator
Line Manager
Establishment
Table
Master tables
Domain login Checks domain name
Result
Successfully login
Master table
operation
masters
result
masters
result
Employee
Informaiton
Manager
Employee list
result Employee details
Employee list
result
Employee list
Result
First Level Diagram :

25. 8.4 System Analysis |Data Flow Diagram
Second Level Diagram (Adding Employee) : Employee
Information
Manager
Employment
details
Administrator
Employee
Establishment
details
Add employee
Result
Add employee
Result
Insert employee details
Employee
details
Employment details
Result
Verify employee
Result
Employee details
ResultResult

26. 8.4 System Analysis |Data Flow Diagram
Second Level Diagram (For tracing employee and reporting utility : Utilities
Administrator
Establishment
Table
Employee
Details
Employment
Details
Trace Employee
Trace Employee
Result
Result
Report
Report
Report
Result
Result
Result

27. 8.5 System Analysis |Technology
Used
Servlet
Jsp
Ajax
XML&Java
JDBC
MVC(Model–View–Control)Architecture
Oracle10g
i-Report
jQuery
JavaScript
CSS(CascadingStyleSheets)

28. 9.1 System Design |Introduction
This phase is a move from user requirement to defining how system will work thus it
is quite technical it specifies
Exactly each input , output, data audit and control requirement will be handled
Acceptance test plan/ scheduled
Facilities, equipments and personal required
Manual procedures required to operate system.
Database Design :
The most popular relational database model is used for permanent storage of data. It is two
dimensional and easy to handle. Thus logical and physical changes are easy to handle.

29. 9.2 System Design |Data Dictionary
TABLE -MASTERGROUP
This table consist of all master table used in application
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
GROUPID NUMBER(2,0) Primary Key Master Group ID
GROUPNAME VARCHAR2(60 BYTE) - Master Tables Description
TABLE -EIMRIGHTS (Employee Information Manager)
This table consist of List of all HR Rights given to each employee For Example Simple User Right, Line Manager Right, Admin Right
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
HRRIGHTSID NUMBER(1,0) Primary Key Human Resource Rights ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
HRRIGHTSNAME CHAR(12 BYTE) - Human Resource Rights Description
TABLE -TRRIGHTS (Time Regestration)
This table consist of List of all TR Rights given to each employee For Example No Right, Key in right, Approval Right, CreateProject right, block project right.
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
TRRIGHTSID NUMBER(1,0) Primary Key Time RegestrationRights ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
TRRIGHTSNAME CHAR(15 BYTE) - Time Regestration Rights Description
TABLE -BLOODGROUP
This table consist of List of all blood group (A+, B+, AB+, O+ … ETC)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
BLOODGROUPID NUMBER(2,0) Primary Key Bloodgroup ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
BLOODGROUPNAME VARCHAR2(7 BYTE) - Bloodgroup Description
TABLE -CATEGORY
This table consist of List of all category (General, SC, ST, OBC)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
CATEGORYID NUMBER(1,0) Primary Key Category ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
CATEGORYNAME CHAR(7 BYTE) - Category Description

30. 9.2 System Design |Data Dictionary
TABLE -GENDER
This table consist of List of gender (Male, Female)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
GENDERID NUMBER(1,0) Primary Key Gender ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
GENDERNAME CHAR(6 BYTE) - Gender Description
TABLE -MARITALSTATUS
This table consist of List of marital status (Single, Married, Divorcee, Widow)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
MARITALSTATUSID NUMBER(1,0) Primary Key Marital Status ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
MARITALSTATUSNAME CHAR(8 BYTE) - Marital Status Description
TABLE -NATIONALITY
This table consist of List of nationality (Indian, Foreign)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
NATIONALITYID NUMBER(1,0) Primary Key Nationality ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
NATIONALITYNAME CHAR(7 BYTE) - Nationality Description
TABLE -RELIGION
This table consist of List of all religions (Hindu, Jain, Muslim, Christan…ETC)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
RELIGIONID NUMBER(2,0) Primary Key Religion ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
RELIGIONNAME CHAR(30 BYTE) - Religion Description

31. 9.2 System Design |Data Dictionary
TABLE -EDUCLASS
This table consist of List of education result class (Dist, First, Second, Pass)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
EDUCLASSID NUMBER(1,0) Primary Key Education Class ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
EDUCLASSNAME CHAR(6 BYTE) - Education Class Description
TABLE -EDULEVEL
This table consist of List of education levels (Diploma, Bachelor, Masters, Professional, Other)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
EDULEVELID NUMBER(1,0) Primary Key Education Level ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
EDULEVELNAME CHAR(12 BYTE) - Education Level Description
TABLE -RELATION
This table consist of List of relationships (Father, Mother, Brother, Sister, Spouse, Son, Daughter, Other)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
RELATIONID NUMBER(1,0) Primary Key Relationship ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
RELATIONNAME CHAR(8 BYTE) - Relationship Description
TABLE -STATE
This table consist of List of all states with in india
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
STATEID NUMBER(2,0) Primary Key State ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
STATENAME VARCHAR2(60 BYTE) - State Description

32. 9.2 System Design |Data Dictionary
TABLE -LANGUAGES
This table consist of List of languages (English, Hindi, Tamil, Gujarati, Marathi…ETC)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
LANGUAGESID NUMBER(2,0) Primary Key Language ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
LANGUAGESNAME CHAR(60 BYTE) - Language Description
TABLE -LANGUAGEFLUENCY
This table consist of List of language Fluency (Read, Write, Speak)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
LANGFLUENCYID NUMBER(1,0) Primary Key Language Fluency ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
LANGFLUENCYNAME CHAR(25 BYTE) - Language Fluency Description
TABLE -NOMINEESCHEME
This table consist of List of nomination scheme (EPF, EPS, Grauity)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
NOMINEESCHEMEID NUMBER(1,0) Primary Key Nominee Scheme ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
NOMINEESCHEMENAME CHAR(8 BYTE) - Nominee Scheme Description
TABLE -TRAININGTYPE
This table consist of List of type of training (Managerial, Technical)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
TRAININGTYPEID NUMBER(1,0) Primary Key Training ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
TRAININGTYPENAME CHAR(12 BYTE) - Training Description

33. 9.2 System Design |Data Dictionary
TABLE -EMPSTATUS
This table consist of List employee status (Confirm, Probation, Contract, Retainership)
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
EMPSTATUSID NUMBER(1,0) Primary Key Employee Status ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
EMPSTATUSNAME CHAR(12 BYTE) - Employee Status Description
TABLE -FUNCTIONS
This table consist of List employee functionality
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
FUNCTIONSID NUMBER(2,0) Primary Key Employee Function ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
FUNCTIONSNAME CHAR(30 BYTE) - Employee Function Description
TABLE -DEPARTMENTS
This table consist of List of all departments with In organization
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
DEPARTMENTSID NUMBER(2,0) Primary Key Department ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
DEPARTMENTSNAME CHAR(60 BYTE) - Department Description
TABLE -DESIGNATION
This table consist of List of all designation
COLUMN_NAME DATA_TYPE CONSTRAINTS Description
DEPARTMENTSID NUMBER(2,0) Foreign Key Department ID
DESIGNATIONID NUMBER(2,0) Primary Key Designation ID
GROUPID NUMBER(2,0) Foreign Key Master Group ID
DESIGNATIONNAME CHAR(60 BYTE) - Designation Description

34. 9.2 System Design |Data Dictionary
TABLE -ESTABLISHMENT
This table consist of establishment details of each employee such as employee code, employee name, domaiinname, email address etc.
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Primary KeyEmployee Code
FIRSTNAME CHAR(15 BYTE) Not Null First Name
MIDDLENAME CHAR(15 BYTE) - Middle Name
LASTNAME CHAR(15 BYTE) Not Null Last Name
DOMAINNAME VARCHAR2(35 BYTE) Unique Domain Name
EMAIL VARCHAR2(50 BYTE) Unique Email Address
REGDATE DATE - Date of Establsihement Form
STATECLIENT NUMBER(2,0) - State For Tracking work of Simple user
STATEADMIN NUMBER(1,0) - State For Tracking work of Admin user
HRRIGHTS NUMBER(1,0) Foreign KeyHR Right to Employee
TRRIGHTS NUMBER(1,0) Foreign KeyTR Right to Employee

35. 9.2 System Design |Data Dictionary
TABLE -EMPLOYEEDETAILS
This table consist of personal details, contact details, emergency contact dertails, immigration details and employment details of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
PD_DOB DATE - Date of Borth
PD_GENDER NUMBER(1,0) Foreign Key Gender
PD_NATIONALITY NUMBER(1,0) Foreign Key Nationality
PD_BLOODGROUP NUMBER(2,0) Foreign Key Bloodgroup
PD_MARITALSTATUS NUMBER(1,0) Foreign Key Marital
PD_CATEGORY NUMBER(1,0) Foreign Key Category
PD_RELIGION NUMBER(2,0) Foreign Key Religion
PD_LICENSENUM VARCHAR2(14 BYTE) - Licenses number
CD_Add1 VARCHAR2(35 BYTE) - Present Address1
CD_Add2 VARCHAR2(35 BYTE) - Present Address2
CD_Add3 VARCHAR2(35 BYTE) - Present Address3
CD_CITY VARCHAR2(50 BYTE) - Present Address City
CD_STATE NUMBER(2,0) Foreign Key Present Address State
CD_PINCODE NUMBER(6,0) - Present Address Pincode
CD_PAdd1 VARCHAR2(35 BYTE) - Permanent Address1
CD_PAdd2 VARCHAR2(35 BYTE) - Permanent Address2
CD_PAdd3 VARCHAR2(35 BYTE) - Permanent Address3
CD_PCITY VARCHAR2(50 BYTE) - Permanent Address City
CD_PSTATE NUMBER(2,0) Foreign Key Permanent Address State
CD_PPINCODE NUMBER(6,0) - Permanent Address Pincode
CD_OPHONE NUMBER(15,0) - Office Phone
CD_RPHONE NUMBER(15,0) - Resident Phone
CD_MOBILE NUMBER(13,0) - Mobile Number
CD_OEMAIL VARCHAR2(35 BYTE) - Other Email ID

36. 9.2 System Design |Data Dictionary
COLUMN_NAME DATA_TYPE Constraints Description
ED_RELATION NUMBER(1,0) - Emergency Contact Person Relation
ED_Add1 VARCHAR2(35 BYTE) - Emergency Contact Person Add1
ED_Add2 VARCHAR2(35 BYTE) - Emergency Contact Person Add2
ED_Add3 VARCHAR2(35 BYTE) - Emergency Contact Person Add3
ED_CITY VARCHAR2(50 BYTE) - Emergency Contact Person City
ED_STATE NUMBER(2,0) Foreign Key Emergency Contact Person State
ED_MOBILE NUMBER(13,0) - Emergency Contact Person Mobile
ID_PASSNUM VARCHAR2(7 BYTE) - Passport Number
ID_YOI NUMBER(4,0) - Year of Issue (Passport)
ID_YOE NUMBER(4,0) - Year of Expiry (Passport)
ID_POI VARCHAR2(25 BYTE) - Place of Issue (Passport)
JD_EMPSTATUS NUMBER(1,0) Foreign Key Employee Status
JD_DOJ DATE - Date of Joining
JD_DOL DATE - Date of Leaving
JD_FUNCTIONS NUMBER(2,0) Foreign Key Employee Function
JD_DEPT NUMBER(2,0) Foreign Key Department
JD_DESIGNATION NUMBER(2,0) Foreign Key Designation
RD_EMPCODE NUMBER(7,0) Foreign Key Report to Employee Code
ND_PFNUM VARCHAR2(18 BYTE) - EPF Number
ND_EPSNUM VARCHAR2(17 BYTE) - EPS Number
Primary Key : ESTABLISHMENTCODE

37. 9.2 System Design |Data Dictionary
TABLE -PHOTO
This table contains photo of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
UP_PHOTODATA BLOB - Uploaded Photo Content
Primary Key : ESTABLISHMENTCODE
TABLE -FAMILYDETAILS
This table contains family details of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
DD_ID NUMBER(7,0) Primary Key Person ID
DD_DNAME CHAR(35 BYTE) - Person Name
DD_DRELATION NUMBER(1,0) Foreign Key Relationship with employee
DD_DDOB DATE - Person Date of birth
DD_AGE NUMBER(3,0) - Person Age
DD_OCCUPATION VARCHAR2(50 BYTE) - Person Occupation
Primary Key : DD_ID
TABLE -LANGUAGES
This table contains languages known by each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
LD_LANGID NUMBER(2,0) Foreign Key Language Id
LD_LANGFLUENCY NUMBER(1,0) Foreign Key Language Fluency Id
Primary Key : ESTABLISHMENTCODE + LD_LANGID

38. 9.2 System Design |Data Dictionary
TABLE -EDUCATIONSCHOOL
This table contains schooling education data of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
QD_SCH_LEVEL NUMBER(1,0) Foreign Key SSC or HSC
QD_SCH_NAME VARCHAR2(75 BYTE) - School Name
QD_SCH_BNAME VARCHAR2(50 BYTE) - Board Name
QD_SCH_YOQ NUMBER(4,0) - Year of Qualification
QD_SCH_PERCENTAGE NUMBER(5,2) - Result
Primary Key : ESTABLISHMENTCODE +
QD_SCH_LEVEL
TABLE -EDUCATIONCOLLAGE
This table contains education details of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
QD_COL_ID NUMBER(7,0) Primary Key Qualification ID
QD_COL_LEVEL NUMBER(3,0) Foreign Key Diploma, Bachelor, Masters or Professional
QD_COL_DEGREE VARCHAR2(75 BYTE) - Degree Name
QD_COL_NAME VARCHAR2(75 BYTE) - Collage Name
QD_COL_UNAME VARCHAR2(50 BYTE) - University Name
QD_COL_YOQ NUMBER(4,0) - Year of Qualification
QD_COL_PERCENTAGE NUMBER(5,2) - Result
Primary Key : QD_COL_ID

39. 9.2 System Design |Data Dictionary
TABLE -TRAININGDETAILS
This table contains training details of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
TD_ID NUMBER(7,0) Primary Key Training ID
TD_TYPESOF NUMBER(1,0) Foreign Key Types of Training
TD_FACULTY VARCHAR2(50 BYTE) - Faculty of Training
TD_DURATIONOF NUMBER(3,0) - Duration of Training
TD_YEAROF NUMBER(4,0) - Year of Training
TD_COSTOF NUMBER(7,0) - Cost of Training
TD_STATE NUMBER(1,0) - state for tracking Training
Primary Key : TD_ID
TABLE -EXPERIENCE
This table contains experience details of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
XD_ID NUMBER(7,0) Primary Key Experience ID
XD_EMPLOYERNAME VARCHAR2(50 BYTE) - Employer Name
XD_EMPLOYERADDRESS VARCHAR2(120 BYTE) - Employer Address
XD_ANAME VARCHAR2(20 BYTE) - Signatory Person Name
XD_ACONTACT NUMBER(15,0) - Signatory Person Contact Number
XD_AEMAIL VARCHAR2(35 BYTE) - Signatory Person Email Address
XD_DESIGNATION CHAR(25 BYTE) - Designation
XD_DOJ DATE - Date of Joining
XD_DOL DATE - Date of Leaving
XD_DURATION NUMBER(4,0) - Duation
XD_SALARY NUMBER(7,0) - Salary
Primary Key : XD_ID

40. 9.2 System Design |Data Dictionary
TABLE -NOMINEE
This table contains nomination details of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
ND_NOMINEEID NUMBER(7,0) Primary Key Nominee ID
ND_SCHEME NUMBER(1,0) - Nomination Scheme
ND_NAME VARCHAR2(30 BYTE) - Nominee Name
ND_RELATION NUMBER(1,0) - Nominee Relation
ND_ADDRESS VARCHAR2(100 BYTE) - Nominee Address
ND_SHARE NUMBER(3,0) - Nominee Share
ND_DOB DATE - Nominee DOB
ND_STATE NUMBER(1,0) - Tracking state of Nominee
Primary Key : ND_NOMINEEID
TABLE -GUARDIAN
This table contains guardian details in case of nominee is minor
COLUMN_NAME DATA_TYPE Constraints Description
GD_NOMINEEID NUMBER(7,0) Foreign Key Nominee ID
GD_NAME VARCHAR2(30 BYTE) - Guardian Name
GD_ADDRESS VARCHAR2(100 BYTE) - Guardian Address
Primary Key : GD_NOMINEEID
TABLE -SALARY
This table contains salary details of each employee
COLUMN_NAME DATA_TYPE Constraints Description
ESTABLISHMENTCODE NUMBER(7,0) Foreign Key Employee Code
SD_DATE DATE - Date of Salary Implementation
SD_FIXEDCTC NUMBER(9,2) - Basic Salary
SD_EXTRA NUMBER(9,2) - Extra Incomes from allowances.. ect
Primary Key : ESTABLISHMENTCODE + SD_DATE

41. 9.3 System Design |PORCEDURAL
DESIGN
STEP:1Open the web site
STEP:2Ayou are domain user this website will automatically trace your profile
STEP: 2A-1After successful login then it can access desired right to the site
STEP: 2A-2can see list of all employees
STEP: 2A-3can see full profile of each employee
STEP: 2A-4can update information of any employee
STEP: 2A-5can insert more details for any employee
STEP: 2A-6can trace any employees profile and work on behalf of him
STEP: 2A-7can generate various reports
STEP: 2A-8can view his/her own profile
STEP:2BYou are not domain user
STEP:2B-1contact to administrator with employee code and domain name
Algorithm for Administrator

42. 9.3 System Design |PORCEDURAL
DESIGN
Algorithm for Line Manager
STEP:1Open the web site
STEP:2Ayou are domain user this website will automatically trace your profile
STEP: 2A-1After successful login then it can access desired right to the site
STEP: 2A-2can see list of all employees who is working under him/her
STEP: 2A-3can see full profile of each employee who is working under him/her
STEP: 2A-4can generate various reports
STEP: 2A-5can view his/her own profile
STEP:2BYou are not domain user
STEP:2B-1contact to administrator with employee code and domain name

43. 9.3 System Design |PORCEDURAL
DESIGN
Algorithm for Simple user
STEP:1Open the web site
STEP:2Ayou are domain user this website will automatically trace your profile
STEP:2A-1After successful login then it can access desired right to the site
STEP:2A-2can view his/her own profile
STEP:2BYou are not domain user
STEP:2B-1contact to administrator with employee code and domain name

44. 9.4 System Design |Flow DesignStart
Checks
domain name
of user
Select module
yes
Contact to
administrator
No
Admin EIM Time Regestration
Change
module
yes
END
No

45. 9.5 System Design |Design of Input
Screen
Inputscreenareuserfriendlyandcareistakenthatminimumamountofdataentryisdone.
Themasterinformationonceenteredandstoredisdisplayedinacomboboxorasalistforfurther
inputthustherearenochancesoferrorindataentryastheuseonlyhastoselecttheinformation
fromtheprovidedlist.
Keydataisdisplayedfromthemastertableswhereeverneededifanyredundancyexiststhenthe
dataisnotreentereditisfetchformappropriatetables.e.g.whileenteringmasterinformationitis
verifiedthatdataalreadyexistforthatentityonlythenfurtherdataisaccepted.Thusduplication
andredundancyisproperlyhandled.Linkforsavingisenabledonlyafterproperverificationand
validationofdataisdone.
Andbasicinformationisfirstvalidatedandthenfurtherdataentryisallowedthusitsaves
unnecessarydatatyping.Propermessagesareprovidedwhereeverneeded.Thuscareistakenfor
controlofdataandcorrectnessofdatawithminimumtypingefforts.
properconversionsofdatatypeandformatsaredone.
Heredomainloginisprovidedsononeedtorememberuseridandpassword.

46. 10.1 Implementation| Implementation
Environment
Thisapplicationismadebykeepinginmindthebasicconceptofcollaboration,theapplicationcan
beusedbyeachofthepersonatatimeontheirrespectivesystems.
Atatimemorethanoneusercanusethewebinterfacemadetosupporttheactualapplication.
Alsothewebsitedoesnotrequireanytypeofexternalinteractionandmakesuserabletohave
dynamicbrowsingonintranet,itisnevereveraffectedbythenumberofusersaccessingitatatime
ontheirrespectivelocation.
Thisapplicationisalsomadeinsuchawayastoprovideuserwiththemosteffectivegraphical
Interfacesothattheusercaneasilyperformtheirtask.
So,astheconclusionofabovetwopoints,thisapplicationishavingthemultiuserandeffectiveGUI
environmentfortheusers.

47. 10.2 Implementation| Security Features
Authenticationisnecessarytoenterintothesystem.Thisisrequiredtoprevent
unauthorizedaccesstothesystem.
Systemcanautomaticallyidentifyuserthroughdomainnameifitisnotinapplication
databasethenuserisnotallowedtoenterinsystem.
ServermaintainstheinformationisSessionswhenparticularuserentersintothesystem.
TheSessionisregularlycheckedwheneveritisrequired.

48. 10.2 Implementation| Coding Standard
TheSoftwareneedstobeupdatedfromtimetotimeaccordingthechangingneedsof
Users.SosomestandardsaretobemaintainedinimplementationandCoding,sothat
ifthesoftwareneedstobemodifiedduetosomechangesinUserneedsorsome
enhancementstobedone,thenit’seasyforthepersontofindsomespecificmodules,
pages,functions,variablesoreventhetablesorstoredproceduresinthedatabase.
Package Standard
Variable Standard
Comment Standard
Functional Standard
General Standard

49. 11 Testing
Testingisvitaltothesuccessofthesystem.Systemtestingmakeslogicalassumptionthatifall
thepartsofsystemarecorrect,thegoalwillbesuccessfullyachieved.Thissystemistestedby
followingtestcasesandpreparedforfinalimplementation.
TestCase1
Case:TestingoftheDomainLogin
Result:AlltheOperationsworksuccessfully.
TestCase2
Case:TestingoftheBasicModule
Result:Systemisnotabletodetectandgeneratecorrect
informationandExceptionProblem,validationproblem.
Reason:Thisoccurredbecausequeryisnotproperformat,scriptproblem
Solution:Aftergivingtheproperfunctionandquery,wecanabletogetcorrectresult.

50. 11 Testing
Test Case 3
Case :Testing of the EMS Module
Result : System is not able to generate correct out put.
Reason : This occurred because database was not normalized.
Solution : After making proper normalized we can able to get correct result
Test Case 4
Case :Testing of the Generated Report
Result : System is not able to generate correct out put.
Reason :his occurred because query is not properly fired
Solution : After giving the proper query, we can able to get correct result.
Test Case 5
Case :Testing of the admin(master) Module(Employee rights)
Result :All the Operations work successfully.

51. 12. Screen Shot | Home Page of
Admin

52. 12. Screen Shot | Add Employee

53. 12. Screen Shot | Assign Domain
Name

54. 12. Screen Shot | Personal Details
Form

55. 12. Screen Shot | Contact Details
Form

56. 12. Screen Shot | Emergency Contact
Details Form

57. 12. Screen Shot | Immigration Details
Form

58. 12. Screen Shot | Family Details Form

59. 12. Screen Shot | Qualification Details
Form

60. 12. Screen Shot | Languages Details
Form

61. 12. Screen Shot | Training Details
Form

62. 12. Screen Shot | Experience Details
Form

63. 12. Screen Shot | Nomination (EPF)
Form

64. 12. Screen Shot | Nomination (EPS)
Form

65. 12. Screen Shot | Uploading Photo

66. 12. Screen Shot | Verification in
Pending

67. 12. Screen Shot | Home page of Admin

68. 12. Screen Shot | Verification Report

69. 12. Screen Shot | Employment details
Form

70. 12. Screen Shot |Report to details
Form

71. 12. Screen Shot |Salary details Form

72. 12. Screen Shot |Employee List View

73. 12. Screen Shot |Employee Profile
View

74. 12. Screen Shot |Updating an
Employee

75. 12. Screen Shot |Adding more details in
future

76. 12. Screen Shot |Reporting Utility

77. 12. Screen Shot |Tracking Employee

78. 12. Screen Shot |Home Page of Line
Manager

79. 12. Screen Shot |EIM View of Line
Manager

80. 12. Screen Shot |Home Page of
Employee

81. 12. Limitation and Future
Enhancement
Limitations:
GEAEmployeemanagementsystemislimiteduptoprocessdepartmentofGEAGrouponly.
GEAEmployeemanagementsystemisnotoninternetapplication.
Future Enhancement:
GEAEmployeemanagementsystemwillbeenhanceduptoalldepartmentsofGEAGroup.
IntegratingLeavemanagementandAttendancesystem.
Asorganizationismultinationalmakeapplicationinternetbase.