Payroll Management System

Payroll Management System for Rehabilitation Plantations Ltd. Punalur

2011

CHAPTER 1 INTRODUCTION

Mar Thoma College of Science and Technology, yur.

1


2011

INTRODUCTION Human Resource is the most fundamental resource for any organi!ation. "t is

res#onsible for each and e$ery decision ta%en, each and e$ery &or% done and each and e$ery result. 'm#loyees should be managed #ro#erly and moti$ated by #ro$iding best remuneration and com#ensation as #er the industry standards. Payroll #rocessing is the bac% bone of an organi!ation(s organi!ation(s em#loyee o#erational and satisfaction focus. Payroll is defined as a method of administration of em#loyees( salaries, &ages, bonuses, net #ay and a nd deductions. "t consist of the em#loyee "), em#loyee name, date of *oining, daily attendance records, basic salary, allo&ances, o$ertime #ay, bonus, commissions, incenti$es #ay for holidays $acations and sic%ness, $alue of meals and lodging etc. There are some deductions such as P+, taes, loans installments or ad$ances ta%en by em#loyee. The #ayroll #rocess consists of calculation of salaries and ta deductions of the em#loy em#loyees, ees, admini administra stratin ting g the retirem retirement ent benefit benefitss and disbur disbursem sement entss of salarie salariess to em#loyees. "t can also be called as an accounts acti$ity &hich underta%es the salary administration of em#loyees in the organi!ation. dministrating the em#loyees( salary is not a sim#le tas%, the -R and ccounts de#artment &or% together to calculate and gi$e out the salary to the em#loyees. The term #ayroll encom#asses e$ery em#loyee of a com#any &ho recei$es a regular &age or other com#ensation. Some em#loyees may be getting a steady salary &hile others are getting getting for hours &or%ed or the number number of items #roduced. ll ll of these differe different nt #aymen #aymentt method methodss are calcul calculate ated d by a #ayrol #ayrolll s#ecial s#ecialist ist and the a##ro# a##ro#riat riatee #aycheues are issued.

PAYROLL PAYROLL MANAGEMENT

Payrol Payrolll mana managem gement ent is the the admi admini nistr strat atio ion n of the the finan financi cial al reco record rdss of the the em#loyees( salaries, &ages, bonuses, net #ay and deductions. Payroll management can be uite a challenge for the ne& business o&ner. Many business o&ners use outside #ayroll ser$ices. These com#anies guarantee com#liance &ith all the a##licable la&s. This %ee#s the business o&ner out of trouble &ith the la& and sa$es time that can be de$oted de$oted to something something else in the business. business. "f the business choose to do o&n #ayroll, it is recommended that to de$elo# an automated


2


2011

INTRODUCTION Human Resource is the most fundamental resource for any organi!ation. "t is

res#onsible for each and e$ery decision ta%en, each and e$ery &or% done and each and e$ery result. 'm#loyees should be managed #ro#erly and moti$ated by #ro$iding best remuneration and com#ensation as #er the industry standards. Payroll #rocessing is the bac% bone of an organi!ation(s organi!ation(s em#loyee o#erational and satisfaction focus. Payroll is defined as a method of administration of em#loyees( salaries, &ages, bonuses, net #ay and a nd deductions. "t consist of the em#loyee "), em#loyee name, date of *oining, daily attendance records, basic salary, allo&ances, o$ertime #ay, bonus, commissions, incenti$es #ay for holidays $acations and sic%ness, $alue of meals and lodging etc. There are some deductions such as P+, taes, loans installments or ad$ances ta%en by em#loyee. The #ayroll #rocess consists of calculation of salaries and ta deductions of the em#loy em#loyees, ees, admini administra stratin ting g the retirem retirement ent benefit benefitss and disbur disbursem sement entss of salarie salariess to em#loyees. "t can also be called as an accounts acti$ity &hich underta%es the salary administration of em#loyees in the organi!ation. dministrating the em#loyees( salary is not a sim#le tas%, the -R and ccounts de#artment &or% together to calculate and gi$e out the salary to the em#loyees. The term #ayroll encom#asses e$ery em#loyee of a com#any &ho recei$es a regular &age or other com#ensation. Some em#loyees may be getting a steady salary &hile others are getting getting for hours &or%ed or the number number of items #roduced. ll ll of these differe different nt #aymen #aymentt method methodss are calcul calculate ated d by a #ayrol #ayrolll s#ecial s#ecialist ist and the a##ro# a##ro#riat riatee #aycheues are issued.

PAYROLL PAYROLL MANAGEMENT

Payrol Payrolll mana managem gement ent is the the admi admini nistr strat atio ion n of the the finan financi cial al reco record rdss of the the em#loyees( salaries, &ages, bonuses, net #ay and deductions. Payroll management can be uite a challenge for the ne& business o&ner. Many business o&ners use outside #ayroll ser$ices. These com#anies guarantee com#liance &ith all the a##licable la&s. This %ee#s the business o&ner out of trouble &ith the la& and sa$es time that can be de$oted de$oted to something something else in the business. business. "f the business choose to do o&n #ayroll, it is recommended that to de$elo# an automated


2


2011

#ayroll system. '$en if the rest res t of boo%s are ar e done manually, an automated #ayroll system s ystem &ill sa$e time and hel# considerably &ith com#liance.

1.1 STATEMENT OF THE PROBLEM

The #resent system of calculation of gross salaries and deductable amounts is a tedious tedious tas% &hich in$ol$es in$ol$es ris%. The organi!ation organi!ation use the traditional traditional manual manual method method of #ayroll #rocessing, &hich in$ol$es #en and in%, adding machine, s#read sheet

etc.

instead of com#uters, soft&are and other com#uteri!ed aids. "t is time consuming and ris%y as it is more #rone to errors.  small mista%e can ruin the &hole &or% and also it is difficult to #oint out &here mista%e has been occurred. Therefore a ne& system is #ro#osed, &hich rectifies the errors #ersisted in the curre current nt syste system. m. -enc -ence, e, the the #ro* #ro*ec ectt is enti entitl tled ed as Payroll Payroll Manageme Managemen n Sy!em Sy!em "or Re#a$%l%a%on Plana%on! L%m%e&' P(nal(r. P(nal(r.

1.) OB*ECTI+ES

The follo&ing are the ob*ecti$es of the #ro*ect &or%. o

To analyse the the dra& dra&ba bac% c% of eis eisti ting ng Pay Payroll roll Mana Manage geme ment nt Syst System em of

Rehabilitations Plantations Ltd. Punalur. o To de$elo# a Payroll Management System soft&are for Rehabilitation Plantations Ltd. Punalur. o To determine the merits of the #ro#osed system &hen it is im#lemented.

1., METHODOLOGY

The methodology ado#ted for doing the #ro*ect Payroll Managemen Sy!em "or Re#a$%l%a%on Plana%on! L%m%e&' P(nal(r is based on both #rimary and secondary

data collection. /i Pr%mary Daa-  The #rimary data is collected by ma%ing an inter$ie& &ith the manager and the staff of the organi!ation. /ii Se/o secondary data for the #re#ar #re#aratio ation n of the #ro*ect #ro*ect is Se/on& n&ar ary y &aa &aa--  The secondary collected through  oo%s  rochure  3ebsite  Com#any #rofiles etc De!/r%0%on a$o( #e So"are Mar Thoma College of Science and Technology, yur.

4


2011

This Pro*ect Payroll Management System for Rehabilitation Plantations Limited, Punalur is designed using 5isual asic as front end and M S ccess as bac% end.

1.2 CHAPTERI3ATION Cha#ter 1

"6TR7)8CT"76

Cha#ter 2

7R96":T"76L PR7+"L'

Cha#ter 4

S;ST'M 6L;S"S

Cha#ter <

S;ST'M )'S"96

Cha#ter =

S;ST'M T'ST"69

Cha#ter >

S;ST'M "M "MPL'M'6TT"76 6) M"6T'66C'

Cha#ter ?

C76CL8S"76 6) S899'ST"76S


<


2011

CHAPTER ) ORGANI3ATIONAL PROFILE


=


2011

