CS Normalization Answer Sheet 1 PDF

Preview

Summary

Dimensional modeling...

Description

Jishnu Narasimha Moorthy Zhanfei Lei OIM 350 CS: Normalization Answer Sheet Please answer the questions below: a) Does the table above meet the definition of 1NF? What is the primary key? - This table does meet the definition of 1NF. The primary keys in this table are ProductID and ShipmentID

b) Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the SHIPMENTS table ShipmentID -

-

ShipmentDate TruckID

TruckType

ProductID

ProductType

Quantity

Partial Functional Dependencies: o ShipmentID -> ShipmentDate, TruckID, TruckType o ProductID -> ProductType Full Key Functional Dependencies: o ShipmentID, ProductID -> Quantity Transitive Functional Dependencies: o TruckID -> TruckType

c) Normalize the SHIPMENTS Table to 2NF and show the resulting tables (with functional dependencies) ShipmentID

ShipmentDate

ShipmentID

ProductID

ProductID

ProductType

TruckID

Quantity

TruckType

d) Normalize the SHIPMENTS Table to 3NF and show the resulting tables (with functional dependencies)

ShipmentID

ShipmentDate

ShipmentID

ProductID

ProductID

ProductType

TruckID

TruckType

TruckID

Quantity

e) Draw a relational schema for the resulting tables, after the tables are in 3NF -

*Note:

 

For questions b-d, you can use WORD to draw the tables with functional dependencies For question e, please use ERD Plus to draw a relational schema, and export and copy the image into your answer sheet....