DB1

Resources: Huffman Trucking Virtual Organization

Review the information currently housed in Huffman Trucking’s database, in the Entities and Attributes for Fleet Truck Maintenance file on the virtual Organizations site.

Create a Microsoft^® Visio^® entity-relationship diagram (ERD), based on the relations in the Entities and Attributes for Fleet Truck Maintenance file and any additional information needed to normalize the database.

• Notate primary keys in each table with solid underlining.
• Notate foreign keys in each table with dashed underlining.
• Notate new attributes that do not exist in the existing database with italic font.

Create normalized tables in a Microsoft^® Word document or a Microsoft^® Excel^® spreadsheet for the fleet truck maintenance database. Indicate primary keys, foreign keys, and new attributes as in the entity relationship diagram.