Huffman Trucking DatabaseThe driving log has been divided into 11 tables. The database is in third normal form or Boyce Codd normal form (BCNF) (Pratt and Adamski, 2005, p. 153). This level of normalization guarantees the absence of repetitive groups, no key column depends on a single part of the primary key and 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, due to the naming methodology, is platform independent. Care was taken to omit reserved words from the main 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 state table was created to create a drop-down list field for selecting a state from a list when entering data into the database. The State field is pre-populated with all states in the union and is connected to the Violations table and Driver tables. The Violations Table was created to document violations of local and state driving laws. The date of the citation, the nature of the offense, the state of the event (linked to the state table), the municipality where the citation was committed, the status of the citation, and the decision and points driving charges deducted from the driver's record are kept here. The restrictions field was added to allow the employer to be alerted when a driver exceeds the points allowed on their record and may be suspended from driving. The employee table contains the name, employee ID permit number, state (related to s... ... middle of sheet ...... exam. A field of restrictions was added to allow Huffman Trucking personnel to capture any possible driving restrictions the driver may have due to the test results. The database was created to facilitate information sharing between the trucker and. The database will also allow truckers to update the database while on the road using the Internet. This practice will allow the company to maintain near real-time updates. status of truckers' driving log to ensure compliance with local and federal laws.ReferencesPratt, PJ and Adamski, JJ (2005). ., p. 153). SQL API portability. Retrieved August 16, 2008 from http://home.fnal.gov/~dbox/SQL_API_Portability.html