In this exercise, you have been handed a second draft of the database design for Stories on CD, written as a single relation.
Your job is to identify the correct relations, identify the functional dependencies, and write those dependencies down in the proper notation.
For simplicity, assume that each order contains only one CD and that each CD is only available from a single distributor.
Working with the relations below, complete the following tasks:
Ensure the relation is in 1NF by identifying repeating groups and breaking them out into their own relations.
Identify the functional dependencies in the relation.
Use the functional dependencies to construct new relations.
CD (CDNo, Title, Price, CategoryNo, CategoryName,
DistID, OrderNo, OrderDate, OrderCost, Received)
Distributor (DistID, DistName)
Type or paste your responses to the tasks above into the text box below, then click Submit.