Huffman Trucking Database The driving log has been split into 11 tables. The database is in third normal form or Boyce Codd Normal Form (BCNF) (Pratt & Adamski, 2005, p. 153). This level of normalization ensures that there are no repeating groups, that no key column depends on only part of the primary key, and that the only determinants contained are the candidate keys. The company has four locations in the United States and serves 925 drivers. Normalization to third normal form is sufficient due to the relatively small database, the number of daily updates, and the nature of the information. The database is searchable and, thanks to the naming methodology, is platform independent. Care was taken to omit reserved words from the major databases: Oracle, Sybase, MySQL, PostgreSQL, and DB2 (Box, 2004). An entity relationship diagram for the database is shown in Figure 1. Figure 1. ERD Driving Log The states table was created to create a drop-down list field to select a state from a list during data entry in the database. The state field is pre-populated with all states in the union and is linked to the violations table and driver tables. The Violations Chart was created to document driving violations of local and state laws. The date of the complaint, the nature of the offense, the status of the incident (linked to the status table), the municipality in which it was committed, the status of the complaint, the disposition and guidance points deducted from the form are stored here of the driver. The restrictions field has been added to allow the employer to be notified when a driver exceeds the allowable points on their record and may be suspended from driving. The employee table has the name, employee ID number, status (connected... ... middle of document ......exam. A restrictions field has been added to allow staff to Huffman Trucking to enter any driving restrictions the driver may have due to the test results. The database was created to facilitate information sharing between the truck driver and the company. The database will also allow truck drivers to update data. database while on the road using the Internet. This practice will allow the company to maintain near real-time updates on the status of truck drivers' driving records and will allow them to ensure compliance with local and federal laws. References Pratt, P.J. and Adamski, JJ (. 2005). Database Design 1: Normalization. MacMendelsohn (ed.), Database Management Concepts (5th ed., USA: Thomson.Box, D. (2004, April 29). SQL API portability. Retrieved August 16, 2008, from http://home.fnal.gov/~dbox/SQL_API_Portability.html