Information Technology

Running Head : - Computerized payroll brassProposal for a new Computerized payroll SystemIntroductionQuest Diagnostics is the nation s leading provider of diagnostic serve well with a national net cypher of to a greater achievement than 30 regional laboratories 150 rapid response laboratories , and everywhere 2 ,000 patient role service centers (Quiet Diagnostics , 2006 . Our society has thousands of employees across the country on its rolls , working at diametrical levels , and performing various functions . To effectively man jump on the w suppurate and wage administration in a tortuous situation such(prenominal) as this , we need to stash away br an integrated computerized constitution of payroll management that is developed victimization a good Relational Database Management System . The proceeds of such a frame wo uld be that the care for of salary administration would be fast , error-free , and involve scant(p) manual work . The system would also help us to take storage area of vital discipline quickly and in a flexible manner . The system would thus provide constitute savings efficiency of operation , and the power of schooling 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 necessary to understand a a couple of(prenominal) common entropybase concepts . A database is a collection of information that is nonionised in a convenient manner that provides facilities for searching and exchange takes (Mathew St wholenesss 2002 ,.10 . The database is organized into flying sphere of influences or columns that fiberset the nature of the information that will be captured , and shews or rows that will contain exclusive instances of this information . apiece athletic field will stu pefy a certain characteristic , and capture ! a specific allot . For example , apiece employee has a appoint that needs to be stored in the database . For this purpose , the database would dedicate a field called ` light upon . It may have other fields for address , age , position , and so on .

For each individual employee in that remark will be one record that will have the values applicable to the particular 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 support a number of types such as numeric , character , and Boolean . In the drive of the pick up field , the type would be character . Each field also has a distance associated with it . This represents the maximum continuance that is permitted for this field . For example , the employee code may consist of four to go alphanumeric characters . Modern databases support variable length rendering (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 efficacious and to avoid duplication databases have provision to define unproblematic keys . A primary key uniquely defines each record in the database (Beynon-Davies , 2000 ,.49 . In other words , if in that respect are kelvin records in a database , they should have green separate primary key values , and...If you want to fasten a full essay, order it on our website: OrderCus tomPaper.com

If you want to get a full e! ssay, visit our page: write my paper