UoP DBM 502 Week 2 Individual Assignment - 28396

Solution Posted by
kingaries

kingaries

Rating : (11)A
Solution Detail
Price: $14.00
  • From: Computer Science,
  • Posted on: Sun 13 Oct, 2013
  • Request id: None
  • Purchased: 2 time(s)
  • Average Rating: No rating
Request Description

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®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.

Solution Description

See word att

Attachments
WEEK 2 INDIVIDUAL.docx
WEEK 2 INDIVIDU...