DB1

profilepriyanak412

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.

    • 9 years ago
    • 10
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      huffman_trucking_virtual_organization.doc
    Bids(1)