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.
Examine the following PARKING FINE table used by the Fiction University to record parking violations committed. These fines are recorded typically as below:

StID

StudName

PhoneNo

Course

School

LicNo

LicCat

LicDesc

TicketNo

TicketDate

OffenceCode

OffenceDesc

Fine

A00020

Thomas Brown

040124886

BBIS

BUS

BRY123

P

Prov

15634

10/10/2019

4

No Valid Parking permit

40

2

Overstaying allotted time

50

A00049

Gurdeep Singh

040124234

MBIS

BUS

TRE142

F

Full

14984

23/10/2021

3

Parking on disability parking space

100

1

Parking on parking restricted area

150

A00040

Fiona James

040456234

MIT

Science & Eng

TRE176

F

Full

14997

22/03/2020

4

No Valid Parking permit

40

A00044

Rudy Deco

040896245

MIT

Science & Eng

TRE179

P

Prov

14999

22/03/2021

2

Overstaying allotted time

50

A00020

Thomas Brown

040124886

BBIS

BUS

BRY123

P

Prov

15639

10/10/2020

3

Parking on disability parking space

100

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

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 (30 marks)
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 (15 marks)
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.

1. 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. This includes a 5-minute question­and-answer session. • Please prepare your presentation using Microsoft PowerPoint.
Note: The LF may ask you to do a video recording of the presentation instead of a class presentation.
Submission Instructions
Please submit ONE PowerPoint Presentation (.ppt or .pptx) via the Assessment 2 section found in the main navigation menu of the subject’s Blackboard site. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
Referencing
It is essential that you use appropriate APA style for citing and referencing research. Please see more information on referencing in the Academic Skills webpage.
Academic Integrity

When submitting their assessment task, students will be asked to declare the academic integrity of their assessment by completing and signing an assignment cover sheet. You can find the assignment cover sheet here

All students are responsible for ensuring that all work submitted is their own and is appropriately referenced and academically written according to the Academic Writing Guide. Students also need to have read and be aware of Torrens University Australia Academic Integrity Policy and Procedure and subsequent penalties for academic misconduct. These are available at https://www.torrens.edu.au/policies-and-forms.
Students also must keep a copy of all submitted material and any assessment drafts. Special Consideration
To apply for special consideration for a modification to an assessment or exam due to unexpected or extenuating circumstances, please consult the Assessment Policy for Higher Education Coursework and ELICOS and, if applicable to your circumstance, submit a completed Application for Assessment Special Consideration Form to your Learning Facilitator. Assessment Rubric

Marking Criteria	F	P	C	D	HD
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 1 Draw and present a dependency diagram including transitive dependencies. Explain each dependency in the presentation.
15%
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 2 Normalise the table to be in the first normal form, if it is not already in the first normal form. Discuss the solution and explain the reasons as to why the table was not in the first normal form, and what changes were made to turn it into the first normal form in the oral presentation.  If the table is in the first normal form, explain why it is in the first normal form.
5%

Subject Learning Outcome: a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 3 > Normalise the table to be in the second normal form, if it is not already in the second normal form. > Discuss the solution and explain the reasons as to why the table was not in the second normal form, and what changes were made to turn it into the second normal form in the oral presentation. > If the table is in the first normal form, explain why it is in the first normal form.
15%
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 4 > Normalise the table to be in the third normal form, if it is not already in the third normal form. > Discuss the solution and explain the reasons as to why the table was not in the third normal form, and what changes were made to turn it into the third normal form in the oral presentation. > If the table is in the third normal form, explain why it is in the third normal form.
30%

Subject Learning Outcome: a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data. Task 5 Draw and present an ERD base to the audience.
Use LucidChart or an equivalent professional diagramming software application to draw the ERD
15%
Subject Learning Outcome:
d) Apply and communicate the database solutions for specialist and non-specialist stakeholders.
Effective Communication
Ability to engage the audience.
Clarity, pace and fluency.
Clear and logical structure of the oral presentation.
20%