The following is the relation notation of a database table in 1NF ORDER(CustNum, CustFN, CustLN, OrderNum, OrderDate, ProdNum, ProdDesc, Qty, UnitPrice) The functional dependencies are given below: CustNum → CustFN, CustLN OrderNum - OrderDate, CustNum, CustFN, CustLN ProdNum → ProdDesc OrderNum, ProdNum -> UnitPrice, Qty Use the functional dependencies above to answer the following questions. Don't not make additional assumptions and functional dependencies. A. List all partial dependencies in the relation only (if any) using the dependency numbers. Don't write the dependencies in X->Y format, just indicate their numbers (which are listed on the left side, i.e., 1, 2, 3, 4). Indicate only the dependencies that you think are partial. B. Identify and show the 2NF. Show primary keys and foreign keys references. Use relational notation (show references). Write down all relations and their references below. C. List all transitive dependency in your answer to question b (if any) using the dependency numbers. Don't write the dependencies in X->Y format, just indicate their numbers (which are listed on the left side, i.e., 1, 2, 3, 4). Indicate only the dependencies that you think are transitive. D. Identify and show 3NF (show all relations, including the new ones and those unchanged from 2NF). Show primary and foreign keys references. Use relational notation. Write all relations and their references.
The following is the relation notation of a
ORDER(CustNum, CustFN, CustLN, OrderNum, OrderDate, ProdNum, ProdDesc, Qty, UnitPrice)
The functional dependencies are given below:
- CustNum → CustFN, CustLN
- OrderNum - OrderDate, CustNum, CustFN, CustLN
- ProdNum → ProdDesc
- OrderNum, ProdNum -> UnitPrice, Qty
Use the functional dependencies above to answer the following questions. Don't not make additional assumptions and functional dependencies.
A. List all partial dependencies in the relation only (if any) using the dependency numbers. Don't write the dependencies in X->Y format, just indicate their numbers (which are listed on the left side, i.e., 1, 2, 3, 4). Indicate only the dependencies that you think are partial.
B. Identify and show the 2NF. Show primary keys and foreign keys references. Use relational notation (show references). Write down all relations and their references below.
C. List all transitive dependency in your answer to question b (if any) using the dependency numbers. Don't write the dependencies in X->Y format, just indicate their numbers (which are listed on the left side, i.e., 1, 2, 3, 4). Indicate only the dependencies that you think are transitive.
D. Identify and show 3NF (show all relations, including the new ones and those unchanged from 2NF). Show primary and foreign keys references. Use relational notation. Write all relations and their references.
Step by step
Solved in 3 steps with 4 images
