Review the information currently housed in Huffman Trucking%u2019s database, in the Entities and Attributes for Fleet Truck Maintenance file on the virtual Organizations site. (Customers, facilities, employees, and capital)
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.
• 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.
There are 2 parts to this. I will give maximum points to anyone who completes them all. Half points for each part.