documentation of employee management system

8/13/2019 DOCUMENTATION of Employee Management System

1/88

GUJARATCONTAINERSLIMITED

2013

EMPLOYEE

MANAGEMENT SYSTEMGUJARAT CONTAINERS LIMITED

MEET PANDYA

[ T Y P E T H E C O M P A N Y A D D R E S S ]


2/88

Index

Sr No Content

1 Objective &scope of the project

2 Theoretical background

3 Definition of problem4 System Analysis& Design (User requirement)

5 Methodology use ,system implementation & details of h/w & s/w used

6 System maintenance & evaluation

7 Cost & benefit analysis

8 Detail life cycle of project

9 Level of normalization applied

10 List of validation applied

10.1 Data dictionary with master & transaction with pk, fk. etc.

10.2 Input & output screen design

11 Process involved

12 Methodology used for testing

13 Test report ,print out of report ,print out of code sheet

14 Program coding

15 Limitation of System

16 Future scope

17 Conclusion

18 Bibliography


3/88


4/88

Certificate of originality

I am Meet Pandya hereby declare that the project work titled Employee

Management System is the original work done by me and submitted to the

Sikkim Manipal University in partial fulfillment of requirements for the final

project of Bachelor of Computer Application in Baroda Institute of Management

Studies. This project work done by me under the supervision of Mr. Neil shah

and I am not giving this project to any other university

Signature of student

Meet Pandya


5/88


6/88

College Profile

The total focus of the JC group of companies is to blend the career goals

of young aspiring generation with that of the organization & the society at

large. The unification of economies due to globalization & liberalization

has opened up avenues for our young aspirants, both at the domestic as

well as at the international level. This entails the need of revamping our

educational strategies and teaching methodologies moving from

theoretical to practical knowledge & understanding.

We at JC group realize these changes and are trying to develop such

executives & managers who can cope up with these dynamic challenges.

The JC group of companies demonstrates expertise in the field of

management, IT and applied health sciences. With well-developedinfrastructure and a spacious campus, equipped well-stocked library, P.C.

lab, and with the latest technological gadgets, we deliver plethora of

global degrees to suit the needs of the students.

The Group encompasses experts in their respective fields with faculties

and corporates and is proud to have tied up with various institutions

whereby we have key resource persons, soft-skills trainers, thereby

providing corporate interface along with academic standards, for our

much valued students. The JC group of companies is committed to

deliver a congenial environment for holistic development, whereby

differences are sorted out & synergies put together, in pursuit of the

ultimate summit excellence!


7/88

University Profile

Sikkim Manipal University (SMU) is the result of a unique partnershipbetween the Government of Sikkim and Manipal Education. Established

in 1995, it is the first government-private initiative in the region. It was

set up with the objective of providing the best in education for students.

SMU is recognized by theUniversity Grants Commissionand approvedby the Government

The beautiful campus is located in Majitar and Rangpo, amongst the

picturesque settings of River Teesta and Kanchendzonga mountains. It

hosts the second largest hospital in Sikkim, providing healthcare to the

masses. The medical campus runs courses on medical, pharmacy, alliedhealth and nursing while the technology campus has engineering,management courses, Twinning Programmes and AppliedSciences.

Sikkim Manipal University has the following constituent institutions:

Sikkim Manipal Institute of Medical Sciences (SMIMS)

Sikkim Manipal Institute of Technology (SMIT)

College of Nursing

College of Physiotherapy

School of Basic & Applied Sciences

As ranked by Competition Success Review - October 2009, Sikkim

Manipal Institute of Technology (SMIT) is ranked 8th amongst the Best

University Engineering Colleges of India. SMIT Ranked amongst 17th in

the Best Engineering Colleges of Excellence in India. SMIT has also

bagged 27th rank amongst the Top 50 Engineering Colleges of India.
http://smude.edu.in/recognitions/ugc-approvalhttp://smude.edu.in/recognitions/ugc-approvalhttp://smude.edu.in/recognitions/ugc-approvalhttp://smude.edu.in/recognitions/ugc-approval


8/88

ACKNOLEDGEMENT

We are very thankful to our facultyMr. Manish Shukla(HOD),for givingus opportunity and we are also very thankful to office members for giving us

the platform to present our view on the topic:

EMPLOYEE MANAGEMENT SYSTEM


9/88

ABOUT GUJARAT CONTAINERS LIMITEDGUJARAT CONTAINERS Ltd., a name that stands as the archetype of specially

designed Barrels in the industry. We are a leading and the only manufacturer

in India offering a huge variety of specialized Barrels under one roof. Ours is a

diversified Barrel company offering a wide range of containers manufactured

with perfection.

We comprehend the needs of our customers before time and ensure timely

supports services with excellent products. Our customers have given us a

mileage in this long journey that marked with loyalty and expertise.

Just like our technology, we have efficient manpower who converts needs into

complete products with exceptional services. The credit of our huge success in

the industry is attributed to our people who are the visionaries, accepting

opportunities and facing challenges.


10/88

VISION OF GUJARAT CONTAINERS LIMITED

TO OFFER WORLD-CLASS FUTURISTIC SOLUTIONS FORDIVERSE REQUIREMENTS.

MISSION

DISTINGUISH CUSTOMER NEEDS

ENSURE EXCELLENT SUPPORTING SERVICES.

Purpose-Objectives:-

Objective of this software project is to create a System which can host

Employee management system (EMS) provide System to maintain theinformation regarding Human Resources through field offices. So, that


11/88

manpower can be monitored at Head office. As internet is getting popular, this

System provides Online Desk System which can be accessed from anywhere,

anytime.

INTODUCTION TO PROJECT:-

The EMPLOYEE MANAGEMENT SYSTEM has been developed to

override the problems prevailing in the practicing manual system. This

software is supported to eliminate and in some cases reduce the hardships

faced by this existing system. Moreover this system is designed for the

particular need of the company to carry out operations in a smooth and

effective manner.

The application is reduced as much as possible to avoid errors while

entering the data. It also provides error message while entering invalid data.

No formal knowledge is needed for the user to use this system. Thus by this all

it proves it is user-friendly.

This Synopsis Describe how EMS (Employee management System) Will

Works And how can it manage Employee Attends, Leave, Company vehicle

management and Payroll management. With using EMS Employee are

managed in very manageable Way. This application is For an Every Department

of Organization. It Support, Service or Maintenances from PC user who are the

employees of the company.

Purpose:-

Objective of this software project is to create a System which can

host Employee management system (EMS) provide System to

maintain the information regarding Human Resources through field

offices. So, that manpower can be monitored at Head office. As

internet is getting popular, this System provides Online Desk System


12/88

which can be accessed from anywhere, anytime. As we know in any

technical educational office, the manager of office used to spare lot

of time even after the normal office hours either at home or office

for preparation of daily/weekly report and other necessary record.

Now with the help of this system ,the manager has the informationon his finger tips and can easily prepare a record based on their

requirements apart from daily/weekly report. Finally,We can say that

this system will not only auto-mate the process but save the valuable

time of the office manager, which can be well utilized by this

institute. This will be an additional advantage and manage-ment of

manpower based on their free time from his normal duty.

Scope:-

Project Duration:-Approximately 12 to 13 weeks to finish the project including testing and coding.

FEASIBILITY STUDY:-


13/88

The feasibility study of this project has revealed the project as

follows: -

Organizational feasibility:-

Focus on how well a proposed system supports the business priorities of

the organization

ECONOMIC FEASIBILITY

The project has shown the economic feasibility by the study of

the fact that by using this software the increased number of the

consumers can be given service effectively and efficiently and can

save a lot time and saving time means saving money. The cost and

benefit analysis has shown that cost that have incurred in

developing the project is less than the benefits that the project is

going to provide once it is developed, so this project has passed the

feasibility test.

BEHAVIOURAL FEASIBILITY

The working staff members are also interested in this project, as it

will help them to do work with ease and efficiently without


14/88

complexity, so they supported the development of this project with

full enthusiasm. This shows the behavioral feasibility of the project.

TECHNICAL FEASIBILITY :-

Technical feasibility centers on the existing computer system (Hardware,

Software etc) and to what extent it supports the existing system. As the

existing system computer system is viable so there is no matter of technical

feasibility that is the system is technically feasible.

TIME FEASIBILITY

It is the determination of whether a proposed project can be implemented

fully within stipulated time frame. The project was decided to be done in

three months and was thought to be feasible enough.

Schedule feasibility:-

Focus on the solution to be design and implemented within an acceptable time

period

Requirements Determination or information gathering is one of the

most important phases of software developing process.


15/88

If at this stage information is not gathered properly their then it may create many

big problems.

REQUIREMENT ANALYSIS:-

The aim of requirement analysis is to understand the exact

requirement of the customer and to document and to document

them properly. Requirement analysis involves obtaining a clear and

thorough understanding of the product to be developing with a view

to remove all ambiguities and inconsistencies from the initial

customer perception the problem.

The question arising during the requirement analysis phases is:-

What is the problem?

Why is it important to solve the problem?

What are the possible solutions to the problem?

What exactly are the data inputs and data outputs by

system?

What are the likely the complex cities that might arise

while solving the problem?

During requirement analysis there exist mainly two activities.

1. Requirement gathering

2. Analysis of gathered requirements.

Requirement gathering: -


16/88

This involves interviewing the end user and customers to collect all

possible information regarding the bank.

Analysis of gathered requirement: -

The main purchase of analysis is to collect information to clearly understand

the exact requirement of customer and resolve anomalies, conflicts and

inconsistencies in the gathered requirement.

System Evaluation:-

Evaluate or judge the performance of a system over a longer time period

than that just after immediate installation

Four problem areas contribute to system failure

1) Design:

- System perfect to capture essentials business requirements.- Good format of the system

- Good user interface2) Cost

- Cost to implement does not be over budget- System project does not be too costly to complete

3) Data

- Data accurate or consistent and properly organized- Information in certain fields prevent to be erroneous or ambiguous- Data complete

4) Operation

