Task $1$

Draw and present a dependency diagram for the table above, including transitive dependencies. In your oral presentation, you need to explain each dependency.

Task $2$

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. Orally 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$

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 $4$

If the resulting table from the previous task is not in the third normal form, normalise it so that it is in the third normal form. You may create additional tables. Orally present your solution and the reason why it was not in the third normal form, as well as the changes that were made to turn it to the third normal form. If the resulting table from the previous task is already in the third normal form, explain why it is in the third normal form.

Task $5$

Based on the resulting table from the previous task, draw and present an ERD to the audience. Please use LucidChart or an equivalent professional diagramming software application to draw the ERD. $2.$ When completing this assessment, you are required to make reasonable assumptions based on common sense if it has not been explicated int the scenario. Length and Layout of the Presentation The total presentation should be no more than $6$ minutes. Please prepare this presentation using Microsoft PowerPoint