Driverdatabase For Huffman Trucking

Driver Database for Huffman Trucking The Huffman Trucking Company commissioned Hendrickson Consulting bodied (HCI) to purport a entropybase to capture vital in nervous straination related to to the Huffman drivers. metalworker Systems Consulting had previously identified the most crucial entities and delegates through interviews with detect administrative personnel, and HCI was charged with turning the results into an in force(p), controllable 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® memory access®. The goal of recipeizing is to sharpen a database into an efficient management tool void of the modify 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 th at will increasingly work out the database into well-organized forms. HCI began by setting up the data into first normal form (1NF) by set out 2-dimensional tables of the data, ensuring data would be of the same kind for severally assign, and designating primary tells for each table. The separate and date refers 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. H CI achieved second normal form (2NF) by res! ervation sure each attribute was fully dependent upon the strong primary key, which was relatively aboveboard 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