- System does run perfectly- Information is in timely and efficient manner- Response time may is not too long


17/88

1) Cost and benefit analysis

The typical failure of a cost benefit analysis is not including all the costs.

In the case of the stamping machine, here are some of the overlooked

costs:

Installation

what will it cost to remove the manual handling and install the new software?

Will you have to special operating system to install software? Will you need

special people to install all related software in your computer?

Operator?

Somebody has to operate this software. Does this person need special

training? What will the operator's salary, including overhead, cost?

Environment

Will the new operating system is best fit to work on this software? Will the new

operating system and software tools increase the insurance premiums for the

company?

Once you have collected ALL the positive and negative factors and have

quantified them you can put them together into an accurate cost benefit analysis.

Some people like to total up all the positive factors (benefits), total up all thenegative factors (costs), and find the difference between the two. I prefer to

group the factors together. It makes it easier for you, and for anyone reviewingyour work, to see that you have included all the factors on both sides of the

issues that make up the cost benefit analysis.

SDLC design approach


18/88


19/88

Its hardware and software configuration is not very costly thatmeans

The hardware and software requirement for this software/projectare not very costly.

Level of normalized applied Levels of normalization

Each level of normalization relies on the previous level. Forexample, to conform to Second Normal Form, entities must be in

first Normal Form

Benefits of normalization

The benefits of normalization include:

Searching, sorting, and creating indexes is faster, since tables are narrower,

and more rows fit on a data page?

You usually have more tables.

You can have more clustered indexes (one per table), so you get more

flexibility in tuning queries.

Index searching is often faster, since indexes tend to be narrower and shorter.

More tables allow better use of segments to control physical placement of

data.

You usually have fewer indexes per table, so data modification commandsare faster.

Fewer null values and less redundant data, making your database more

compact.

Triggers execute more quickly if you are not maintaining redundant data.

Data modification anomalies are reduced.

Normalization is conceptually cleaner and easier to maintain and change as

your needs change.

First Normal Form

The rules for First Normal Form are:


20/88

Every column must be atomic. It cannot be decomposed into two or more sub

columns.

You cannot have multivalued columns or repeating groups.

Each row and column position can have only one value.

Second Normal Form

For a table to be in Second Normal Form, every non-key field must depend onthe entire primary key, not on part of a composite primary key. If a database has

only single-field primary keys, it is automatically in Second Normal Form.

Third Normal Form

For a table to be in Third Normal Form, a non-key field cannot depend on

another non-key field.

List of validation applied

Required Field Validator:-

Ensures that the user does not skip an entry.

Compare Validator:-

Compares a user's entry against a constant value, against the value of another

control (using a comparison operator such as less than, equal, or greater than),

or for a specific data type

Range Validator:-

Checks that a user's entry is between specified lower and upper boundaries. You

can check ranges within pairs of numbers, alphabetic characters, and dates.

Regular Expression validator:-


21/88

Checks that the entry matches a pattern defined by a regular expression. This

type of validation enables you to check for predictable sequences of characters,

such as those in e-mail addresses, telephone numbers, postal codes, and so on.

Custom Validator:-

Checks the user's entry using validation logic that you write yourself. This type

of validation enables you to check for values derived at run time.

MINIMUM RECOMMENDED HARDWARE/SOFTWARE REQUIREMENTS:-

Minimum Requirement Recommended


22/88

Requirement

Server Side :- (Minimum)

Processor: -Dual Core Processor with

2.5 GHz

RAM: -2 GB RAM

Hard Disk Drive: -160 GB HDD

Network: -Server must have a

connection to Node through Internet

or LAN Connection.

Client Side :- (Minimum)

Processor: - Pantium-4 Processorwith 2.0 GHz

RAM: - 512 MB RAM

Hard Disk Drive: - 160 GB HDD

Browser: - Internet Explorer 8.0

Server Side :- (Recommended)

Processor: -Core 2 Quad Processor

with 3.2 GHz

RAM: -4 GB RAM

Hard Disk Drive: -512 GB HDD

Network: -Server must have a

connection to Node through Internet

or LAN Connection.

Client Side :- (Recommended)

Processor: - Core 2 Dual Processorwith 2.8 GHz

RAM: - 2 GB RAM

Hard Disk Drive: - 250 GB HDD

Browser: - Internet Explorer 9


23/88

0LEVEL DFD/UML/OOAD

The Data Flow Diagram is a pictorial or graphical representation of the outline

of the system. The Data Flow Diagram covers all the processes, which takes

place during any transaction in the system. The Data Flow are functionality

divided into context level, first level, second level, third level data flow

diagrams.

AuthenticationsUser Login

ADMIN

H.R

Employee

SYMBOLS DESCRIPTION

PROCESS

EXTERNAL ENTITY

DATA FLOW


24/88

What is Data Dictionary?

A data dictionary is a catalog-a repository-of the elements in a system. As

the name suggests, these elements center on data and the way they are

structured to meet user requirements and organization needs. In a data

dictionary you will find a list of all the elements composing the data flowing

through a system. The major elements are data flow, data stores, and processes.

