A student created two tables as follows based on her analysis on the following order form.

$(($note: a customer can buy multiple products in an order$)$

Table $1$: ORDER $($order#$,$ customer#$,$ name, address, order date, note$)$

Table $2$: ORDER$\_$LINE $($order#$,$ product#$,$ description, quantity, unit price$)$

Answer following questions based on your analysis of the give form $($note: a customer can

buy multiple products in one order$)$

For Table $1$ ORDER $($order#$,$ customer#$,$ name, address, orderdate, note$)$

$21$a$.$ List all functional dependencies

$21$b$.$ What is the key? $($Note$,$ to analyze or normalize a table, you MUST figure out the key of

the table first$)$

$21$c$.$ What Normal Form is this table in$?$ Why? Use the definition of the normal form that

applies to justify your conclusion

$21$d$.$ Normalize the table into a set of tables that are at least $3$ NF $.$

For table $2$: ORDER$\_$LINE $($order#$,$ product#$,$ description, quantity, unit price$)$

$22$a$.$ List all functional dependencies

$22$ b $.$ What is the key? $($Note$,$ to analyze or normalize a table, you MUST figure out the key of

the table first$)$

$22$c$.$ What Normal Form is this table in$?$ Why? Use the definition of the normal form that

applies

$22$d$.$ Describe a specific modification anomaly that may occur in ORDER$\_$LINE table.

$22$e$.$ Normalize the table into a set of tables that are at least $3$NF$.$