$2.$ 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$)$

ORDER FORM

Order# $1234$ OrderDate $01/04/2021$

Customer Number $9876$ Note: Customer requested express shipping

Customer Name Billy

Customer Address $456$ High Tower Street

Hong Kong, China

ProductNo Description Quantity Unit Price

A$123$ Callaway HexSoft $($box$)10$ $$23\mathrm{.}00$

B$234$ TaylorMade TP$5$x $($box$)20$ $$25\mathrm{.}50$

B$456$ Wilson Ultra $($box$)10$ $$21\mathrm{.}00$

$............$

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$)$