ORGANI3ATIONAL PROFILE The Rehabilitation Plantation Limited is a *oint $enture of the 9o$ernment of "ndia and 9o$ernment of @erala. The ShastriASirimao greement 1B>< necessitated the re#atriation of about si la%hs of #eo#le of "ndian origin from Sri Lan%a. Plantation Scheme, being labour intensi$e, and one among the most successful schemes im#lemented by the 9o$ernment of "ndia to rehabilitate the re#atriates. Rehabilitation Plantations Limited or RPLA as it is #o#ularly %no&n, a *oint $enture of 9o$ernment of "ndia and 9o$ernment of @erala, &as also setu# &ith the noble ob*ecti$e of rehabilitating the re#atriates from Sri Lan%a. The Rubber Plantation Scheme for resettlement has its beginning in @erala &ith the @erala +orest )e#artment. The @erala +orest )e#artment raised its first #lantation in yiranallur 'state during 1B?2 and in @ulathu#u!ha 'state during 1B?4. "n order to mobili!e additional finance by &ay of institutional finance and to relie$e the strain on the echeuer, the Rubber Plantation Scheme of @erala +orest )e#artment &as con$erted into a limited com#any R'-"L"TT"76 PL6TT"76S L"M"T'), on the =th May 1B?>. The authori!ed ca#ital of the com#any is Rs. 4=0 la%hs and the #aidAu# ca#ital as on date stood at Rs. 44B.2? la%hs. The com#any has raised Rubber Plantation in 20?0 hectares of leased reser$e forestland in the nchal range, and has established +actories for #rocessing of the field late and to #roduce $alue added #roducts. "t has settled ?00 re#atriates families #ro$iding #ermanent em#loyment to t&o eligible members of each resettled re#atriate family. The RPL is the mar%et leader in the sale of >0 concentrated late "S s#eciali!ation. t #resent the com#any sells about < million liters of high uality centrifuged late #er annum. "t #roduces all "S6R grades of bloc% rubber such as RPL &ent ahead in ugust 1BB0 by establishing 1.>t Pd crumb rubber factory at @ulathu#u!ha in consultation &ith the Rubber oard. +or utili!ing the maimum #roduction ca#acity of factory, the com#any mar%ets s%in cro# and tra# rubber &hich are the by#roducts of the centrifuging #rocess. The com#any has also a rubber sheeting factory &hich #roduces industrial sheeting, mottled sheeting and foot&ear uality sheeting of thic%ness $arying from 1=mm to 10mm. +or the uality control of #roduct the RPL had de$elo#ed modern research laboratory &ith im#orted testing eui#ments.


>


2011

The Com#any has been a&arded &ith 'n$ironmental Management System /"S7 1<001200< certification in May 2010 from accredited agencies. This Certificate is for all acti$ities related to Plantation, Collection and Su##ly of 6atural Rubber, 3ater Su##ly and 3aste Management at yiranallur and @ulathu#u!ha 'states. s on 40A0BA200B there are 1= A To# le$el 'ecuti$es, 20 A Middle le$el 'ecuti$es, 1DB A Lo&er category em#loyees other than &or%ers and 121= A 3or%ers in the Com#any. The Managing )irector of the Com#any is a##ointed by 9o$ernment from among the "+S cadre officers in the @erala State +orest )e#artment on de#utation basis and hence the remuneration a##licable to the incumbent is as a##licable to the incumbent in the #arent de#artment. The remuneration a##licable to the em#loyees in the category of staff and officers in the Com#any are as #er the #ay #attern in $ogue in 9o$ernment for the com#arable categories and the same is allo&ed on the basis of 9o$ernment orders from time to time.

BUSINESS PERFORMANCE IN THE YEAR )445)414 The total #roduction of rubber during the year 200BA2010 &as 11<1 MT of Rubber as against the #re$ious year 200DA200B #roduction of 12>2 MT. Main reasons for this reduction in #roduction in last year com#ared to #re$ious year includes reduction in #roduction area due to #hased reA#lanting #rogram, ad$erse climatic conditions etc. s #er the Re#ort of the Rubber oard, 6atural Rubber #roduction in 200BA10 &as lo&er by 4.D #er cent o$er 200DA0B nationally mainly o&ing to ad$erse &eather conditions, gro&ing stoc% of old #lantations and intense har$esting done in 200D. The Com#any occu#ies 24rd #osition in 200BA2010 /Pre$ious ;ear 24.B<> MT )RC of scra# rubber &as #urchased from outside sources. Mar Thoma College of Science and Technology, yur.

?


2011

The Rubber Sheeting +actory of the Com#any had #roduced 440 MT /Pre$ious year 4=?.D>2 MT of +3E Rubber Sheeting during the year under re$ie& and sold 4?2.>04 against last year 422.011 MT. )uring the year under re$ie& the Com#any has recei$ed orders for #rocessing R7CS"6 from the 5i%ram Sarabhai S#ace Centre, Thiru$anantha#uram.

OB*ECTI+ES OF THE COMPANY /1 To acuire on lease from the 9o$ernment of @erala the Rubber Plantations and fuel &ood #lantation raised by the @erala +orest )e#artment under the Rubber Plantations Scheme, Punalur and other lands and to acuire, #urchase or ta%e o$er on lease or other&ise #ri$ate lands and to carry on, etend and de$elo# the Plantations in the said lands &ith a $ie& to resettle re#atriates as &or%ers and em#loyees. /2 To engage in and carry on the business of #lanters, gro&ers and culti$ators of Rubber, +uel &ood, S#ecies, 7il Palm, reca nut, Cocoa nut and other Palms, 9round nut, Cocoa, Rubber, Tea, Cardamom, Cashe&, Pe##er, Lemongrass, 9inger, Cinnamon, Clo$es, Cam#hor, Tobacco, Ta#ioca, 'ucaly#tus, 9uttaA#ercha, Cinchona, Myristica, "ndica, Turmeric, Sugarcane, Cotton and any other agricultural cro# or #roduce. /4 To #rocess and render mar%etable, all #roduce gro&n by the Com#any and to carry on the business of #rocessing, manufacturing and dealing in Rubber, Coffee, Tea, Cocoa, Turmeric, Palm 7il and other agricultural and other #roducts of the Com#any or other&ise.

PRESENT ACTI+ITIES OF THE COMPANY 7$er the years RPL, has built u# a mar%et strategy enabling it to become a mar%et leader in the sale of >0 concentrated late &ith "S standards. t #resent, the com#any sells centrifuged late of high uality. To ma%e maimum utili!ation of the resources a$ailable Com#any has established a Crumb Rubber +actory at @ulathu#u!ha. This +actory #roduces all grades of Crumb Rubber. The annual ca#acity of the factory is 1D00 MT. Com#any has also established a Rubber Sheeting +actory. "t is #roducing foot&ear uality sheeting of thic%ness $arying from 1.= to 10 mm and mottled sheeting. '#ort uality sheeting are also manufactured in this factory.


D


2011

PRODUCT RANGE  >0 concentrated late  "ndian Standard 6atural Rubber /"S6R  Cre#e Rubber  "ndustrial Rubber Sheeting  Mottled Sheeting  cidAresistant Sheeting  Poly bag Rubber Seedlings of $arious clones.


B


2011

C#a0er , SYSTEM ANALYSIS


10


2011

SYSTEM ANALYSIS System analysis is an im#ortant acti$ity that ta%es #lace &hen anyone attem#ts to build a ne& system or &hen modifying the eisting ones. "n this #hase, the #roblems in the eisting system are thoroughly studied and ne& system is #ro#osed &hich rectifies the errors #ersisted in the current system. nalysis is the final stage before starting the design of a #ro*ect and hence all the modification should be done at this stage. System analysis is the #rocess of gathering and inter#reting facts, diagnosing #roblems and using the gathered information for the recommended im#ro$ement of the system. efore de$elo#ment of a #ro*ect, a study is conducted to learn the details of current situation. "nformation gathered through study forms the basis of creating alternati$e design strategy to #ursue. System analysis is about understanding situations. 'ffecti$e analysis includes in$estigation and uestioning to learn ho& a system currently o#erates and to identify the reuirements for a ne& or modified one. +or the de$elo#ment of any good #ro*ect, #ro#er analysis of the eisting system is im#ortant. The eisting system is studied to %no& the etent of com#uteri!ation reuired. Therefore a detailed analysis of eisting system should be conducted. +or this #ur#ose, system should be bro%en do&n into $arious subAsystems and these subAsystems are analy!ed closely to identify the #roblem areas.

THE INITIAL IN+ESTIGATION The first ste# in the system de$elo#ment life cycle is the identification of the need. This is a user(s reuest to change, im#ro$e, or enhance an eisting system. "t is also im#ortant to determine &hether the reuest is $alid and feasible before &e attem#t to im#ro$e or modify the eisting system or build a ne& one. The user(s reuest identifies the need for change and authori!es the initial in$estment. "t may undergo se$eral modifications before it becomes a &ritten commitment. 7nce the reuest is a##ro$ed the follo&ing acti$ities are carried out 

ac%ground "n$estigation



+actAfinding and nalysis


11


2011

t the end a detailed re#ort is created &hich is called the Pro*ect Pro#osal or Soft&are Reuirement S#ecification.

,.1 E6ISTING SYSTEM AND ITS DRA7BAC8S The #resent system uses the manual o#erations for entering details of the em#loyee, calculation of salary, loan, attendance, lea$e etc. This in$ol$es the #rocess of %ee#ing large number of files for $arious records. efore #erforming each function it is necessary to search records for the corres#onding files. "t is a &aste of time. "n a manual system search for #articular records are difficult and ta%es se$eral hours of etra &or% on each day to u#date the details of o#eration in the firm. There is a huge chance of getting errors during these manual &or%ing. There may be #ossibility in du#lication of records, delay and inconsistency in re#orting. There is no security #ro$ided for the eisting system.

