Ambar Capstone

8/3/2019 Ambar Capstone

1/39

1 |

CAPSTONE PROJECT REPORT

SASALLAARRYY MMAANANAGEGEMEMENNTT SYSYSTSTEEMM

IInternternnaall FFaaccuullttyy AAddvvisisoor:r: SubSubmmiittedtted BByy::

MMss.. JJaasspprereeett kkaauurr AAmmbbararDDeevvggoonn

LLececttuurerrer RegRegNoNo:: 1010880101226688

LLovoveellyy PrProofefessssioionnaall UUnniivveerrssiittyy BB.T.Tecechh-C-C..SS.E.E((151500))

SSeeccttioionn:: KK2828EE22BB4499


2/39

2 |

CERTIFICAT E

This is to certify that Ambar Devgon bearing Registration no. 10801268 has

completed my capstone project titled, Salary Managment System under my guidance

and supervision. To the best of my knowledge, the present work is the result of her

original investigation and study. No part of the work has ever been submitted for any

other degree at any University. The project is fit for submission and the partial

fulfillment of the conditions for the award of .........................

Signature and Name of the Research Supervisor

Designation

School

Lovely Professional University

Phagwara, Punjab.

Date :


3/39

3 |

DDEECCLLARAARATTIIONON

II hhereerebbyy ddececllaarree tthhaatt tthehe pprroojjecectt woworrkk eenntitltitleedd SSAALLARYARY MMANANAAGGEEMMEENNTT SSYYSTESTEMM iiss

aann aauutthheenntiticc recrecoorrdd ofof ourour ownown woworrkk carrcarriieedd outout aatt

LLOOVVELELYY PPRROOFFESSESSIIOONALNAL UNIVUNIVEERIRISTSTYY aass rreeququiireremmeentnt ofof IIndusndusttrryy

IInntteerrnshnshiipp PPrroojjecectt fforor tthehe aawwarardd ooff ddeeggrereee ofof BB..TTecechh--CCSESE((150150)),, LLovoveellyy PPrrooffeessssiioonnalal

UUninivvererssiittyy PPhhagagwwaarraa undundeerr tthehe gguuiiddaannccee ofof MMs.s. JasJasppreereett KKaauurr ((LLeeccttuurrerer,, LLoovveellyy

PPrroofefessssiiononaall UnUniivvererssiittyy)),, dudurriinngg JJuullyy 20112011 ttoo DDeececemmbbeerr

2011.2011.

SiSiggnnaattuurree ooffStStududeentnt

NNaammee:: AAmmbbaarrDDeevvggonon

DDaattee::________________________ RReeggiissttraratitiononNo:No: 1080126810801268


4/39

4 |

ACACKKNNOWLEOWLEDDGGEEMMEENNTT

It is our pleasure to find myself penning down these lines to express sincere thanks to all my

coordinators to give me this opportunity of preparing this project, to enhance my professional

practice.

we express our deep sense of gratitude to our project officer Ms. Jaspreet kaur to give

us knowledge about the topic and concept related to this particular project. Without his

guidance I cannot imagine to complete my project on time.

our deepest gratitude to all our coordinators, teachers and group mates for always boosting

our moral and providing the encouraging environment. In the last, we want to thank our

parents, without whom nothing was possible.


5/39

5 |

TABLE OF CONTENTS

CONTENTS

1. Organization Overview

2. Profile of the Problem

3. Existing System

Introduction

Existing Software

DFD for present system

Whats new in the system to be developed

4. Problem Analysis

Product definition

Feasibility Analysis

Project Plan

5. Software Requirement Analysis

Introduction

General Description

Specific Requirements

6. Design

System Design

Design Notations

Detailed Design

Flowcharts

Pseudo code


6/39

6 |

CCOOMPANMPANYY PRPROOFFIILELE

HHMMMM CCOOACACHESHES LTDLTD

EEsstatabblilishsheded inin 19199999--20002000..

CuCurrrreennttpprroduoductictioonn cacappaciacittyy

HeaHeavvyy HH aanndd BoBoxx BBeeaammss-- 15015000 TTononsspperermmononthth

GalGalvvaannizedized StStrruuccttuurreess-- 12012000 TTononsspperermmononthth