The data dictionary stores details and descriptions of these elements.


25/88

The analysis model encompasses representations of data object, functions

and control. In each representation data objects and/or control items play a role.

Therefore, it is necessary to provide an organized approach for representing the

characteristics of each data and control item. This is accomplished with the data

dictionary.

The data dictionary is organized listing of all data elements that are

pertinent to the system, with precise, rigorous definitions so that both user and

system analyst will have a common understanding of inputs, outputs,

components of stores and intermediate calculations.

If analysts want to know how many characters are in a data item, by what

other names it is referenced in the system, or where it is used in the system, they

should be able to find the answers in a properly developed data dictionary.

The dictionary is developed during data flow analysis and assists the analyst

involved in determining systems requirements. However, its contents are used

during system design as..

TABLE STRUCTURE -- MASTERTABLECOMPANY MASTER

Column Name DATA TYPE CONSTRAINTS DESCRIPTION

C_CODE NUMBER(3) PRIAMRY KEY COMPANY CODE

C_NAME VARCHAR2(100) NOT NULL COMPANY CODE

ADDR VARCHAR2(100) - ADDRESS


26/88

PH NUMBER(12) NOT NULL PHONE NO

FAX NUMBER(12) - FAX

EMAIL VARCHAR2(40) NOT NULL EMAIL

WEB VARCHAR2(100) - WEBSITE

AUTHORIZED PERSON VARCHAR2(25) NOT NULL AUTHORIZED

PERSON

AUTHO_NO VARCHAR2(15) NOT NULL AUTHORIZED

NUMBER

REGIS_NO NOT NULL REGISTRATION NO

PANNO - PAN CARD NO

REMARK VARCHAR2(25) - REMARK

DEPARTMENT MASTER


DEPT_CODE NUMBER(3) PRIMARY KEY DEPARTMENT CODE

C_CODE VARCHAR2() FOREIGN KEY COMPANY CODE

DEPT_NAME VARCHAR2(10) NOT NULL DEPARTMENT NAME

DEPT_HEAD VARCHAR2(25) NOT NULL DEPARTMENT HEAD


27/88


DESIGNATION MASTER


DESIG_CODE NUMBER(3) PRIMARY KEY DESIGNATION CODE

DESIGNATION VARCHAR2(15) NOT NULL DESIGNATION NAME

DEPT_CODE NUMBER() FOREIGN KEY DEPARTMENT CODE

RANK NUMBER(2) NOT NULL RANK


LEAVE TYPE MASTER


LEA_CODE NUMBER(2) NOT NULL LEAVE CODE

LEA_TYPE VARCHAR2(10) NOT NULL LEAVE REASON

OCCURRENCE_YEARLY NUMBER(2) NOT NULL NO OF LEAVE


SHIFT MASTER


SHI_CODE NUMBER(3) PRIMARY KEY SHIFT CODE

SHI_NAME VARCHAR2(10) NOT NULL SHIFT NAME

F_D_HOURS NUMBER(31) NOT NULL NUMBER OF FULL DAY HOURS

H_D_HOURS NUMBER(2) NOT NULL NUMBER OF HALF DAY HOURS


28/88

MEAL_HOURS NUMBER(2) - NUMBER OF MEAL HOURS

SHI_S_TIME NUMBER(5,2) NOT NULL SHIFT START TIME

SHI_E_TIME NUMBER(5,2) NOT NULL SHIFT END TIME

GRA_A_S_START NUMBER() - GRACE AFTER SHIFT START

GRA_B_SHI_END NUMBER() - GRACE BEFORE SHIFT END

GRA_F_MEAL NUMBER() - GRACE FOR MEAL

OT_B_SHI_START NUMBER() NOT NULL OVERTIME BEFORE SHIFT START

OT_A_SHI_END NUMBER() NOT NULL OVERTIME BEFORE SHIFT END


Area master


AREA_CODE NUMBER(3) PRIMARY KEY AREA CODE

AREA_NAME VARCHAR2(20) NOT NULL AREA NAME

CITY_CD NUMBER(3) NOT NULL CITY CODE

REMARKS VARCHAR2(25) - REMARK

City master


CITY_CODE NUMBER(3) PRIMARY KEY CITY CODE

CITY_NAME VARCHAR2(20) NOT NULL CITY NAME

STATE_CODE NUMBER3) NOT NULL STATE COE

REMARKS VARCHAR2(25) - REMARK


29/88

State master


STATE_CODE NUMBER(3) PRIMARY KEY STATE CODE

STATE_NAME VARCHAR2(20) NOT NULL STATE NAME

RRMARK VARCHAR2(20) - -

EMPLOYEE MASTER


EMP_NO NUMBER(5) PRIMARY KEY EMPLOYEE NUMBER

LOGIN ID NUMBER(10) NOT NULL LOGIN ID

PASS Varchar2(20) NOT NULL PASSWORD

SEC_QUES 1 VARCHAR2(50) NOT NULL SECRET QUESTION 1

SEQ_QUES ANS1 VARCHAR2(25) NOT NULL SECRET QUESTION ANSWER 1

