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.

"Is this question part of your assignment? We can help"

ORDER NOW