IISOSO 90019001::20020000 cecerrtitiffiedied ccoommppaannyy

AAuuttoommatedated HHbbeaeamm ffaabbrricatiicatioonn aanndd ggalalvvaanniziizinngg lilinneses

AAmmbbalaala FactFactoorryy

EEsstatabblilishsheded inin tthhee yyearear19991999--20020000

SSpprreadead ovovereraa 6300630000 squsquaarree mmeteteerrss ccoommpplexlex

BuBuiltilt uupp aarreaea ooff2900290000 sqsq..mm

TTootaltal cacappaciacittyy ooff27027000 MTMTpperermmononthth

IInn houshousee ffacilitiesacilities ffoorrmmaanunuffactactuurriinnggjijigsgs,, ffiixxttuurreses aanndd ttoooolilinngg


7/39

7 |

OBOBJJEECCTTIIVVEE

In todays computerized environment, payroll system has also developed itself into

automated software that performs every action needed by the payroll process. It helps incalculating the payable amounts and deductions very easily. It also helps in generating the

pay slips in lesser time.

The objective to develop the project is to make the Salary Management system simple, easy

and increase the productivity of the Managers in taking decisions because all the information

is available in the organized form.

Our Salary Management System is a very simple, flexible and user-friendly Salary

Management software that takes care of all your requirements relating to accounting and

management of employees' Payroll. our Payroll stores complete records of the employees,

generates Payslips and Attendance Register, Computes all allowances and deductions and

generates all Statutory and MIS reports.

Why Payroll Software is needed?

The task of payroll becomes complicated in today's industries due to multiple statutory

requirements, MIS requirements, calculations based on slabs and formulas and other HR

policies.

To overcome the situation, the user expects a software that is easy to use, comprehensive in

domain, ensures statutory compliance and is flexible with the requirements of the user .

Our Payroll offers very high flexibility in defining various allowances, deductions, leave

rules etc. for the employees and all formula for P.F, Vol. P.F., Tax, Income Tax etc. are

definable and changeable at User's end.

This software provides a user-friendly interface for the user and it reduces the data

redundancy. Centralized information is available which can be accessed by number of users.

The other objective of software project planning is to provide a framework that enables the

manager to make reasonable estimates of resources and schedule.

These estimates are made within a limited time at the beginning of a software project and

should be updated regularly as the project progresses.


8/39

8 |

There are some other objectives to develop this system. The most important objective is:

1) Ca p a bili ty :

Business activities are influenced by company or organizations ability to process

information quickly and efficiently. The Salary Management System adds capability

in the following ways:

1 Improved Processing speed

2 The inherent speed, with which computers process information is one reason why

organization seeks the development of the system projects.

3 Faster Retrieval of information

4 Locating and retrieving information from storage. The ability in conducting complex

searches.

2) Con trol :

3) Cos t :

Greater accuracy and consistency.

Carrying out computing steps, including arithmetic, correctly and

consistently.

Better Security

Safeguarding sensitive and important information in form that is accessible

only to authorized person.

M o ni t or Cos t : Tracking the performance of employees and overhead is

essential to determine whether a firm is performing in line with

expectations with in budget.

R e du c e Cos t : An efficient payroll management is of extreme importance

as far as providing service and control is concerned.

Our payroll management systems help you can

Save time on working with payroll.

Manage payroll productivity.

Increase serviceability.

Keep multiple checks on payrolls.

Manage multiple ledgers through multi-ledger interfaces.

Generate benefit statements.

Record employee history.


9/39

9 |

IINNTTRROODUCDUCTTIIONON

A b o u t S a l a r y M a n ag eme n t Sys t e m :

Payroll is defined as a method of administrating employees salaries in the organizations. The

process consists of calculation of salaries and tax deductions of the employees, administrating

the retirement benefits and disbursements of salaries to employees. It can also be called as an

accounts activity which undertakes the salary administration of employees in the

organization.

Administrating the employees salaries is not an easy task, the HR and accounts department

work together to calculate and disburse the salary to the employees. Thus, payroll

management can be further subdivided into two sub processes, i.e. Payroll accounting and

payroll administration.

Payroll A ccoun tin g