STATUS Logical NOT NULL Enable/ disable

F_NAME VARCHAR2(50) NOT NULL NAME OF THE EMPLOYEE

M_NAME VARCHAR2(50) NOT NULL NAME OF THE EMPLOYEES

FATHER

SURNAME Varchar2(50) NOT NULL SURNAME

DOB NUMBER(8) NOT NULL D.O.B OF EMPLOYEE


30/88

UP_PHOTODATA - - UPLOAD PHOTO CONTENT

Native PLACE VARCHAR2(20) NOT NULL EMPLOYEES PLACE

PHONE1 NUMBER(12) NOT NULL CONTECT NO

PHONE2 NUMBER(12) NOT NULL CONTECT NO

ADD1 VARCHAR2(75) NOT NULL ADDRESS

ADD2 VARCHAR2(75) NOT NULL ADDRESS

AREA_CD VARCHAR2(75) NOT NULL AREA CODE

CITUY_CD VARCHAR2(75) NOT NULL CITY CODE

STATE_CD VARCHAR2(75) NOT NULL STATE CODE

E-MAIL VARCHAR2(40) UNIQUE E-MAIL ADDRESS

SEX VARCHAR2(6) NOT NULL GENDER

MARIT_STAT VARCHAR2(9) - MARITAL STATUS

NATIONALITY VARCHAR2(10) NOT NULL NATIONALITY

HIGHEST_EDU_QUALI VARCHAR2(50) NOT NULL EDUCATIONAL QUALIFICATION

N_OF_INSTI/COLL VARCHAR2(50) NOT NULL NAME OF THE INSTITUTE/COLLEGE

Y_O_PASS NUMBER(8) NOT NULL YEAR OF THE PASSING

%_O_GRADE NUMBER(4) NOT NULL PERSENTAGE OR GRADE

IT_SKILLS1 VARCHAR2(50) NOT NULL IT SKILLS

N_O_ORG1 VARCHAR2(25) NOT NULL NAME OF ORGANISATION

DESIGNATION VARCHAR2(7) NOT NULL DESIGNATION

NO_O_Y_O_EXP1 NUMBER(2) NOT NULL NUMBER OF YEAR OF

EXPERIENCE

REAS_F_LEAV1 VARCHAR2(25) - REASON FOR LEAVE

PERIOD FROM1 NUMBER(9) NOT NULL PERIOD FROM

PERIOD TO1 NUMBER(9) NOT NULL PERIOD TO

SAL_DRAWN1 NUMBER(5) - SALARY DRAWN


31/88

HOBBIES1 VARCHAR2(10) - HOBBIES

STRENGTH1 VARCHAR2(10) NOT NULL STRENGTH

WEAKNESSES1 VARCHAR2() - WEAKNESSES

L_DRAWN_SAL(CTC) NUMBER(5) - LAST DRAWN SALARY

EXPECT_SAL(CTC) NUMBER(5) NOT NULL EXPCTED SALARY

REFERENCE VARCHAR2(75) - REFERENCE


EMPLPYEE KNOWN LANGUAGES TABLE

LANGUAGES KNOWN

READ VARCHAR2() Logical

ENGLISH VARCHAR2() Logical

HINDI VARCHAR2() Logical

LOCAL(SPE CITY) VARCHAR2() Logical

WRITE VARCHAR2() Logical



LOCAL(SPE CITY) VARCHAR2() Logical

SPEAK VARCHAR2() Logical


32/88



LOCAL(SPE CITY) VARCHAR2() LogicalREMARK VARCHAR2() -

DEPENDENTS MASTER


EMP_NO NUMBER(3) NOT NULL EMPLOYEE NUMBER

NAME VARCHAR2(50) NOT NULL NAME OF

DEPENDENTS

RELATIONSHIP1 VARCHAR2(10) NOT NULL RELATIONSHIP

PROFESSION1 VARCHAR2(15) NOT NULL PROFESSION

DOB1 NUMBER(8) NOT NULL DATE OF BIRTH

EX-SERVICE MAN MASTER


SERVICE NO NUMBER(15) - SERVICE NO

RANK NUMBER(7) - RANK

ARMS VARCHAR2(15) - ARMS

CORPS VARCHAR2(15) - CORPS

DOJ NUMBER(8) - DATE OF JOINING

D_O_RET NUMBER(8) - DATE OF

RETAIREMENT

REMARK VARCHAR2() - REMARK

LEAVE MASTER


33/88



EMP_NAME VARCHAR2(50) NOT NULL EMPLOYEE NAME

F_DATE NUMBER(8) NOT NULL FROM DATE

T_DATE NUMBER(8) NOT NULL TO DATE

HALF DAY NUMBER(31) NOT NULL HALF DAY

TOTAL DAYS NUMBER(31) NOT NULL TOTAL DAYS

LEAVE TYPE VARCHAR2(5) NOT NULL LEAVE TYPE

REASON VARCHAR2(25) NOT NULL REASON

CARR_FOR NUMBER() NOT NULL CARRY FORWARD

