Demostrate

$1)$ the database table normalisation process and

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

As well as

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

$2)$ perform database table normalisation process and normalise database tables up to $3$NF 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$:$00pm$ 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:

$\backslash$table$[[$StID$,$StudName,PhoneNo,Course,School,LicNo,LicCat,LicDesc,TicketNo,TicketDate,OffenceCode,OffenceDesc,Fine$],[$A$00020,\backslash$table$[[$Thomas$],[$Brown$]],040124886,$BBIS,BUS,BRY$123,P,$Prov,$15634,\frac{10}{10}\frac{?}{2019},4,\backslash$table$[[$No Valid Parking$],[$permit$]],40],[,,,,,,,,,2,\backslash$table$[[$Overstaying$],[$allotted time$]],50],[$A$00049,\backslash$table$[[$Gurdeep$],[$Singh$]],040124234,$MBIS,BUS,TRE$142,$F$,$Full,$14984,\frac{23}{10}\frac{?}{2021},3,\backslash$table$[[$Parking on$],[$disability parking$],[$space$]],100],[,,,,,,,,,1,\backslash$table$[[$Parking on parking$],[$restricted area$]],150],[$A$00040,\backslash$table$[[$Fiona$],[$James$]],040456234,$MIT,$\backslash$table$[[$Science$],[$& Eng$]],$TRE$176,F,$Full,$14997,\frac{22}{03}\frac{?}{2020},4,\backslash$table$[[$No Valid Parking$],[$permit$]],40],[$A$00044,$Rudy Deco,$040896245,$MIT,$\backslash$table$[[$Science$],[$& Eng$]],$TRE$179,P,$Prov,$14999,\frac{22}{03}\frac{?}{2021},2,\backslash$table$[[$Overstaying$],[$allotted time$]],50],[$A$00020,\backslash$table$[[$Thomas$],[$Brown$]],040124886,$BBIS,BUS,BRY$123,P,$Prov,$15639,\frac{10}{10}\frac{?}{2020},3,\backslash$table$[[$Parking on$],[$disability parking$],[$space$]],100]]$