Payroll accounting involves calculations of employees salaries and tax deductions. It alsoundertakes the activities such as preparation of tax returns, maintaining the payroll records,

etc.

Payroll Ad mini strati on

Payroll Administration involves managerial activities such as maintaining employees

records, referring employment laws. Here, the HR comes into picture which maintains the

daily record if employees attendance.


10/39

10 |

Employee

Info

Maintain Record

Employee

Attend.EmpId,

Name,Ba

sic

Numberof

workingDays

Record

Transfer toAccount

Calculatio

n Of

GS+BS+

Allowance

s

Calculation Of

Calculatio

n Of

deduction

,tax &other if

an

y


11/39

P ay r o ll Process


12/39

11 |

EEXXIISTSTIINNGG SSYYSSTETEMM

Calculation of gross salaries and deductible amounts is a tedious task which involves risk.

Some of the organizations use the traditional manual method of payroll processing and some

go for the advanced payroll processing software. An organization opts for any of the

following payroll processing methods available:

Manual S ystem:

Manual payroll system is the traditional payroll system which involves pen and ink, adding

machine, spreadsheet, etc instead of computers, software and other computerized aids. The

process was very popular when there were no computerized means for payroll processing.

A cc o un t a n t

Accountant is a professional having a degree/diploma course in finance/accountancy. He/she

is responsible for all the activities related to payroll accounting. He/she has the sound

knowledge of accounting principles and globally accepted standards.

The process adds costs to the organization. It involves paying someone who is responsible for

calculating the salaries of others. The financial control regarding salary goes in the hand of

accountant.

Payroll S of tw are

In todays computerized environment, payroll system has also developed itself into

automated software that performs every action needed by the payroll process. It helps in

calculating the payable amounts and deductions very easily. It also helps in generating the

pay slips in lesser time. Automated calculations result in no errors. Data is validated

automatically by the software. It needs professionals to make use of the software for its

efficient working.


13/39

12 |

Payroll

Softwa

re

Manual

System

Payroll

Processing

Accountant

Payroll

Outsourc

ing

Va rio us Pa yrol l Process

There are some additional features of Salary Management Software:

Cost-Effective

Time Saving

Less Legal Adherence

Error Free

Profit Generation

Qualitative Result


14/39

13 |

PROBLEM/ NEED

PRPROBLEMOBLEM ANAANALLYYSSIISS

Problem Analysis is a management technique, which helps in designing a new system or

improving an existing system. System Analysis is the process of gathering and interpreting

facts, diagnosing problems (if any), using information to recommend improvements to the

system. This section of the document lists the drawbacks for Salary Management system that

is currently under use. The major problems are:

Slow process

Requires more time and effort

Communication gaps between different members related to a project

Manual ProcessSecurity Issues

More prone to risks and wrong Evaluations

Data inconsistent

Conflict in timings

Difficulty in resource management

Event reporting manually creates chaos

Insecure data backup

Management of more than one event becomes difficult

FE ASIB IL IT Y ST UDY

Fea s i b ili t y St u d y :

The feasibility of a project is being analyzed within some frame work. The most important

factor is feasible and desirable then it include in the schedule of the management so that

approval can be taken from the same. In the conduct of the feasibility study, the analysis

considers seven distinct, but inter-related types of feasibility. They are:

1. Technical Feasibility

2. Economical Feasibility

3. Operational Feasibility

4. Social Feasibility

5. Management Feasibility

6. Legal Feasibility

7. Time Feasibility


15/39

14 |

The assessment of the system has the following facts:

Technical Feas ibili ty :

Technical Analysis begins with the assessment of the technical viability of the

proposed system. We have to mention what technologies are required to accomplish

system function and performance .We have to also study how will these technology

issues affect cost .

The existing technology seems sufficient to run the new system. The data holding

facility is also seems sufficient because we are using Mysql and it can handle large

volume of data , hence in near future if the number of employees increases it can

handle its very easily .

Operatio na l Fea sibi li ty:

The management and the users are normally the same members so there is no problem

of conflict between the management & users.

Fi na ncial a nd eco nomi cal:

Among the most important information contained in feasibility study is cost benefit

Analysis an assessment of the economic justification for a computer based system