COMPENSAT_DATE NUMBER(8) NOT NULL COMPENSETORY

DATE


SALARY MASTER




BASIC_SAL NUMBER(5) - BASIC SALARY

ALLOW NUMBER(5) -

CONVEYANCE NUMBER(5) - CONVEYANCE

G_SALARY NUMBER(5) - GROSS SALARY

P.F NUMBER(5) - PROVIDENT FUND

PROF.TAX. NUMBER(5) - PROFESSIONAL TAX

E.S.I NUMBER(5) -


34/88

T.D.S NUMBER(5) -

LOAN NUMBER(5) - LOAN

L.I.C NUMBER(5) NOT NULL LIFE INSURANCE


TRANSACTIONTABLE

TABLE NAME: RAW PUNCH DATA TABLE


35/88




PU_C_NO NUMBER(10) NOT NULL PUNCH CARD NUMBER

REAS_C_NO NUMBER(10) NOT NULL REASON CARD NUMBER

DATE_T_IN NUMBER(5,2) NOT NULL DATE TIME IN

DATE_T_OUT NUMBER(5,2) NOT NULL DATE TIME OUT

ARR_SHIFT NUMBER(5,2) NOT NULL ARRIVED SHIFT

ASS_SHIFT NUMBER(5,2) NOT NULL ASSIGNED SHIFT


ACCESS RECORDS TABLE



INOUT_NO NUMBER(5,2) NOT NULL IN & OUT NUMMBER

ACCESS TIME NUMBER(5,2) NOT NULL EMPLOYEE ACCESS

TIME

ACCESS TYPE NUMBER(5,2) NOT NULL EMPLOYEE ACCESS

TYPE


MAC MASTER


36/88


MAC NO NUMBER() NOT NULL MAC NO

MAC NAME VARCHAR2() NOT NULL MAC NAME

CONNECTION MODE VARCHAR2() NOT NULL CONNECTION MODE

COM PORT NUMBER() NOT NULL COM PORT

BRATE VARCHAR2() NOT NULL

IP_ADDRESS VARCHAR2() NOT NULL IP ADDRESS

PORT NO NUMBER() NOT NULL PORT NUMBER


PARAMETER_TABLE


EMP_NO NUMBER(5) PRIMARY KEY EMPLOYEE

NUMBER

PARAM_VALUE NUMBER() PARAMETER VALUE


37/88


EMPLOYEE TRANSACTION TABLE


CARD NO NUMBER(5) PRIMARY KEY CARD NUMBER

TRANS DATE DATE/TIME NOT NULL TRANSACTION DATE

TRANS TIME NUMBER(5,2) NOT NULL TRANSACTION TIME

TRANS MODE TRANSACTION

MODE


TABLE ENROLL NO


EMACHINE NUMBER NUMBER()

ENROLL NUMBER NUMBER()

FINGER NUMER NUMBER()

PRIVILLEGE NUMBER()

PASSWORD NUMBER()

FPDATA OLE OBJECT


USER DATA


EMP_NO NUMBER(5) PRIAMRY KEY EMPLOYEE NUMBER


38/88


EMP_PASS NVARCHAR(25) EMPLOYEE

PASSWORD

EMPCARD EMPLOYEE CARD

EMP_RIGHTS EMPLOYEE RIGHTS

DOORRIGHTS

CREATTIME

EFFECTIVE TIME


USER FINGER TABLE


EMP_NO NUMBER(5)

FP_DATA OLE OBJECT


FULL PUNCHES TABLE





REAS_C_NO NUMBER() - REASON CARD NUMBER

TIME IN NUMBER(5,2) NOT NULL TIME IN

TIME OUT NUMBER(5,2) NOT NULL TIME OUT



39/88

MISSING PUNCHES TABLE




PU_C_NO NUMBER(10) NOT NULL PUNCH CARD

NUMBER

REAS_C_NO NUMBER(10) - REASON CARD

NUMBER

DATE_T_IN NUMBER(5,2) NOT NULL DATE TIME IN

DATE_T_OUT NUMBER(5,2) NOT NULL DATE TIME OUT


LATE COMING TABLE





IN DATE NUMBER(8) NOT NULL IN DATE

SHIFT NUMBER(3) NOT NULL SHIFT

SHIFT_S_TIME NUMBER(5,2) NOT NULL SHIFT START TIME

START_T_W_GRACE NUMBER(5,2) NOT NULL START TIME WITH GRACE

IN TIME NUMBER(5,2) NOT NULL IN TIME

LATE COMING NUMBER(5,2) NOT NULL LATE COMING


EARLY GOING TABLE


40/88





OUT DATE NUMBER(8) NOT NULL OUT DATE

SHIFT NUMBER(3) NOT NULL SHIFT

SHIFT_E_TIME NUMBER(5,2) NOT NULL SHIFT END TIME

E_TIME_W_GRACE NUMBER(5,2) NOT NULL END TIME WITH GRACE

OUT TIME NUMBER(5,2) NOT NULL OUT TIME

EARLY GOING NUMBER(5,2) NOT NULL EARLY GOING


DAY DETAILS TABLE