LIMITATIONS OF THE E6ISTING SYSTEM 

Time consuming.



)ifficult to handle data accurately.



)ifficult to analyse the em#loyees( data.



Storage #roblems.



Current system is $ery costly.



)oes not #ro$ide data security, there is a chance for data du#lication.



8#dating rele$ant data is not easy.

,.) PROPOSED SYSTEM AND ITS AD+ANTAGES The #ro#osed system is designed to eliminate all the disad$antages of the eisting system. The #rocessing s#eed and accuracy of the ne& system is remar%able. The ne& system is almost error free and guides the user in e$ery stage of data in#uts to a$oid mista%es. The system is menu dri$en therefore no soft&areAbased training is reuired to o#erate the system. ll these features ma%e the soft&are an ideal choice . The #ro#osed Mar Thoma College of Science and Technology, yur.

12


2011

system consists of so many in#ut and out#ut #rocess. "t includes four modules and re#orts of $arious modules. "t also hel#s to release the human being from con$entional tas% and utili!e their man#o&er for other #rogressi$e moti$e for the management and the man%ind. This #ro*ect is done &ith 5isual asic as front end and MS ccess as bac% end. To #ro$ide efficient, fast, reliable and user friendly system is the basic motto behind this #ro*ect re#ort.

AD+ANTAGES OF THE PROPOSED SYSTEM

The #ro#osed system &ill be user friendly and sim#le in nature. 'nhanced data security. 6o data du#lication. S#eedy calculations are #erformed. 6o #a#er &or% is reuired. Time efficient. 'nable manager to sim#lify tas%s. 7#timi!e &or% flo&s and ma%e better and faster decisions.

,., FEASIBILITY STUDY +easibility study is an e$aluation of the #ro#osed system regarding its &or%ability, im#act on the organi!ation, ability to meet the user needs and effecti$e use of resources. Thus &hen a ne& a##lication is #ro#osed it normally goes through a feasibility study before it is a##ro$ed for de$elo#ment. +easibility study is carried out to test if the #ro#osed system is &orth being im#lemented. 9i$en unlimited resources and infinite time, all #ro*ects are feasible. 8nfortunately, such #ro*ects and time is not #ossible real situations. -ence, it becomes both necessary and sensible to e$aluate the feasibility of the #ro*ect at earliest #ossible time in order to a$oid unnecessary &astage of time. +easibility study is test of the system #ro#osed regarding its &or%ability, im#act on the organi!ation,ability to meet user needs and effecti$e use of resources. +i$e tests of feasibility are studied

• • • •

7#erational +easibility Technical +easibility 'conomic +easibility Moti$ational +easibility Mar Thoma College of Science and Technology, yur.

14

Payroll Management System for Rehabilitation Plantations Ltd. Punalur •

2011

Scheduled +easibility

,.,.1 OPERATIONAL FEASIBILITY

+easibility of the &or%ing of the system after the installation in the organi!ation as mentioned in the feasibility analysis.

,.,.) TECHNICAL FEASIBILITY

Technical feasibility is freuently the most difficult area to ensure at this stage. "t is essential that the #rocess of analysis and definition to be conducted #arallel to an assessment of the technical feasibility. The consideration that is normally associated &ith technical feasibility includes the resources a$ailability of the organi!ation &here the #ro*ect is to be de$elo#ed and im#lemented

,.,., ECONOMIC FEASIBILITY

n e$aluation of de$elo#ment cost is &eighted against the ultimate income or benefits deri$ed from the de$elo#ed system. There &as no need of etra hard&are and soft&are for de$elo#ment of this #ro*ect. -ence this #ro*ect has economically *ustified for de$elo#ment in this organi!ation.

,.,.2 MOTI+ATIONAL FEASIBILITY

n e$aluation of the #robability, that the organi!ation is sufficient moti$ation to su##ort the de$elo#ment and im#lementation of the a##lication &ith necessary user #artici#ation, resources, training etc. The interest and su##ort sho&n by the organi!ation during the system study do not seem that the ne& system de$elo#ed to ha$e efficient su##ort from the organi!ation.

,.,.9 SCHEDULED FEASIBILITY

The time schedule reuired for the de$elo#ment of this #ro*ect is $ery im#ortant, since more de$elo#ment time effects machine time, costs and delays in the de$elo#ment of the other systems. So the #ro*ect should be com#lete &ithin affied schedule time.

,.2 SYSTEM SPECIFICATION


1<


2011

System en$ironment is the en$ironment in &hich the system &as de$elo#ed. "t includes both soft&are configurations and hard&are configurations. These configurations are carefully chosen such that these com#rise of features that are best suited for the current a##lication de$elo#ed.

,.2.1 HARD7ARE SPECIFICATION

Processor



P'6T"8M "5

Processor s#eed



1.1 9-!

Cache Memory



=12 @ Cache

Random ccess Memory



1 9 RM

5ideo RM



DM

-ard )is% )ri$e



<0 9

@ey oard



10D @eys

Mouse



Logitech PSF2 Mouse

Com#act )is% )ri$e



=2 G C) )ri$e

+lo##y )is% )ri$e



1.<< M, 4.= inch

,.2.) SOFT7ARE SPECIFICATION

7#erating System



3indo&s GP

+ront 'nd



5isual asic

ac% 'nd



MS ccess

,.2., ABOUT OPERATING SYSTEM

O+ER+IE7 OF 7INDO7S 6P

3indo&s is the &orld #o#ular families of o#erating systems. "t comes in many fla$ors 3indo&s BD, 3indo&s BD S', 3indo&s 2000, 3indo&s 6T, 3indo&s GP and so on. "t is a 98" /9ra#hical 8ser "nterface based o#erating system. "ts sim#le interfaces let e$en an a$erage user to o#erate the com#uter in $ery easy &ays.

SOME OF THE FEATURES OF 7INDO7S 6P 1. Gra0#%/al U!er Iner"a/e


1=


2011

