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.