Ntity Relationship Diagram and Table Definition
Resources: Huffman Trucking Virtual Organization
Review the information currently housed in Huffman Truckings database, in the Entities and Attributes for Fleet Truck Maintenance file on the virtual Organizations site.
Create a Microsoft Visio ERD, based on the relations in the Entities and Attributes for Fleet Truck Maintenance file and any additional information needed to normalize the database. 1)notate primary keys in each table with solid underlining 2) notate foreign keys in each table with dashed underlining 3)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.