Driverdatabase For Huffman Trucking

Driver Database for Huffman Trucking The Huffman Trucking Company commissioned Hendrickson Consulting incarnate (HCI) to purport a entropybase to capture vital in regulateation connect to the Huffman drivers. metalworker Systems Consulting had previously identified the most crucial entities and delegates done 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® chafe®. The goal of approach patternizing is to hone 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 forget 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 distributively specify, and designating primary tells for each table. The separate and date ascribes 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 candid because none of the primary keys multiform multiple attributes. HCI removed the drivers’ names 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