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.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now
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.