project. Cost benefit Analysis calculates approximate costs for project development

and weighs them against tangible and intangible benefits.


16/39

15 |

SOFTWARE REQUI REMENT SPECI FI CATI ONS

INT RO DUCT IO N

PURPOSE

The purpose of the proposed system is to provide efficient information system for

management, department and employees.

The main objective to develop the project is to make the information part simple and to

provide user friendly access of this program to all the staff members of the organization so

that they can locate and reply the inquiries concerned to them.

Salary Management System has some levels of specialization which helps in the calculating

the exact salary of the employees of the organization. Salary Management System involves:

Filing up the information about the employees from the HR department

Not merely getting the information but calculating the salary with the tax deductions

also.

As soon as the salary is going to calculate, it automatically fetches all the leaves taken

by the employee and deducts the salary according to the information about the

presence and absence of employee in the organization.

HR department can review the reports of the employee according to various

categories.

Efficient way to ensure that a calculated salary is correctly

calculated.


17/39

16 |

SCOPE

The software prepared for our company, it can be implemented in any Organization with a

few minor changes. The software finds good scope in any organization having HR

department. Talking to the administrator and the employee who were dealing with the HR

department, we came to know that the manual system was not up to the mark due to the

cumbersome data entry and ample of calculations on the basis of which reports are generated.

As it keeps all the information regarding the attendance of the employees and the basic salary

and also about the various allowances given to the employee so it also becomes for the HR

department and Accounts department in any organization. It also deducts the taxes according

to the various tax slabs.

So it has a great scope in any type of organization.

GENERAL DESCRI PTI ON

Pro duct functio n and ov ervi ew :

Data En try S ecti on

User section: This section is developed using .Net as front- end and MYSQL as back-end.

Only valid user enters to this section by providing login name and password to the system.

Ad mi n i s t ra t or s ec ti on : This section can be accessed by providing administrator password. In

this section the administrator can authorize persons to data entry. The administrator can add

or edit the master table information and payroll information.

Dat a Upd atio n Section

Us e r s ec ti on: This section is developed using Asp.Net as front-end and MYSQL as back-end.

Only valid user can update employee profile & candidates information.

Ad mi n i s t ra t or s ec ti on : - This section can be accessed by providing administrator & user

password. In this section the administrator can do data updation. The administrator can edit

the master table information and payroll information.


18/39

17 |

Da ta Del etio n Section

U s er s ec t io n : Only valid user can delete records of employees & candidates by providing

login name and password to the system.

A d m i n is t r a t o r s ec t io n: This section can be accessed by providing user password. In this

section the administrator can authorize persons to data deletion. The administrator can delete

the master table information and payroll information.

Da ta Pro ces si ng Secti on:

This section can be accessed by providing administrator password. In this section the only

administrator can process the payroll related information.

Repo rt Sectio n:

This section is developed using Microsoft Report Viewer as a report generation tool and

MYSQL as back-end

USERS CHARAC TERI STI CS

Administrator

An Administrator is a user who can create or delete users and grant or revoke set of

privileges from the other users. He can access the master database. He can update,

delete, and modify the data in the database. He can review all the reports.

Employee

An employee can only feed the entries in the database according to the information

provided to him. He can review his own salary slip with the full details.

CO NST RAINT S

Limited to HTTP

No Backup Solutions

Supports the content in English only


19/39

18 |

ASS UMPT IO NS

Administrator is created already in the system.

Roles and tasks are predefined.

SYSTEM REQUI REMENTS

Technical Requirements:

S. No. Name Description

1. Microsoft Visual Studio

2008

An advanced integrated development environment by

Microsoft for web application building.

2. ASP.NET on .NET

framework 3.5

Active Server Pages built on .NET 3.5 framework using C#

provided by Microsoft using Visual Studio 2008 in support

with AJAX ToolKit.

3. Microsoft SQL Server 2008 Database application for effectively managing our database.

Supports Express Manager (XM) program, native XML and

supporting CLR integration.

4. HTML Hyper Text Mark-up Language is the predominant mark-up

language. It provides a means to describe the structure of

text-based information in a document and to supplement

that text with interactive forms and styling using Cascading

