Question: Task 3 (15 marks) If the resulting table from the previous task is not in the second normal form, normalise it so that it is

Task 3 (15 marks) If the resulting table from the previous task is not in the second normal form, normalise it so that it is in the second normal form. You may create additional tables. Orally present your solution and the reason why it was not in the second normal form, as well as the changes that were made to turn it to the second normal form. If the resulting table from the previous task is already in the second normal form, explain why it is in the second normal form. Task 3 (15 marks) If the resulting table from the previous task is not in the second normal form, normalise it so that it is in the second normal form. You may create additional tables. Orally present your solution and the reason why it was not in the second normal form, as well as the changes that were made to turn it to the second normal form. If the resulting table from the previous task is already in the second normal form, explain why it is in the second normal form
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
