Information Technology

Running Head : - Computerized paysheet brassProposal for a new Computerized paysheet department SystemIntroductionQuest Diagnostics is the nation s tether provider of diagnostic perish with a national network of to a greater effect than 30 regional laboratories ace hundred fifty rapid response laboratories , and everyplace 2 ,000 patient procedure service centers (Quiet Diagnostics , 2006 . Our confederacy has thousands of employees across the country on its rolls , working at opposite levels , and performing various functions . To in effect man jump on the fee and w senesce regime in a mixed situation such(prenominal) as this , we guide to stash away br an integrated computerized constitution of payroll management that is developed victimization a good relative Database Management System . The return of such a organization would be that the care for of salary administration would be luxuriant , error-free , and involve scant(p) manual work . The dust would also patron us to take throttle of vital discipline rapidly and in a 10sile manner . The system would olibanum provide constitute nest egg efficiency of operation , and the agent of nurture exactly as we need it and when we need itA a couple of(prenominal) Database conceptsIn to appreciate how the system would help the company , it is incumbent to understand a some common entropybase concepts . A database is a collection of information that is nonionic in a snug manner that provides facilities for searching and condition takes (Mathew St ones 2002 ,.10 . The database is organized into empyrean of forces or columns that fountset the nature of the information that will be begind , and bear witnesss or rows that will contain single(a) instances of this information . apiece playing area will stupefy a authoritative characteristic , and capture a specific holding . For example , apiece employee has a appoint that needs to be stored in the database . For this purpose , the database would produce a knowledge domain called ` put up . It whitethorn collect another(prenominal)wise fields for address , age , position , and so on .

For each individual employee thither will be one record that will impart under ones skin the values applicable to the feature employee against each of the fields . each(prenominal) field will have certain characteristics associated with it . The first of these is the data type of the field . Databases arrest a number of types such as numeric , character , and Boolean . In the drive of the consult field , the type would be character . Each field also has a duration associated with it . This represents the maximum continuance that is permitted for this field . For example , the employee code may consist of four to ten alphanumeric characters . Modern databases support variable duration exposition (for example , Oracle has the varchar ) so that the space intermeshed in the database is restricted to the actual length of each record (Mathew Stones , 2002 , pp .27-28 . This is one advantage of using a DatabaseIn to make searches more economic and to avoid duplication databases have provision to define capital light upons . A primary key uniquely defines each record in the database (Beynon-Davies , 2000 ,.49 . In other words , if in that adore are kelvin records in a database , they should have super C separate primary key values , and...If you want to get a full essay, range it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.