you learnt data models and relational data modelling. Next, you were introduced to the database table normalisation process in Module 3.1, which is aimed to enhance the quality of database tables.

Assignment Task

Task Summary

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

Context

In the first two modules, you learnt data models and relational data modelling. Next, you were introduced to the database table normalisation process in Module 3.1, which is aimed to enhance the quality of database tables. Normalisation plays a significant role in ensuring database tables are well structured so that both data redundancies and the likelihood of data anomalies can be minimised. By completing this assessment, you will demonstrate your understanding of the following:

(1) the database table normalisation process and

(2) the criteria for database tables to be in 1NF, 2NF and 3NF

as well as your ability to:

(1) comprehend business rules and logic to determine data dependencies,

(2) perform database table normalisation process and normalise database tables up to 3NF and

(3) articulate your solutions and the rationale to an audience.

Task Instructions

Fiction University has several parking spaces allocated to students for parking at the university. All vehicles parked in the university car parks between 8:00 am to 6:00 pm Monday to Friday inclusive, are required to register the vehicle and have a valid parking permit/ticket. Parking penalties are applied according to the parking regulations governing Parking and Traffic management regulations of the university, and any unlawful parking or traffic rules violations will incur fines/penalties by issuing a ticket. The fines depend on the nature of the offence. For example, some of the car parks have time limits displayed on signages, and vehicles parked longer than the indicated time may incur a fine of $50 for the offence. Likewise, parking penalties may also be issued for violation of parking regulations such as obstructive and dangerous parking. If multiple offences arise from one incident, a parking ticket may comprise multiple fines, and each fine rate for each offence depends on the type of offence.