Performing Tables Normalisation in a PowerPoint Presentation

In this assessment, you are required to perform database table normalisation and present your solutions in a PowerPoint presentation. In doing so, you are required to demonstrate your work and solution through a series of normal forms. You need to first normalise the database tables to the first normal form (1NF), then the second normal form (2NF), and finally the third normal form (3NF).

1. Examine the following student table, which is used for a student record management system in an Australian university.
   
   

2. Please complete the following tasks and deliver a 5?minute presentation to communicate your answers/solutions to an audience.

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

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.

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

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.

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.

When completing this assessment, you are required to make reasonable assumptions based on common sense. For example, the following are considered as common sense or reasonable assumptions:

Two persons may have the same name, that is, the same first name AND same last name.

Two persons who were born on the same day may have the same name. A student will undertake more than one subject at a university.

More than one subject may be taught by one lecturer. Each subject has only one subject name.

Each School only has one Head of School.