+rom the user(s #oint of $ie& 98" is the most #o&erful ca#ability offered by 3indo&s. The benefits #ro$ided by $isual interface are informati$e #resentation, consistency and reduced &or%load of the #rogrammer. ). M(l%a!:%ng Ca0a$%l%y

Multitas%ing en$ironment is one in &hich more than one #rocess can be #erformed at the same time. )ifferent instances of the same a##lication can also run simultaneously. )i$iding of the #rocessor(s time among the currently running tas%s is the res#onsibility of the 3indo&s.

,. Memory Managemen

3indo&s GP has the ca#ability to create a secondary hea# inde#endent of the 9L7L -'P. The 42Abit flat memory module is im#lemented using a #age based $irtual memory management system. The management and the trans#ortation of $irtual memory addresses to #hysical memory addresses are normally trans#arent to the #rogrammer.

2. E;0an&e& F%le Sy!em

"n 3indo&s GP, file system has been e#anded in t&o &ays. +irst there is direct su##ort of C)AR7M dri$es. Second the file system allo&s for access to the items other than con$entional dis% files. 9. Neor: S(00or

3indo&s GP offers fully integrated on a #eerAtoA#eer le$el and as a client on net&or% ser$ers. The net&or%ing systems are modular and can be configured &ith net&or% #ro$iders, trans#ort interfaces and dri$ers to meet the user(s reuirements. The net&or% P" su##orts multi#le net&or%s and #ro$ides a 42Abit #rogramming interface that is inde#endent of any s#ecific net&or%ing techniue of $endor. ll ma*or net&or%s and #rotocols are su##orted and other net&or%s and #rotocols can be added in a modular fashion.

,.2.2 ABOUT FRONT END O+ER+IE7 OF +ISUAL BASIC

5isual asic is one of the most successful tools designed by Microsoft Cor#oration. The 5isual asic en$ironment is great for creating, almost any ty#e of Mar Thoma College of Science and Technology, yur.

1>


2011

a##lication. Robust standA alone a##lications, games, utilities etc can be de$elo#ed in less time using 5isual asic and it #ro$ides a gra#hical en$ironment &here forms and controls can be $isually designed. 5isual asic a##lications are $ery #o#ular as frontAend to many ClientFSer$er database systems li%e SEL Ser$er, 7racle, and MS ccess etc. The main features of 5isual asic include  Har&are In&e0en&en/e

-ard&are inde#endence means that an a##lication #rogram that runs in the 3indo&s en$ironment on a #articular #iece of hard&are can run on any #iece of hard&are of sufficient si!e.  E
5isual asic is an ob*ect oriented #rogramming language, &hich uses the H'$ent )ri$en Model( for doing a &or%. -ere user has control o$er the seuence of e$ents i.e., #rogram eecution is controlled by e$ents such as mouse clic%, %ey #ress, double clic% etc. "n a traditional #rogramming en$ironment user must enter information in an order determined by an a##lication #rogrammer. Programs &ritten to run in a seuential fashion i.e., &hen the #rogram starts, it #roceeds instruction by instruction until the end of the #rogram is reached.

T#e Programm%ng Term%nology %n +%!(al Ba!%/

n im#ortant feature of 5isual asic is its "ntegrated )e$elo#ment 'n$ironment. "t is called integrated because the user can access $irtually all the de$elo#ment tools the user needs from the screen called an interface. 5isual asic #ro$ides a 98" in &hich &e $isually designed form and controls that become the building bloc%s of our a##lication. 5isual asic su##orts #ro*ects, forms, charts, ob*ects, tem#lates, custom controls, addAins and data managers. The "ntegrated )e$elo#ment 'n$ironment /")' is an im#ortant #art of 5isual asic. 5isual asic ")' is made u# of a number of com#onents.

Form-

3e can use forms for a $ariety of #ur#oses. Most of the information in a form comes from an underlying record source, and other information in the form is stored in the form design. The lin% bet&een a form and its record source by using gra#hical ob*ects is called controls. The most common ty#e of control used to dis#lay and enter data is a


1?


2011

tet bo. Most form has a delete section, but a form can also include form header, #age header, #age footer and form footer.


1D


2011

Mo&(le!-

 module is a collection of 5isual asic code for a##lications, declarations and #rocedures that are stored together as a unit. There are t&o ty#es of modules. 1.

Class module

2.

Standard module

'ach #rocedure in a module can be a function, #rocedure or a sub #rocedure. E
n e$ent is a s#ecific action that occurred on or &ith a certain ob*ect. '$ents are usually the results of future actions. There is a toolbo #resent &ith many com#onents, &hich can be further added, rather than the already #resent items. Some of them areA

1.

Comman& $(on

 command button on a form starts an action or set of functions. ). La$el

Labels on a form or re#ort dis#lay descri#ti$e tet such as titles, ca#tions or brief instruction. Labels do not dis#lay $alues from fields or e#ressions and they do not change as more from record to record. 4. Te; $o; Tetbo hel#s to dis#lay data from a table, uery or 7racle statement. Tetbo can also be bound. )ata in an unbound tetbo isn(t stored any&here. 2. L%! $o;

"n many cases it is uic%er and easier to select a $alue from a list than to remember a $alue to ty#e.  list of choices also hel#s to ensure that the $alue that is entered in the field is correct. List form #erforms this action. 9.

Com$o $o;

 combo bo is li%e a tetbo and a list bo combined together. To select a $alue in a combo bo, if the combo bo in bound, the entered or selected $alue is inserted into the field that the combo bo is bound to.


1B


=.

2011

C#e/:$o;

Chec%bo acts as a standAalone control to dis#lay a ;esF 6o. 5alue from an underlying table, uery or 7racle statement of the bo contains a chec%mar%, the $alue is yes. "f it doesn(t the $alue is 6o. >.

O0%on $(on

n o#tion button on a form or re#ort is a standAalone control dis#lays ;esF 6o. 5alue from a tetbo on a form or re#ort dis#lay that, they are from a table, uery or 7racle statement. "f the o#tion button is selected, the $alue is ;es, if not, the $alue is 6o. ?.

Toggle $(on

Toggle button on a form is a standAalone control used to dis#lay ;esF6o $alue from an underlying table, uery or 7racle statements.

,.2.9 ABOUT BAC8 END

MSACCESS

Microsoft ccess is a )atabase Management System or )MS. s the name im#lies, a )MS hel#s you to manage data that(s stored in a com#uter database. "f you &ant the fleibility to dis#lay, #rint and analy!e your information in &hate$er format you &ish, you first need to brea% do&n that information into small unit of data. fter brea%ing the information into discrete units of data, you can use a database management system, such as ccess, to analy!e and #resent that data any &ay you &ish. "n ccess, you must brea% all your information into data that(s stored in tables.  table is *ust a collection of data that(s organi!ed into ro&s and column. ;ou can #ut any information that(s a$ailable to you into a table. ccess act as database. )atabase is a collection of tables. Table is a collection of ro&s and column. )atabase management #rograms are designed to store, mani#ulate and re#ort large $olume of information. ccess can also integrate documents and information created by other offices and &indo&s #rograms. ;ou can insert 'cel S#readsheet documents directly into an ccess table.

Ma%n Elemen! o" A//e!!

ccess is an ob*ectAoriented #rogram.

7b*ects are modules, &hich #ro$ide

information and #rograms, &hich the user can directly a##ly to create a##lications. Mar Thoma College of Science and Technology, yur.

20


'$erything in access is an ob*ect, including the a##lication itself.

2011

ccess has the

follo&ing ob*ects.

Daa$a!e 7%n&o

"n ccess, all ob*ects of a database are stored in a single file, and the filename has an.mdb etension. These are managed through the database &indo&.

Ta$le!

Tables are the #rimary building bloc%s of the ccess database. ll data is stored in tables. '$ery table in the database focuses on one ob*ect. '$ery ro& or records in the table is a uniue instance of the sub*ect of the table. Re0or!

3hether &e li%e it or not &e are still a #a#er based society, #rinting the results of the data. 3e store re#orts because they are still necessary. 3ith ccess &e can uic%ly and easily design re#orts based on our data.

Rela%on!#%0

3hen &or%ing &ith ccess, &e can create and use multi#le tables, &hich hel# to reduce the redundancy in the database. "n this case &e set the #rimary %ey.

Daa y0e

The data ty#e a field determines the %ind of data the field can store.

Conne/%ng o &aa$a!e

7ne of the %ey features of 5isual asic is #o&erful database de$elo#ment. )atabase #rogramming is done by ma%ing use of e$ent dri$en #rogramming using controls and the ")' #ro$ided &ith 5isual asic. The $arious accessing technologies su##orted by 5isual asic are

 )ata ccess 7b*ect /)7  Remote )ata ccess 7b*ect /R)7  cti$eG )ata 7b*ect /)7


21


2011

Daa A//e!! O$@e/

)ata ccess 7b*ects enables us to use #rogramming languages to access and mani#ulate data in local or remote database and to manage database, their ob*ects li%e tables, $ie&s, stored #rocedures etc.

Remoe Daa A//e!!

Remote )ata ccess ob*ects is also a similar #rogramming language li%e )ata ccess 7b*ects, &hich allo&s us to access the data from the database easily. "t #ro$ides information model for accessing remote data source through 7)C.

A/%
cti$eG )ata 7b*ect is also a similar #rogramming language li%e )ata ccess 7b*ect and Remote )ata ccess 7b*ect to access the data from database easily. The Microsoft launched it as an initiati$e to&ards &eb based a##lications. "t contains fe&er ob*ects and more #ro#erties, methods and e$ents than remote data access ob*ect.

Daa Re0or

To analy!e our data or #resent it in a certain &ay in #rint, create a re#ort. )ata re#ort allo&s us to use drag and dro# to uic%ly create re#orts from any record set, including hierarchical record sets.


22


2011

CHAPTER 2 SYSTEM DESIGN


24


2011

SYSTEM DESIGN )esign is the second #hase in the system de$elo#ment life cycle. Soft&are design is the first of the three technical acti$ities in the soft&are de$elo#ment #rocess such as design, code &riting and testing. )uring this #hase, the analyst schedules design acti$ities, &or%s &ith the user to determine the $arious data in#uts to the system, #lans ho& data &ill flo& through the system, designs reuired out#uts and &rites #rogram s#ecifications. gain the analyst(s acti$ities focus on sol$ing a user(s #roblem in logical terms. )uring this second ste#, analysts em#loy a $ariety of tools such as data flo& diagrams, entityArelationshi# diagrams, data dictionaries and 9antt chart. The system(s design con$erts the theoretical solution introduced by the feasibility study into a logical reality. )uring design the analyst •

)ra&s a model of the ne& system, using data flo& and entityArelationshi# diagrams.

•

)e$elo# methods for collecting and in#utting data.

•

)efines the detailed data reuirements &ith a data dictionary.

•

3rites #rogram s#ecifications.

•

S#ecifies control techniues for the system(s out#uts, databases and in#uts.

•

"dentifies and orders any hard&are or soft&are that the system &ill need.

"n the #hysical design #hase, necessary soft&are is de$elo#ed to acce#t in#ut from the user, to #erform necessary calculations through the mani#ulation of data stored in the databases to #roduce the a##ro#riate result.


2<


2011

2.1 MENU TREE

Payroll Managemen Sy!em "or Re#a$%l%a%on Plana%on L&. P(nal(r

)e#artment

'm#loyee details

ttendance details

Salary details

G

)e#artment details

'nter em#loyee details

'nter attendance details

Search de#artments

5ie& em#loyee details

5ie& attendance details

5ie& salary details

