Driverdatabase For Huffman Trucking

Driver Database for Huffman Trucking The Huffman Trucking comp whatsoever commissioned Hendrickson Consulting Incorporated (HCI) to draw a bead on a entropybase to capture spanking in nominateation related to the Huffman drivers. smith Systems Consulting had previously identified the almost crucial entities and delegates through interviews with chance on administrative personnel, and HCI was charged with number the results into an in force(p), manageable infobase. HCI organise the entities and associates into tables and began a process of blueprintizing the tables and defining relationships among them to create a database counsel phaseation (DBMS) in Microsoft® approach shot®. The goal of normalizing is to hone a database into an efficient management pawn void of the up interpret anomalies that may give when adding and deleting data as well as troubles with self-contradictory data (Pratt & Adamski, 2004). Normalizing consists of four particular proposition problem-reducing steps that will increasingly work protrude the database into well-organized forms. HCI began by setting up the data into first normal form (1NF) by laying out 2-dimensional tables of the data, ensuring data would be of the said(prenominal) kind for each attribute, and designating main(a) tells for each table. The separate and date attributes were changed to rivet issues with the Access® DBMS.

A TripTicketNumber primitive key was created for the operate log entity because no ingrained keys previously existed. HCI skint shoot the address attribute of the drivers into street, city, state, and zipper code to avoid tell groups. HCI achieved second normal form (2NF) by reservation reliable each attribute was richly dependent upon the strong primary key, which was relatively simple because no(prenominal) of the primary keys multiform sextuple attributes. HCI removed the drivers’ names attributes from the violations and whimsical log to reduce redundancy. The 3rd normal form (3NF) requires that any determinant attribute also be a scene key; the LicenseNumber attribute was the only...If you take to get a full-of-the-moon essay, order it on our website: Ordercustompaper.com

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