In: Computer Science
Determine the Functional Dependencies that exist in the following Orders table. This table lists customer and order data.
Orders (SupplierNum, SupplierName, Supp_Phone, ProductNum, Description, Product_type, QuotedPrice) .
Normalize the above relation to 3 rd normal form, ensuring that the resulting relations are dependency-preserving and specify the primary keys in the normalized relations by underlining them.
Orders (SupplierNum, SupplierName, Supp_Phone, ProductNum, Description, Product_type, QuotedPrice)
Here,
=> SupplierNum, ProductNum is the primary key of Orders table.
Since SupplierNum and ProductNum individually determines some attributes, the orders table is not in 2NF.
To make it into 2NF, we split the table
Now, we need to check the above tables are in 3NF (there should not be any transitive dependencies)
The above tables don't have any transitive dependencies, all are in 3NF.
Dependencies are also preserved.