Page

$3$

of $6$

Task C

Normalise the table below to the second normal form $(2$NF$).$ Please use appropriate schema$/$table names and add extra attributes where required.

MID$=$ membership ID$.$

MovielD$=$ Project Number.

Rent$\_$Date$=$ the date the movie was rented.

Fulliname$=$ name of the person who rented the movie

Address $=$ Address of the person who rented

Movie$\_$Title$=$ the title of the movie being rented.

$\backslash$table$[[$MID$,$ MovielD ${?}_{(}),$Rent$\_$Date,FullName,Address,Movie$\_$Title$],[12346789,123,\frac{12}{08}\frac{?}{2021},$Smith, John B$,\backslash$table$[[23$ Black Street,$],[$Melbourne VIC $3000]],\backslash$table$[[$Avengers: Infinity$],[$War$]]],[123456789,121,\frac{12}{08}\frac{?}{2021},$Smith, John B$,\backslash$table$[[23$ Black Street,$],[$Melbourne VIC $3000]],\backslash$table$[[$Avengers:$],[$Endgame$]]],[453453453,114,\frac{1}{09}\frac{?}{2021},$English,Joyce A$,\backslash$table$[[3$ White court,$],[$Melbourne VIC $3000]],$Coco$],[453453453,234,\frac{1}{09}\frac{?}{2021},$English,Joyce A$,\backslash$table$[[3$ White court,$],[$Melbourne VIC $3000]],$Hamilton$],[333445555,211,\frac{13}{09}\frac{?}{2021},$Wong, Franklin T$,\backslash$table$[[19$ Yellow drive,$],[$Melbourne VIC $3000]],$The Dig$],[333445555,301,\frac{13}{09}\frac{?}{2021},$Wong, Franklin T$,\backslash$table$[[19$ Yellow drive,$],[$Melbourne VIC $3000]],$Nobody$],[333445555,101,\frac{17}{09}\frac{?}{2021},$Wong, Franklin T$,\backslash$table$[[19$ Yellow drive,$],[$Melbourne VIC $3000]],$Limbo$],[333445555,202,\frac{17}{09}\frac{?}{2021},$Wong, Franklin T$,\backslash$table$[[19$ Yellow drive,$],[$Melbourne VIC $3000]],\backslash$table$[[$The Woman in$],[$the window$]]]]$