'dit de#artments

8#date em#loyee details

8#date attendance details

8#date salary details

'nter salary details

G

Pay sli#

Re#orts 'm#loyee details ttendance details

8ser dd user 8#date user

-el#

'it 6ote #ad Calculator

Salary details


2=


2011

2.) DATA FLO7 DIAGRAM )ata +lo& )iagram /)+) is an im#ortant tool used by system analyst. )+) #ro$ide an o$er$ie& of &hat data a system &ould #rocess, &hat transformation of data are done, &hat files are used and &here the results flo&. The gra#hical re#resentation of the system ma%es it a good communication tool bet&een the user and the analyst, nalysis model hel# us to understand the relationshi# bet&een different com#onents in the design. nalysis model sho&s the user clearly ho& a system &ill function. This is the first technical re#resentation of the system. The analysis modeling must achie$e three #rimary ob*ecti$es. 

To establish a basis for creation of soft&are design.



To describe &hat the user reuires.



To define set of reuirements that can be $alidated once the soft&are us build.

 data flo& diagram is a gra#hical techniue that de#icts information flo& and transforms that are a##lied as data mo$e from in#ut to out#ut. The )+) is used to re#resent increasing information flo& and functional details.  le$el 0 )+) also called contet le$el re#resents the entire soft&are elements as single bubble &ith in#ut and out#ut indicated by incoming and outgoing arro& res#ecti$ely. Sym$ol! (!e& %n DFD

'ntity

Process

)ata +lo&

)ata Store )atabase

Re#ort F +ile


2>


2011

Cone; Le
Reuest

Res#onse Payroll Manageme nt System

dmin Reuest 8ser

dmin Res#onse 8ser

Le
dministrator Login

dd 8ser dmin

Login

)e#artment dministrator Login

)e#artment

)etails

Le
'm#loyee details

8ser

Salary calculation #rocess

)at aba se



2?


2011

Le
dd

'dit

dmin


dd 8ser Search

)elete

Le
dd

'dit dmin

)e#artment details

)e#artment

Search

)elete


2D


2011

Le
'm#loyee details

Salary calculation

Login

8ser

dd'm#loyee


SalaryCalculation


ddttendance dd'm#loyee

Le
dd

'dit

8ser

'm#loyee details

dd'm#loyee

Search

)elete Mar Thoma College of Science and Technology, yur.

2B


2011


40


2011

Le
dd

'dit 8ser


ddattendance

Search

)elete

Le
8ser

Salary calculation

ddem#loyee

Salarycalculation

Statement #re#aration

Salary


41


2011

2., DATABASE DESIGN The most im#ortant as#ects of building an a##lication is the design of tables or database schema. The data stored in the table must be organi!ed in some manner, &hich is meaningful. The o$erall ob*ecti$es in the #rocess of the table design ha$e been to treat data as organi!ational resources and as integrated &hole. The organi!ation of the data in a database aims to achie$e. The ma*or fi$e ob*ecti$es are 

)ata integrity



)ata inde#endency



Controlled Redundancy



Pri$acy and security



Performance

Se$eral degrees of normali!ation ha$e to be a##lied during the #rocess of table design. The ma*or aim of the #rocess of the normali!ation is to reduce data redundancy and #re$ent losing data integrity. Redundancy refers to un&anted and un necessary re#etition of data. )ata integrity has to be con$erted at all le$els. Poor normali!ation can cause #roblem related to storage and retrie$al of data. )uring the #rocess of normali!ation &hich identified cause serious #roblems, during deletion and u#dating. 6ormali!ation also hel#s in sim#lifying the structure of the table. The theme behind a database is to handle information as an integrated &hole that ma%e access to information easy, uic% ine#ensi$e and fleible for users. The entire #ac%age de#ends on ho& the data are maintained in the system. 'ach table has been designed &ith a #erfect $ision.


42


2011

TABLES

A&m%n%!raorlog%n F%el& 'm#id 6am )esi )atofre Rol 8ser Pass

Ty0e 6umber Tet Tet )ateFTime Tet Tet Tet

S%e D 20 20

10 10 10

Con!ra%n! Primary @ey 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull

De!/r%0%on 'm#loyee ") 6ame )esignation )ate of registration Role 8sername Pass&ord

Ty0e Tet Tet Tet

S%e 20 20 20

Con!ra%n! Primary @ey 6ot 6ull 6ot 6ull

De!/r%0%on )e#artment code )e#artment name )e#artment head

De0armen F%el& )e#code )e#name )e#head


44


A&&Em0loyee F%el& )at 'm#id

)ob +ath 9end Marital S#ous )e# Iob )o* # Resi Permi Mob Tel Pin Stat Coun

Ty0e )ateFTime 6umber

S%e

D

2011

Con!ra%n! 6ot 6ull Primary @ey

De!/r%0%on )ate 'm#loyee ")

)ate of birth +ather(s name 9ender Marital status S#ous )e#artment Iob )ate of *oining asic #ay Residence ddress Permanent ddress Mobile number Tele#hone number Pincode State Country

)ateFTime Tet Tet Tet Tet Tet Tet )ateFTime 6umber Tet Tet 6umber 6umber 6umber Tet Tet

D =0 =0 10 10 D 10 1=

/+@ 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull

Ty0e 6umber Tet 6umber 6umber

S%e < 1= < D

Con!ra%n! 6ot 6ull 6ot 6ull 6ot 6ull Primary @ey

De!/r%0%on )ay Month ;ear 'm#loyee ")

20 1=

/+@ 6ot 6ull 6ot 6ull

6ame ttendance

20 1= 12 20 20 20

A&&aen&an/e F%el& )at Mnth yer 'm#id

6am tt

Tet Tet


4<


2011

SalaryCal/(la%on F%el& 'm#id

6ame basic#ay )e#artment )ate Mnth )a -ra Ta 7thers 'total Pf 'si Loan d$ance )others 6olea$ Lea$amt netsalary Sli#no

Ty0e 6umber

Tet 6umber Tet )ateFTime Tet 6umber 6umber 6umber 6umber 6umber 6umber 6umber 6umber 6umber 6umber 6umber 6umber 6umber utonumber

S%e D

Con!ra%n! Primary @ey

De!/r%0%on 'm#loyee ")

20 D D D D D D D D D D D D D D

/+@ 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull 6ot 6ull

6ame asic Pay )e#artment )ate Month )earness llo&ance -ouse Rent llo&ance Tra$eling allo&ance 7thers 'arning Total Pro$ident fund 'S" Loan d$ance )eduction others 6umber of lea$e Lea$e amount )eduction total Sli# number

20 10 20

9rsal

6umber

D

6ot 6ull

9oss salary

netsal

6umber

D

6ot 6ull

6et salary


4=


2011

2.2 INPUT DESIGN "n#ut design is the #rocess of con$erting user oriented in#ut into a com#uter based format. The data flo& diagram indicates logical data flo&, data source and destinations. "n#ut data are collected and organi!ed into a numbered data. The goal of in#ut design is to ma%e data entry as easy and free from errors as much as #ossible. Pro#er data $alidation chec%ing is eercised the mista%es made during data entry.

2.9 OUTPUT DESIGN 7ut#ut design is a #rocess that in$ol$es designing necessary out#uts that ha$e to be gi$en to $arious users according to the reuirements. Com#uter out#ut is the most im#ortant and direct source of information to the users. 'fficient out#ut design should im#ro$e the systems relationshi# &ith the user and hel# in the decision ma%ing. The system has got the ca#ability to dis#lay the standard screen layout.


4>


2011

CHPATER 9 SYSTEM TESTING


4?


2011

SYSTEM TESTING 9.1 TESTING System testing is actually a series of different tests &hose #rimary #ur#ose is to fully eercise the com#uterAbased system. lthough each test has a different #ur#ose, all &or% &or% to $erify $erify that that all system system elemen elements ts ha$e ha$e been been #ro#er #ro#erly ly integr integrated ated and #erfor #erform m allocated functions. Testing is done to ma%e sure that the #roduct does eactly &hat is su##osed to do. Testi Testing ng is the final final $erific $erificatio ation n and $alida $alidatio tion n acti$it acti$ity y &ithin &ithin the organi organi!ati !ation on itself. itself. )uring testing the ma*or acti$ities are concentrated on the eamination and modification of the source code. "n the testing stage, the follo&ing goals are achie$ed o o o o o

To affirm affirm the uality of the #roduct. To find and eliminate any residual errors from #re$ious stages. To $alidate the soft&are as a solution to the original #roblem. To demonstrate the #resence of all s#ecified functionality in the #roduct. To estimate the o#erational reliability of the system.

9.1 SOFT7ARE TESTING TECHNIUES The im#ortance of testing and its im#act on soft&are cannot be under estimated. Soft&are testing is a fundamental com#onent of soft&are uality assurance and re#resents a re$ie& of s#ecification, design and coding. The greater $isibility of soft&are systems and the cost cost associat associated ed &ith &ith the soft&a soft&are re failure failure are moti$a moti$atin ting g factors factors for #lanni #lanning ng through testing.

