Question: Derive a set of relations in third normal form (3NF), using the data shown in the picture below. Clearly show each step of normalisation 1NF,
Derive a set of relations in third normal form (3NF), using the data shown in the picture below.
Clearly show each step of normalisation 1NF, 2NF and 3NF in the answer.
Remember to show all primary keys in each relationship with a solid underline and foreign keys with a dashed underline or with clear labels. May add attributes as needed before starting the process if explain them clearly. State assumptions if needed.

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