EMP_NO NUMBER(5) PRIAMARY KEY EMPLOYEE NUMBER



DATE NUMBER(8) NOT NULL DATE

WOR_HOURS NUMBER(3) NOT NULL WORKED HOURS

F_D_HOURS NUMBER(3) NOT NULL FULL DAY HOURS

H_D_HOURS NUMBER(3) NOT NULL HALF DAY HOURS

TOTAL_H NUMBER(3) NOT NULL TOTAL HOURS

OT NUMBER(3) NOT NULL OVER TIME

LOSS NUMBER() NOT NULL LOSS

STATUS VARCHAR2() NOT NULL STATUS



41/88

DAILY DETAILS TABLE






WOR_HOURS NUMBER(3) NOT NULL WORKED HOURS

D_STAT NUMBER() NOT NULL DAY STATUS


OVER TIME TABLE






W_Hours NUMBER(3) NOT NULL WORKED HOURS

OT NUMBER(3) NOT NULL OVER TIME

D_STAT NUMBER() - DAY STATUS


TIME LOSS TABLE





42/88



W_hours NUMBER(3) NOT NULL WORKED HOURS

TIME LOSS NUMBER() NOT NULL TIME LOSS

D_STAT NUMBER() NOT NULL DAY STATUS


MEAL LOSS TABLE


EMP_NO NUMBER PRIMARY KEY EMPLOYEE NUMBER



IN DATE NUMBER(8) NOT NULL IN DATE

MEAL HOURS NUMBER() - MEAL HOURS

CONSU_M_HOURS NUMBER() NOT NULL CONSUMED MEALHOURS

MEAL LOSS NUMBER() - MEAL LOSS


ATTENDENCE REGISTER TABLE


EMP_NO NUMBER(5) PRIMARY KEY EMPLOYEE NAME



OVER TIME TABLE


43/88


EMP_NO NUMBER(5) PRIMARY KEY EMPLOYEE NAME



T_OT NUMBER(3) NOT NULL TOTAL OVER TIME


TIME LOSS TABLE





T_TIME LOSS NUMBER() NOT NULL TOTAL TIME LOSS



44/88

TYPES OF REPORT GENERATION :-

1. Interview latter

2.Offer latter

3.Appointment latter

4.Conformation latter

5.Termination latter

6.Suspension latter

7.Resignation latter

8.Leave register

9.Salary register

10.Salary slip

11.P.F register

12.ESIE register

13.Professional tax register

14.Labor welfare register15.TDS register

16.Bonus register

Home Page


45/88

Home Page Coding


46/88

Pellentesque tincidunt

Lorem ipsum dolor sit amet, consectetuerdipiscing elit, sed diam nonummy nibh euimod tinc

idunt ut laoreet doloreagna aliquam erat volutpat Ut wisi enimveniam, quis nostruexerci tation ullamcorper suscipit lobortis nisl.
read more
Aenean mauris dui

Lorem ipsum dolor sit amet, consectetuerd

ipiscing elit, sed diam nonummy nibh euimod tincidunt ut laoreet doloreagna aliquam erat volutpat Ut wisi enimveniam, quis nostruexerci tation ullamcorper suscipit lobortis nisl.

read more Donec eget mauris

Lorem ipsum dolor sit amet, consectetuerdipiscing elit, sed diam nonummy nibh euimod tincidunt ut laoreet doloreagna aliquam erat volutpat Ut wisi enimveniam, quis nostru

exerci tation ullamcorper suscipit lobortis nisl.
read more
Mauris et turpis sem

Nunc diam ante, interdum etblandit eget; vehicula at ligula.

Ut wisi enimveniam, quis nostru exerci tation

ullamcorper Duis autem vel eum iriure ulputate velit iusto odio dignissim qui blanditpraesent luptatum zzril Morbi mattis, est diam iaculis dolor, dolor sit amet,

consectetur adipiscing elit.

Praesent nec elit elementum diam

aliquamAenean nonummy hendrerit

maurisPraesent at odio sit amet nisl

consequat tincidunt et sit amet

Nulla dui. Fusce feugiat malesuadaodio. Morbi nunc odio

Aenean nonummy hendreritmauris

Donec ultricies congue posuere donec

sed


47/88

Pellentesque a felis

11.02.2013

Ut wisi enimveniam, quis nostru exerci amet justo

felis. Fusce sagittis est vitae erat molestie eu elem entum purus ulla maper duiselementum.

02.03.2013

Fusce sagittis est vitae erat molestie eu elementum purus ullamaper duis elemen tum, massa nec semper blandit, sem leo olutpat nibh;eget.


48/88

Login Page

Login coding

.auto-style1{width: 200px;

height: 134px;}

.auto-style5{text-align: center;

}


49/88

Forgot Your Password ?


50/88

Registration Form

Registration form coding

Employee Registration

>Personal Details

>Educational

Details

>Family

Details


51/88

Personal Details

Personal details Coding

Personal Details

First Name


52/88

Area Code

-- Select

Area Code --390021

390022390023390024

390025390026

Midlle Name

City Code