9.1.1 UNIT TESTING

8nit Testing concentrates on each unit of the soft&are as im#lemented in source code. "nitially tests focus on each module indi$idually, ensuring that it functions #ro#erly as a unit. The modules must then be assembled or integrated to form the com#lete soft&are #ac%age. The follo&ing tests occur as #art of unit testing Iner"a/eIner"a/e-  The module interface is tested to ensure that information #ro#erly flo&s into

and out of the #rogram unit under test.


4D


2011

Lo/al Daa Sr(/(re- The local data structure is eamined to ensure that the data stored

tem#orarily maintains its integrity during all ste#s in an algorithmic eecution. Bo(n&ary /on&%%on!- oundary conditions are tested to ensure that the module o#erates

#ro#erly at boundaries established to limit or restrict #rocessing. In&e0en&en In&e0en&en Par!- ll inde#endent #arts through the control structures are eercised to

ensure that all statements in a module ha$e eecuted at least once. Error Han&l%ng 0ar!- +inally all error handling #arts are tested.

9.1.) INTEGRATION TESTING

The net le$el of the testing is often called as "ntegration Testing in &hich many tested modules are combined into sub system, &hich are then tested. The goal here is to see if the modules can be integrated #ro#erly, the em#hasis being on testing interfaces bet&een modules. Modules in this soft&are are combined and tested after the unit testing. fter fter connec connectin ting g the sub module moduless into into &hole &hole modul module, e, the connec connectio tions ns bet&een bet&een the modules are correctly established. The bac%end and front end are &or%ing as a &hole module and the data entered in the front end once submitted &ere successfully entered in to the database. fter #erforming integration testing, the net ste# should be the out#ut testing of the de$elo#ed system, because no system could be useful if it does not #roduce the reuired out#ut in a s#ecific format.

9.1., +ALIDATION ALIDATION TESTING TESTI NG

5alidation lidation testing testing #ro$ides #ro$ides final assurance that soft&are soft&are meets all functional, functional, beha$ior and #erformance reuirements. re uirements. 5alidation 5alidation testing tes ting is done by #erforming chec%s on the follo&ing fields Tet +ieldAThe tet field can contain only the number of character lesser than or eual to its si!e. The tet fields are al#hanumeric in some tables and al#habetic in other tables. "ncorrect entry al&ays flashes an error message. 6umeric +ieldAThe numeric field can contain only numbers from 0 to B. n entry of any character flashes an error messages. The indi$idual modules are chec%ed for accuracy and &hat it has to #erform. 'ach module is sub*ected to test run along &ith sam#le data.


4B


2011

9.1.2 SYSTEM TESTING

Syste System m testi testing ng ensu ensure re that that all all elem elemen ents ts mesh mesh #ro# #ro#erl erly y and and o$era o$erall ll syste system m #erformance is achie$ed. System testing is the most useful #ractical #rocess of eecuting a #rogram &ith an e#licit intention of finding the errors that is ma%ing the #rogram fail.

9.) TRAINING

Train Training ing the users users is $ery $ery im#orta im#ortant. nt. oth oth system system o#erato o#erators rs and users need need trainin training. g. )uring )uring trainin training, g, they should should be gi$en gi$en a troubl troublesh eshoot ooting ing list that that identi identifies fies #ossible #roblems and the remedies for those #roblems. The training should co$er the follo&ing. •

Training in using the a##lication i.e. the soft&are.

•

9ood im#lementation

+amiliari!ation &ith #rocessing en$ironment there are se$eral user training aids a$ailable li%e the user manuals, hel# screens, data dictionary, *obs aids. 9., UALITY ASSURANCE

Euality assurance is the %ey element of soft&are testing. The uality assurance ensures the $alidity and the reliability of the system. The definition of $erification and $alidation encom#asses the uality assurance of the soft&are. 5erification refers to the set of acti$ities that ensures that the soft&are that has been built is traceable to customer reuirements. The integrity of $ital data is maintained. Change o$er from old system may occur &hen •

The The syst system em has has been been #ro$ #ro$ed ed satis satisfac facto tory ry and and im#l im#lem emen enta tatio tion n has has been been

•

com#leted. The user is satisfied &ith the results of system test, training and reference manuals.


<0


2011

CHAPTER = SYSTEM IMPLEMENTATION AND MAINTENANCE


<1


2011

SYSTEM IMPLEMENTATION AND MAINTENANCE

=.1 SYSTEM IMPLEMENTATION The creation of the designed system ta%es #lace in the im#lementation #hase. This #hase acti$ities do the follo&ing

)e$elo#ment #hase o$er$ie&, #re#aring of im#lementation, com#uter #rogram de$elo#ment, de$elo#ment #hase re#ort and o$er$ie&. "t also #erforms acti$ities li%e &riting, testing, debugging and documenting the #rograms.

There are three ty#es of im#lementations

•

"m#lementation of a com#uter system to re#lace a semiAmanual system. The #roblems encountered are con$erting files, training users, creating accurate files and $erifying #rintouts for integrity.

•

"m#lementation of a ne& com#uter system to re#lace an eisting one. This is usually a difficult con$ersion. "f not #ro#erly #lanned, there can be many #roblems. Some large com#uter systems ha$e ta%en as long as a year to con$ert.

•

"m#lementation of a modified a##lication to re#lace the eisting one, using the same com#uter. This ty#e of con$ersion is relati$ely easy to handle, #ro$ided there are no ma*or changes in the files. '$ery system reuires #eriodic e$aluation after im#lementation.

IMPLEMENTATION PLANNING

This is the first tas% in system im#lementation. The methods and the time scale to be ado#ted are decided. 7nce the #lanning is o$er, the ma*or effort in com#uter de#artment is to ensure that #rograms in the system &or% #ro#erly.

=.) SYSTEM MAINTENANCE


<2


2011

The final and im#ortant #hase in the system life cycle is the maintenance of the ne& system. System maintenance refers to the ste# necessary to install a ne& system to #ut into o#eration. The ne& system may be totally re#lacing an eisting manual, it may be ma*or modification to an eisting system. The method of maintenance and time scale to be ado#ted is found out initially. The system is tested #ro#erly and at the same time the users are trained in the same #rocedure. Pro#er maintenance is essential to #ro$ide a reliable system to meet organi!ation reuirements. The ma*or #art of the maintenance of the system is #layed by the administrator or user &ho uses the soft&are freuently. Successful maintenance may not guarantee im#ro$ement in the organi!ation. ut it #re$ents im#ro#er errors. Thus it can be considered as the most crucial stage in achie$ing a successful ne& system and in gi$ing the administrator and user confidence that the ne& system &ill &or% and be effecti$e. • • •

Correcti$e maintenance da#ti$e maintenance Predicti$e maintenance

Maintenance means restoring something to its original condition. Maintenance in$ol$es &ide range of acti$ities including correcting, coding and designing of documents, u#dating of documentation and data, and u#grading users su##ort. Maintenance is continued till the #roduct is reengineered or de#loyed to another #latform. Maintenance is also done based on fiing the #roblems re#orted, changing the interface &ith other or hard&are enhancing the soft&are.


<4


2011

CHAPTER > CONCLUSION AND SUGGESTIONS


<<


2011

CONCLUSION AND SUGGESTIONS CONCLUSION The eisting Payroll management System of the organi!ation is manual. They maintain se#arate registers and boo%s for storing each and e$ery data. There are many dra&bac%s in the eisting system, s#ecified as follo&.  The current system is time consuming  Re#ort generation ta%es lot of time  The o$erall #erformance of the system is too slo&.  Lac% of security.

This

#ro*ect

entitled

Payroll

Managemen Sy!em "or Re#a$%l%a%on

