Which structure normalizes the following order Table?
| Order No | Order Date | Recipient | goods | quantity | unit price | total amount |
|---|
| 1 | 00/10/01 | A | S
T | 3
2
| 1,000
950 | 4,900 |
| 2 | 00/10/01 | B | S
U
V
| 1
10
5
| 1,000
1,200
1,800
| 22,000 |
| 3 | 00/10/02 | B | T | 8 | 950 | 7,600 |
| 4 | 00/10/02 | C | U | 25 | 1,200 | 30,000 |
| ： | ： | ： | ： | ： | ： | ： |
A
| Order No | Order Date | Recipient | total amount |
|
|
|
B
| Order No | Order Date | Recipient | total amount |
|
|
|
C
| Order No | Order Date | Recipient | total amount |
|
|
|
D
| Order No | Order Date | Recipient | total amount |
|
|
|
Answer
A
| Order No | Order Date | Recipient | total amount |
|
|
|
Explanation
Step1 Eliminate repetitive groups.。
The repeating groups are GOODS, QUANTITY, UNIT PRICE, and so on. Let's split them into separate tables. To avoid losing relationships when doing so, we will split them together with their dependent keys.
| Order No | Order Date | Recipient | total amount |
| Order No | goods | quantity | unit price |
Step2 Split the item to which the partial function is subordinated into a separate Table.
The unit price of GOODS is functionally dependent on GOODS, right? So let's split it.
| Order No | Order Date | Recipient | total amount |
Step3 Split transitive functional dependencies.
There is no transitive function dependence here, so we are done.