Task A1a
, Task
Second normal form requires that the entities be in first normal form and all non-key
attributes are functionally dependent on the entire primary key. To accomplish this, I split this
example from one table into three separate relations of Orders, OrderItem and Donut.
Donut_Name, Donut_Description and Unit_Price now all fully depend on DonutID instead of
DonutID and CustomerID.
, Task
Second normal form requires that the entities be in first normal form and all non-key
attributes are functionally dependent on the entire primary key. To accomplish this, I split this
example from one table into three separate relations of Orders, OrderItem and Donut.
Donut_Name, Donut_Description and Unit_Price now all fully depend on DonutID instead of
DonutID and CustomerID.