Plana%on! L&. P(nal(r is aimed to o$ercome all the dra&bac%s and to automate the

eisting system. The soft&are JPayroll Management SystemK de$elo#ed in 5isual asic and M S ccess is easily ada#table to each and e$ery situation. The system &as successfully de$elo#ed to fully satisfy the ob*ecti$es set by the concern. The system &as tested &ith real data and all the re#orts &ere successfully ta%en and &ere found to satisfy the needs of the concern. Since the #ro*ect &as done in 5isual asic future enhancement is easier. -ere in this system all the difficulties faces by the manual system &ere o$ercome. The soft&are reduces the labour &or%. There &as a lot of #ositi$e feedbac% &hen the final testing of #ro*ect &as o$er. The soft&are is designed &ith the aim of #ro$iding fast, reliable and secure access to end users. The system #erforms right #rocedures #ro#erly and #resents information in the acce#table and effecti$e &ay, #roduces accurate results, and #ro$ides an acce#table interface and a method of interaction &ith the users.

SUGGESTIONS  Modification can be done at ease &ithout disturbing the #ro#er &or%ing of the

system.  More security constrains can be im#lemented.  n o#tion for database bac%u# can also be added.


<=


2011

APPENDI6


<>


2011

APPENDI6 CODING Form1log%n."rm

Pri$ate Sub ClerClic%/ clearform Me 'nd Sub

Pri$ate Sub +ormLoad/ connection 'nd Sub

Pri$ate Sub 7%Clic%/ db.7#en rs.7#en select N from dministrationLogin &here userO Q 8ser.Tet Q  and #assO Q Pass.Tet Q , db, ad7#en)ynamic, adLoc%7#timistic "f rs.'7+ O True nd rs.7+ O True Then Msgo Chec% 8ser6ame or Pass&ord.... 'lse Msgo Login Successfull......  M)"+orm1.Sho& Me.-ide 'nd "f rs.Close db.Close 'nd Sub

MDI Form

Pri$ate Sub Clic%/ +orm2.Sho& 'nd Sub

Pri$ate Sub CClic%/ Shell calc.ee Mar Thoma College of Science and Technology, yur.


2011

'nd Sub

Pri$ate Sub ddlsClic%/ +RM)'P.Sho& 'nd Sub

Pri$ate Sub eaClic%/ +orm>.Sho& 'nd Sub

Pri$ate Sub eadClic%/ +ormD.Sho& 'nd Sub

Pri$ate Sub ed#t1Clic%/ frm'dit)e#artment.Sho& 'nd Sub

Pri$ate Sub 'edClic%/ +orm4.Sho& 'nd Sub

Pri$ate Sub esClic%/ +ormB.Sho& 'nd Sub

Pri$ate Sub eClic%/ )im uit uit O Msgo/re you sure, $bEuestion  $b;es6o, 'it "f uit O $b;es Then 'nd 'nd "f 'nd Sub Mar Thoma College of Science and Technology, yur.


2011

Pri$ate Sub n#Clic%/ Shell note#ad.ee, $b6ormal+ocus 'nd Sub

Pri$ate Sub #aClic%/ +orm10.Sho& 'nd Sub

Pri$ate Sub Timer1Timer/ )im le s "nteger le O Len/hrm A scr hrm O Payroll Management System  Me.Ca#tion O subhrm "f flag Then subhrm O Left/hrm, le scr O scr A 1 'lse subhrm O Right/hrm, le scr O scr  1 'nd "f "f scr  Len/hrm Then flag O True scr O Len/hrm 'nd "f "f scr U 0 Then flag O +alse scr O 0 'nd "f 'nd Sub

Pri$ate Sub Sd#tsClic%/ frm)e#artmentSearch.Sho& Mar Thoma College of Science and Technology, yur.


2011

'nd Sub

Pri$ate Sub 8#edlClic%/ +orm=.Sho& 'nd Sub

Pri$ate Sub 8sClic%/ +orm12.Sho& 'nd Sub

Pri$ate Sub uuClic%/ +orm11.Sho& 'nd Sub

Pri$ate Sub $aClic%/ +orm?.Sho& 'nd Sub

Pri$ate Sub $edClic%/ +orm<.Sho& 'nd Sub

Pri$ate Sub 5sClic%/ +orm14.Sho& 'nd Sub

Form,A&& Em0loyee &ea%l!

)im s, # s String Pri$ate Sub ddClic%/ db.7#en rs1.7#en select 'm#id from dd'm#loyee, db, ad7#en)ynamic, adLoc%7#timistic "f rs1.7+ O True 7r rs1.'7+ O True Then Msgo /'m#loyee "d 'isting enter another "d Mar Thoma College of Science and Technology, yur.

=0


2011

'lse rs.7#en dd'm#loyee, db, ad7#en)ynamic, adLoc%7#timistic rs.dd6e& rsV)at O )at.5alue rsV'm#id O 'm#id.Tet rsV6am O 6am.Tet rsV)ob O )ob.5alue rsV+ath O +ath.Tet "f 7#male.5alue O True Then s O 7#male.Ca#tion 'lse"f 7#fe.5alue O True Then s O 7#fe.Ca#tion 'nd "f rsV9end O s "f 7#mari.5alue O True Then # O 7#mari.Ca#tion 'lse"f 7#unmari.5alue O True Then # O 7#unmari.Ca#tion 'nd "f rsVMartial O # "f # O MRR"') Then rsVS#ous O S#ous.Tet 'nd "f "f # O 86 MRR"') Then rsVS#ous O 6ill 'nd "f rsV)e# O )e#.Tet rsVIob O Iob.Tet rsV)o* O )o*.5alue rsV# O #.Tet rsVResi O Resi.Tet rsVPermi O Permi.Tet rsVMob O Mob.Tet Mar Thoma College of Science and Technology, yur.

=1


2011

rsVTel O Tel.Tet rsVPin O Pin.Tet rsVStat O Stat.Tet rsVCoun O Coun.Tet rs.8#date Msgo )ata Sa$ed..... rs.Close db.Close db.7#en rs.7#en

select

ma/'m#idfrom

dd'm#loyee,

db,

ad7#en)ynamic,

dd'm#loyee,

db,

ad7#en)ynamic,

adLoc%7#timistic "f "s6ull/rs.+ields/0.5alue Then Tet1.Tet O 1 'm#id.Tet O 'MP100 Ttid.Tet O s1 'lse Tet1.Tet O 100 Tet1.Tet O 5al/rs.+ields/0  1 'm#id.Tet O 'm# Q 5al/Tet1.Tet 'nd "f 'm#id.Set+ocus rs.Close db.Close 'nd Sub

Pri$ate Sub ClerClic%/ clearform Me 'm#id.Set+ocus db.7#en rs.7#en

select

ma/'m#idfrom

adLoc%7#timistic "f "s6ull/rs.+ields/0.5alue Then Tet1.Tet O 1 Mar Thoma College of Science and Technology, yur.

=2


2011

'm#id.Tet O 'MP100 Ttid.Tet O s1 'lse Tet1.Tet O 5al/rs.+ields/0  1 'm#id.Tet O 'm# Q 5al/Tet1.Tet 'nd "f rs.Close db.Close 'nd Sub

Pri$ate Sub 'itClic%/ 8nload Me 'nd Sub

Pri$ate Sub +ormLoad/ connection db.7#en rs.7#en select de#name from de#artment, db, ad7#en)ynamic, adLoc%7#timistic 3hile 6ot rs.'7+ )e#.dd"tem rsVde#name rs.Mo$e6et 3end rs.Close db.Close db.7#en rs.7#en

select

ma/'m#idfrom

dd'm#loyee,

db,

ad7#en)ynamic,

adLoc%7#timistic "f "s6ull/rs.+ields/0.5alue Then Tet1.Tet O 1 'm#id.Tet O 'MP100 Ttid.Tet O s1 'lse Tet1.Tet O 5al/rs.+ields/0  1 Mar Thoma College of Science and Technology, yur.

=4


2011

'm#id.Tet O 'm# Q 5al/Tet1.Tet 'nd "f rs.Close db.Close 'nd Sub Pri$ate +unction Clear/ )im mc s Control +or 'ach mc "n Me.Controls "f Ty#e7f mc "s Teto 7r Ty#e7f mc "s Comboo Then mc.Tet O  'nd "f 6et mc 'nd +unction

Pri$ate Sub SearchClic%/ +orm<.Sho& 'nd Sub

Pri$ate Sub 8#dateClic%/ +orm=.Sho& 'nd Sub

Form=A&&aen&an/e."rm

)im a s String Pri$ate Sub ClerClic%/ clearform Me )at.Set+ocus 'nd Sub

Pri$ate Sub 'm#idClic%/ db.7#en rs.7#en select N from dd'm#loyee &here 'm#idO Q 'm#id Q , db, ad7#en)ynamic, adLoc%7#timistic Mar Thoma College of Science and Technology, yur.

=<


2011

"f rs.'7+ O True nd rs.7+ O True Then Msgo 6o 6ame +ound.... 'lse 6am.Tet O rsV6am 'nd "f rs.Close db.Close 'nd Sub


Pri$ate Sub +ormLoad/ connection db.7#en rs.7#en

select

distinct

/'m#id

from

dd'm#loyee,

db,

ad7#en)ynamic,

adLoc%7#timistic "f rs.'7+ O True nd rs.7+ O True Then Msgo 6o Records +ound.... 'lse 3hile 6ot rs.'7+ 'm#id.dd"tem rsV'm#id rs.Mo$e6et 3end 'nd "f rs.Close db.Close 'nd Sub

Pri$ate +unction Clear/ )im mc s Control +or 'ach mc "n Me.Controls Mar Thoma College of Science and Technology, yur.

==


2011

"f Ty#e7f mc "s Teto 7r Ty#e7f mc "s Comboo Then mc.Tet O  'nd "f 6et mc 'nd +unction

