Entity Relationship Diagram and Table Definition

American History X Derek Vinyard Caste Study from a Psychological point of view.discuss
August 4, 2017
Fitzroy Court costing individual assignment brief
August 4, 2017
Show all

Entity Relationship Diagram and Table Definition

Entity Relationship Diagram and Table Definition

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.
a.Create a Microsoft Visio ERD, based on the relations in the Entities and Attributes for Fleet Truck Maintenance file

b. notate foreign keys in each table with dashed underlining

c.notate new attributes that do not exist in the existing database with italic font.

d.create normalized tables in a Microsoft Word document or a Microsoft Excel spreadsheet for the fleet truck maintenance database.

e.Indicate primary keys, foreign keys, and new attributes as in the entity relationship diagram.

 

Leave a Reply

Your email address will not be published. Required fields are marked *