Style Sheets(css). Based on w3school standards.

5. XML Extensive Markup Language is a flexible way to create

common information formats and share both the format and

the data on the World Wide Web. Responsible for Data

Transfer between Server and Client.

6. JavaScript Netscape-developed object scripting language used in

millions of web pages and server applications worldwide. Itis a dynamic scripting language supporting prototype based

object.

7. Ajax Asynchronous JavaScript And XML. It is a handy

combination of JavaScript And XML providing

functionality partial postback to Server for faster

processing.

8. Cascading Style Sheets

(CSS)

Used to apply designs


20/39

19 |

9. JQuery It is light-weight assembly of JavaScript with functionality

of write less and do more. It helps create animation

effects with much ease than a flash files.

10. C# An object-oriented programming language designed for the

Common Language Infrastructure from Microsoft that aimsto combine the computing power of C++ with the

programming ease of Visual Basic.

Hardware Requirements:

TYPE SPECIFICATIONS

Processor Pentium IV or Above

Speed 266 MHz or Above (Used 1.8 GHz)

RAM 1 GB

Hard Disk 5 GB or More (80 GB)

Monitor VGA Color

Input Device Mouse & Keyboard

Software Requirements:

Mozilla Firefox 5.0+

Internet Explorer 8+

Screen Resolution

1024 pixels x 768 pixels


21/39

20 |

FUNCTI ONAL & NON FUNCTI ONA L REQUI REMENTS

Initial Functional Requirements:

1 There should be no manual entry in the database table by directly accessing the tables

i.e. there should be security at database server.

2 Only valid user can Input record and only administrator can perform any operation on

master database and payroll module

Initial Non Functional Requirements: Secure access to authorized content 24 X 7 availability Better component design to get better performance at peak time through simplicityand transparency.

Internet connection must be established. The website will be compatible withNetscape and Internet Explorer web browsers.


22/39

21 |

DESI GN

SYSTEM DESI GN

WORK FLOW DI AGRAMS

DAT A FLO W DIA GR AM

The DFDs represents the flow of the data among the different processes, entities and records.

There are 0-level (context diagram) and 1-level DFDs. The 0-level DFD represents the

overall entities participating in the system excluding the detailed functionality of the system.

Whereas 1-Level DFD represents the module wise detailed functionality of the system.

Symbols for DFD are:


23/39

22 |

Use Cases:

Admin login-


24/39

23 |

Accountant login:


25/39

24 |

ADDITION OF EMPLOYEE:


26/39

25 |

DELETION OF EMPLOYEE:


27/39

26 |

0-Level Data Flow Diagram

SalaryInfo

Salary

Management

System

Salary Slip

1-Level Data Flow Diagram


28/39

27 |

RRececoorrdd MMooddiiffiiccaattiionon


29/39

28 |

AAddmmiissssiionon ofofaa nneeww eemmplployoyeeee::


30/39

29 |

EENNTTIITYTY RRELELAATTIIOONNSHSHIIPP DDIIAAGGRARAMM

An entity-relationship (ER) diagram is a specialized graphic that illustrates the relationships

between entities in a database.

Co mpo nents us ed in the creatio n of a n ERD

Entity A person, place or thing about which we want to collect and store multiple instances

of data. It has a name, which is a noun, and attributes which describe the data we are

interested in storing. It also has an identifier, which uniquely identifies one instance of an

entity.

Relationship Illustrates an association between two entities. It has a name which is a verb.

It also has cardinality and modality.

Cardinality and Modality are the indicators of the business rules around a relationship.

Cardinality refers to the maximum number of times an instance in one entity can be

associated with instances in the related entity. Modality refers to the minimum number of

times an instance in one entity can be associated with an instance in the related entity.

Cardinality can be 1 or Many and the symbol is placed on the outside ends of the relationship

line, closest to the entity, Modality can be 1 or 0 and the symbol is placed on the inside, next

to the cardinality symbol. For a cardinality of 1 a straight line is drawn. For a cardinality ofMany a foot with three toes is drawn. For a modality of 1 a straight line is drawn. For a

modality of 0 a circle is drawn.


31/39

30 |

EENNTTIITYTY RRELELAATTIIOONNSHSHIIPP DDIIAAGGRARAMM