Pri$ate Sub Sa$eClic%/ db.7#en rs.7#en ddttendence, db, ad7#en)ynamic, adLoc%7#timistic rs.dd6e& rsV)at O )at.5alue rsVMonth O Month.Tet rsV'm#id O 'm#id.Tet rsV6am O 6am.Tet "f 7##res.5alue O True Then a O 7##res.Ca#tion 'lse"f 7#half.5alue O True Then a O 7#half.Ca#tion 'lse"f 7#cas.5alue O True Then a O 7#cas.Ca#tion 'lse"f 7#off.5alue O True Then a O 7#off.Ca#tion 'nd "f rsVtt O a rs.8#date Msgo ttendence Recorded.... Clear 'm#id.Set+ocus rs.Close db.Close 'nd Sub

Pri$ate Sub 8#dateClic%/ Mar Thoma College of Science and Technology, yur.

=>


2011

+ormD.Sho& 'nd Sub

Pri$ate Sub 5ie&Clic%/ +orm?.Sho& 'nd Sub

Form5SalaryCal/(la%on."rm

Pri$ate Sub )total9et+ocus/ )im e, f, g, h, i, * s "nteger a O 5al/)a.Tet b O 5al/-ra.Tet C O 5al/Ta.Tet d O 5al/7thers.Tet 'total.Tet O a  b  C  d 'nd Sub

Pri$ate Sub CalculateClic%/ )im tot, t, t1 s "nteger t O #.Ca#tion A 5al/)total.Tet t1 O #.Ca#tion  5al/'total.Tet tot O t  t1 'nd Sub

Pri$ate Sub ClearClic%/ clearform Me 'nd Sub

Pri$ate Sub )total9ot+ocus/ )im e, f, g, h, i, * s "nteger e O 5al/Pf.Tet f O 5al/'si.Tet g O 5al/Loan.Tet Mar Thoma College of Science and Technology, yur.

=?


2011

h O 5al/d$ance.Tet i O 5al/7ther.Tet * O 5al/6cl.Tet )total.Tet O e  f  g  h  i  * 'nd Sub

Pri$ate Sub 'm#idClic%/ db.7#en rs.7#en select N from dd'm#loyee &here 'm#idO Q 'm#id.Tet Q , db, ad7#en)ynamic, adLoc%7#timistic "f rs.'7+ O True nd rs.7+ O True Then Msgo 6o Records +ound..... 'lse 6am.Ca#tion O rsV6am Iob.Ca#tion O rsVIob #.Ca#tion O rsV# )e#.Ca#tion O rsV)e# 'nd "f rs.Close db.Close db.7#en rs.7#en S'L'CT C786T/tt from ttendance &here staffidO Q cmbid.Tet Q  6) statusOL and adate W Q dt#f.5alue Q W and adate U W Q dt#t.5alue Q W, db, ad7#en)ynamic, adLoc%7#timistic "f rs.+ields/0 O 0 Then Tet1.Tet O 0 Tet2.Tet O 0 'lse Tet1.Tet O rs.+ields/0 )im % s "nteger % O 5al/ttbsal.Tet F 2= "f 5al/Tet1.Tet  1 Then Tet2.Tet O % N /5al/Tet1.Tet A 1 'nd "f Mar Thoma College of Science and Technology, yur.

=D


2011

'nd "f 'nd Sub

Pri$ate Sub 'si9otfocus/ 'si O #.Ca#tion N '# F 100 'nd Sub

Pri$ate Sub 'total9ot+ocus/ )im a, b, C, d s "nteger a O 5al/)a.Tet b O 5al/-ra.Tet C O 5al/Ta.Tet d O 5al/7thers.Tet 'total.Tet O a  b  C  d 'nd Sub


Pri$ate Sub +ormLoad/ connection db.7#en rs.7#en

select

distinct

/'m#id

from

dd'm#loyee,

db,

ad7#en)ynamic,

adLoc%7#timistic "f rs.'7+ O True nd rs.7+ O True Then Msgo 6o Records +ound.... 'lse 3hile 6ot rs.'7+ 'm#id.dd"tem rsV'm#id rs.Mo$e6et 3end 'nd "f Mar Thoma College of Science and Technology, yur.

=B


2011

rs.Close db.Close 'nd Sub Pri$ate Sub 9s9ot+ocus/ )im , y s "nteger  O 5al/#.Ca#tion y O 5al/'total 9s.Tet O   y 'nd Sub

Pri$ate Sub -ra9ot+ocus/ -ra O #.Ca#tion N -# F 100 'nd Sub

Pri$ate Sub 6cl9ot+ocus/ 6cl O /#.Ca#tion F 40 N 6cld 'nd Sub

Pri$ate Sub 6cl$Clic%/ +orm?.Sho& 'nd Sub

Pri$ate Sub )a9ot+ocus/ )a O #.Ca#tion N )# F 100 'nd Sub

Pri$ate Sub Pf9ot+ocus/ )im Pf0, #f1, #f2 s "nteger Pf0 O 0 #f1 O #.Ca#tion N < F 100 #f2 O #f1 N 5al/P#.Tet F 100 Pf.Tet O #f2 'nd Sub Mar Thoma College of Science and Technology, yur.

>0


2011

Pri$ate Sub P#9ot+ocus/ )im Pf, #f1, #f2 s "nteger Pf O 0 #f1 O #.Ca#tion N < F 100 #f2 O #f1 N 5al/P#.Tet F 100 'nd Sub

Pri$ate Sub Sa$eClic%/ db.7#en rs.7#en SalaryCalculation, db, ad7#en)ynamic, adLoc%7#timistic rs.dd6e& rsV'm#id O 'm#id.Tet rsV6ame O 6am.Ca#tion rsVde#artment O )e#.Ca#tion rsV)ate O )at.5alue rsV)a O )a.Tet rsV-ra O -ra.Tet rsVTa O Ta.Tet rsV7thers O 7thers.Tet rsV'total O 'total.Tet rsVPf O Pf.Tet rsV'si O 'si.Tet rsVLoan O Loan.Tet rsVd$ance O d$ance.Tet rsVd7thers O 7thers.Tet rsV6olea$ O 6cld.Tet rsVlea$amt O 5al/6cl.Tet rsVnetsalary O )total.Tet rs.8#date rs.Close Msgo salary u#dated 'nd Sub Mar Thoma College of Science and Technology, yur.

>1


2011

Pri$ate Sub Ta9ot+ocus/ Ta O #.Ca#tion N T# F 100 'nd Sub

Pri$ate Sub Ti9ot+ocus/ )im #,  s "nteger # O 5al/9s.Tet  O 5al/)total.Tet Ti.Tet O # A  Ta#.Set+ocus 'nd Sub

Pri$ate Sub Ta9ot+ocus/ Ta.Tet O Ti.Tet N Ta# F 100 'nd Sub

Pri$ate Sub Ta9ot+ocus/ Ta.Tet O Ti.Tet N Ta# F 100 'nd Sub

Pri$ate Sub 5ie&Clic%/ +orm14.Sho& 'nd Sub

Frm&e0

Pri$ate Sub Command1Clic%/ db.7#en rs.7#en de#artment, db, ad7#en)ynamic, adLoc%7#timistic rs.dd6e& rsVde#code O ttdcode.Tet rsVde#name O ttdname.Tet rsVde#head O ttdhead.Tet Mar Thoma College of Science and Technology, yur.

>2


2011

rs.8#date Msgo )T S5') rs.Close db.Close 'nd Sub

Pri$ate Sub Command2Clic%/ ttdcode.Tet O  ttdname.Tet O  ttdhead.Tet O  'nd Sub

Pri$ate Sub Command4Clic%/ 8nload Me 'nd Sub

Pri$ate Sub +ormLoad/ connection 'nd Sub


>4


2011

INPUT SCREENS F%r! Page

Log%n Form


><


2011

Ma%n Form


>=


2011

Reg%!ra%on o" Ne U!er


>>


2011

U0&ae U!er


>?


2011

A&& De0armen Dea%l!


>D


2011

Sear/# De0armen &ea%l!


>B


2011

E&% De0armen Dea%l!


?0


2011

A&& Em0loyee Dea%l!


?1


2011

Sear/# Em0loyee Dea%l!


?2


2011

U0&ae Em0loyee Dea%l!


?4


2011

A&& Aen&an/e Dea%l!


?<


2011

+%e Aen&an/e Dea%l!


?=


2011

U0&ae Aen&an/e Dea%l!


?>


2011

Salary Cal/(la%on


??


2011

+%e Salary Dea%l!


?D


2011

U0&ae Salary Dea%l!


?B


2011

Pay !l%0


D0


2011

OUTPUT SCREENS

Em0loyee &ea%l!


D1


2011

Aen&an/e &ea%l!


D2


2011

Salary &ea%l!


D4


2011

BIBLIOGRAPHY


D<

Payroll Management System

Recommend Documents