-- Enter City Code --39000

39002212345

12345653242

53452

Surname

State Code


53/88

-- Enter State Code --

65476765876

87686556587999

787667

Date of Birth

E-Mail Address

Gender

MaleFemale

Phone Number


54/88

Marital Status

Address

Nationality

Hobbies

Strength

Weakness


55/88


56/88

Designation

Number of Year of Experience

Reason For Leave

Period From

Period To


57/88

Salary Drawn

Remark


58/88


59/88

Educational details

Educational Details coding

Educational Details

Highest Educational QualificationName of College/Institute

Year of PassingPercentage or GradeIT Skills


60/88


61/88

PreviousPage

Next Page


62/88

Company Details

Company details coding

#Reset1{height: 26px;width: 69px;

}

Company Details

Company Code


63/88

Website

Company Name

Authorized Person

Address

Authorized Number

Phone

Registraton Number


64/88

Fax

Pan Card Number

E-Mail

Remark


65/88


66/88

Department Master

Department Master

Department Code

Department Head


67/88

Company Code

Department Name

Remark


68/88


69/88

Designation Master

.auto-style1{

height: 60px;}

.auto-style2{height: 60px;

text-align: center;}

Designation Master

Designation Code


70/88

Department Code

Designation

Rank

Remark


71/88


72/88

Ex-Service Man Master

Ex-Serviceman Details

Service Number

Date of Joining


73/88

Rank

Remark

Corps

Date of Joining


74/88

Leave Details

#TextAreaREMARK{

height: 86px;width: 242px;

}


75/88

Leave Details

Employee Number

Leave Type

-- Select Your Leave --S.LP.L

C.L

Employee Name

Reason

From Date

Carry Forward


76/88

To Date

Compansatory Date

Half Days

Remark

Total Days


77/88


78/88

Leave Type Master

#TextArea1{height: 65px;

width: 213px;}

Leave Type Details

Leave Code

-- Select Your Leave Code --010203

04


79/88

Occurance Yearly

Leave Type

--Select Your Leave Type--S.LP.L

C.L

Remark


80/88

Salary Master

.auto-style1{

width: 358px;text-align: center;

}

.auto-style2{text-align: center;width: 293px;

}.auto-style3{

width: 358px;

overflow: hidden;text-align: center;

}.auto-style4{

width: 92%;overflow: hidden;

text-align: center;


81/88

}

.auto-style5{text-align: center;

width: 100%;}.auto-style7{

width: 92%;text-align: center;

}

Salary Details

Employee Number

Provident Fund

Professional Tax

Employee Name

E.S.I


82/88

Basic Salary

T.D.S

Allowance

Loan

Conveyance

L.I.C


83/88

GrossSalary

Remark


84/88


85/88

Forgot Password

Forgot Password coding

UserName

What is your Birth Date ?

What is your born place ?


86/88


87/88

Methodology used for testing

Black Box Testing

The technique of testing without having any knowledge of the interior workings of the

application is Black Box testing. The tester is oblivious to the system architecture and doesnot have access to the source code. Typically, when performing a black box test, a tester will

interact with the system's user interface by providing inputs and examining outputs without

knowing how and where the inputs are worked upon.

White Box Testing

White box testing is the detailed investigation of internal logic and structure of the code.

White box testing is also called glass testing or open box testing. In order to perform white

box testing on an application, the tester needs to possess knowledge of the internal working

of the code.

The tester needs to have a look inside the source code and find out which unit/chunk of the

code is behaving inappropriately.

Grey Box Testing

Grey Box testing is a technique to test the application with limited knowledge of the internal

workings of an application. In software testing, the term the more you know the better carries

a lot of weight when testing an application.

Mastering the domain of a system always gives the tester an edge over someone with limited

domain knowledge. Unlike black box testing, where the tester only tests the application's user

interface, in grey box testing, the tester has access to design documents and the database.Having this knowledge, the tester is able to better prepare test data and test scenarios when

making the test plan.

Limitation of system

Future Scope

2) Conclusion

The Employee Management Systemhas been developed by me through

applying my knowledge gained in class room, referring to certain books,

browsing some sites and through the help of external and internal facultiesand using my own knowledge related to the subject itself.

No project can be teamed as perfect in real sense and there alwaysremains scope for further improvement and so that helps to develop a new

version. I am always eager to know some new points and validation related

to the projects and which give me more knowledge and helps me to create

new version.

I would like to thank the project guide and Organization staffs that

extended all their support and helped me complete this project successfully.


88/88

Bibliography

www.google.com

www.yahoo.com

www.w3cschool.com

www.stackoverflow.com

www.wikipedia.com
http://www.google.com/http://www.google.com/http://www.yahoo.com/http://www.yahoo.com/http://www.w3cschool.com/http://www.w3cschool.com/http://www.stackoverflow.com/http://www.stackoverflow.com/http://www.wikipedia.com/http://www.wikipedia.com/http://www.wikipedia.com/http://www.stackoverflow.com/http://www.w3cschool.com/http://www.yahoo.com/http://www.google.com/

documentation of employee management system

Documents