Question $2-$Normalization $[20$ Marks$]$

A local pizza restaurant phones you in need of help. Their computer system crashed and they now want to develop their own, new, in$-$house system for capturing order information.

You ask the pizza restaurant for a data model of the previous system, but they do not have one. All that they can give you is an old backup spreadsheet containing order information. The spreadsheet contains columns with order information, item information, customer information and suburb information. You turn the spreadsheet into $1NF$ by removing the repeating groups and choosing a composite primary key. The spreadsheet now looks as follows:

$1$NF $($order id$,$ item id$,$ cust$\_$id$,$ cust$\_$name, cust$\_$surname, cust$\_$phone, cust$\_$address, suburb$\_$id$,$ suburb$\_$name, suburb$\_$delivery$\_$fee, order$\_$date, item$\_$name, item$\_$price, qty$\_$ordered$)$

Complete the following questions:

$2\mathrm{.}1)$ Write down the names of all the columns that are fully dependent on the composite primary key

$2\mathrm{.}2)$ Write down all PARTIAL dependencies $($they show you in the textbook how to do this$)$

$2\mathrm{.}3)$ Write down all TRANSITIVE dependencies

$2\mathrm{.}4)$ Remove all PARTIAL dependencies, and write down the resulting table schemas

$2\mathrm{.}5)$Remove all TRANSITIVE dependencies, and write down the resulting table schemas

$(6)$