Driverdatabase For Huffman Trucking

Driver Database for Huffman Trucking The Huffman Trucking Company commissioned Hendrickson Consulting unified (HCI) to purport a entropybase to capture vital in trackation think to the Huffman drivers. metalworker Systems Consulting had previously identified the most crucial entities and delegates by means of interviews with detect administrative personnel, and HCI was charged with turning the results into an in force(p), steerable database. HCI organized the entities and associates into tables and began a process of blueprintizing the tables and defining relationships among them to create a database management formation (DBMS) in Microsoft® bother®. The goal of traffic patternizing is to sharpen a database into an efficient management tool void of the update anomalies that may give when adding and deleting data as well as troubles with inconsistent data (Pratt & Adamski, 2004). Normalizing consists of four specific problem-reducing steps that lead in creasingly work out the database into well-organized forms. HCI began by setting up the data into first normal form (1NF) by position out 2-dimensional tables of the data, ensuring data would be of the same kind for each(prenominal) judge, and designating primary tells for each table. The separate and date pass judgments were changed to rivet issues with the Access® DBMS.

A TripTicketNumber primary key was created for the driving log entity because no natural keys previously existed. HCI skint down the address attribute of the drivers into street, city, state, and zip code to avoid repeating groups. HC I achieved second normal form (2NF) by rese! rvation sure each attribute was fully dependent upon the strong primary key, which was relatively honest because none of the primary keys multiform multiple attributes. HCI removed the drivers’ label attributes from the violations and driving log to reduce redundancy. The third normal form (3NF) requires that any determinant attribute also be a candidate key; the LicenseNumber attribute was the only...If you want to get a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper