Task 1 (15 marks) Draw and present a dependency diagram for the table above, including transitive dependencies. In your written presentation, you need to explain each dependency. Task 2 (5 marks) If the table above is not in the first normal form, normalise it so that it is in the first normal form without creating any more tables. You may create an additional attribute or attributes. Present your solution and the reason why it was not in the first normal form, and what changes were made to make it in the first normal form. If the table above is in the first normal form, explain why it is in first 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 without creating any more tables. You may create an additional attribute or attributes. 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 1 (15 marks) Draw and present a dependency diagram for the table above, including transitive dependencies. In your written presentation, you need to explain each dependency. Task 2 (5 marks) If the table above is not in the first normal form, normalise it so that it is in the first normal form without creating any more tables. You may create an additional attribute or attributes. Present your solution and the reason why it was not in the first normal form, and what changes were made to make it in the first normal form. If the table above is in the first normal form, explain why it is in first 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 without creating any more tables. You may create an additional attribute or attributes. 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