normalization
Apply the normalization rules to the following Form, which show the data to be recorded in a
database. All intermediate steps (UNF, INF, 2NF, and 3NF) should be shown in detail. State
any assumptions that you make.
Please complete the following FOUR (4) parts:
i) Based on Figure 2, write down the unnormalized form.
ii) Identify the repeating group of attributes and transform part (i) into tables that are in 1st normal form. (Explain the rationale for your decision).
iii) Identify any partial dependencies in part (ii) and transform into tables that are in 2nd Normal Form. (Explain the rationale for your decision).
iv) Identify any transitive dependencies in part (iii) and transform into tables that are in
3rd Normal Form. (Explain the rationale for your decision).
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
