Is this relation in 1NF? If not, transform this relation into 1NF. (b) (15 points) Identify functional dependencies in the following relation, and identify which of functional dependencies is/are partial functional dependency and which of functional dependencies is/are transitive functional dependency. Purchase BG-ID BG-Name Inventory Level SafeStockLevel PurchascID Quantity UnitPrice CustomerEmail CustomerName (c) (10 points) Is the relation in Part (b) in 3NF? If not, transform the relation into a relational model in/3NE.

 

Transcribed Image Text:

Suppose that some one puts all data in the following E-R model for the bakery from Exam1 in a relation below. ID Name BakingGood InventoryLevel SafeStockLevel quantity Contain UnitPrice 13 -0 < Purchase ID Have Name Customer EmailAddress Purchase BG-ID BG-Name InventoryLevel SafeStockLevel PurchaseID Quantity UnitPrice CustomerEmail CustomerName Suppose that some one puts all data in the following E-R model for the bakery from Exam1 in a relation below. ID Name BakingGood InventoryLevel SafeStockLevel quantity Contain UnitPrice 13 -0 < Purchase ID Have Name Customer EmailAddress Purchase BG-ID BG-Name InventoryLevel SafeStockLevel PurchaseID Quantity UnitPrice CustomerEmail CustomerName