Start slab

End slab

HRA/CCAnit

HRA

Contain

SalarySlip

genera

te

Pay slab

Month

Sal_init send

Salary Cal

Net Sal Year

No

of

leave

s

has conta

in Deduction

Leave

Master

AllDesc

All/Ded Mst

Ded desc

Leavetype

sen

d

Fro

m

dat

e Emp

i d

Todate

Leave Trans


32/39

Current

LeaveRemainin-

gLeave


33/39

31 |

DDESESIIGGNN NNOTOTAATTIIOONN

Administrator module

1. Login

Input : ID, Password.

Process : Click on the login link. If administrator enters ID and password correct it goes to

the admin services otherwise displays the same page with an error message.

Output : Displays the admin services page.

2. Add new employee

Input : Name, Id, designation, Date of joining.

Process : A new employee can be added into the system and admin can update his details.

Output : The employee can be credited salary based upon his details.

3. Salary details

Input : Id, designation, basic salary, PF, DA, HRA.

Process : The admin can update his salary details

Output : Employee salary details will be updated to the database.

4. Loan details

Input : Id, Loan number, EMI, Repaid amount, Balance amount.

Process : Administrator can update a particular employees loan details.

Output : Employee Loan details will be updated to the database.

5. Leave details

Input : Id, Type of leave, Number of Leaves.

Process : Administrator updates the leave details.

Output : Employee Leave details will be updated to the database.


34/39

32 |

6. Tax details

Input : Id, Basic salary, Tax percentage, income tax.

Process : The tax details of an employee can be updated by the administrator.

Output : Employee Tax details will be updated to the database.

7. Salary slip

Input : Id, Basic salary, Designation, Net pay.

Process : Based on the leave, loan , tax details the slip will be generated

Output : Salary slip will be generated.

Accountant modules

1. Login

Input : ID, Password.

Process : Click on the login link. If Accountant enters ID and password correct it goes to the

other page otherwise displays the same page with an error message.

Output : Displays the Information to be viewed by an employee/Accountant.

2. Update profile

Input : Id, Name, Designation, Email-id, Mobile number, Address, key skills, qualification

Process : The Accountant can update his profile if any modifications occur in his details

Output : The details of an employee can be updated

3. View earnings

Input : ID, Month, Year.

Process : The earnings can be displayed by this test case

Output : The total earnings of an employee for the specified month and year can be viewed


35/39

33 |

4. View deductions

Input : Id, Month, Year

Process : The deductions can be known by using this test case

Output : The total deductions of an employee for the specified month and year can beviewed

5. View salary slip

Input : Id, Month, Year.

Process : The employee can view the salary slip.

Output : The salary slip of an employee for the specified month and year can be viewed.

FFLOWLOW CCHHARARTSTS

A flowchart is a common type of diagram that represents an algorithm or process showing

the steps as boxes of various kinds, and their order by connecting these with arrows.

Flowcharts are used in analyzing, designing, documenting or managing a process or program

in various fields.

Symbols used in flowcharts:


36/39

34 |

FOR ADMIN:


37/39

35 |

FOR ACCOUNTANT:


38/39

36 |


39/39

37 |

Pseudo code for admin

. The admin enters his user id and password in the login section and clicks on login

button.

The system validates the login credentials entered by the admin against the

information stored in Database.

If the credentials are correct, the system displays the admin home page.

If the credentials do not match, the system returns a failure message on the home

page of system.

The admin can perform the following functions once he logs on to the system, he can

update leave record of the employee, add new employee to the database, update the

salary details of the employee, update tax details, generate slip record.

Once the required actions are performed by the admin he logs out the system.

Pseudo code for accountant

. The accountant enters his user id and password in the login section and clicks on

login button.

The system validates the login credentials entered by the accountant against the

information stored in Database.

If the credentials are correct, the system displays the accountant home page.

If the credentials do not match, the system returns a failure message on the home

page of system

once the accountant logs on to the system, he can perform the following functions

update employee profile, perform deductions and view salary slip of the employee.

Once the accountant is done with the required functions he can log out the system.

Ambar Capstone

Documents

Transcript of Ambar Capstone