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

Table 1:  ORDER(order#, customer#, name, address, orderdate)

Table 2:  ORDER_LINE(order#, product#, description, quantity, unitprice)

 

Answer following questions based on your analysis of the give form:

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

21a. What is the key? (Note, to analyze or normalize a table, you MUST figure out the key of the table first) Order#

21c. What Normal Form is this table in?

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

 

For table 2:  ORDER_LINE(order#, product#, description, quantity, unitprice)

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

22b. List all functional dependencies

22c. What Normal Form is this table in?

22d. Describe the modification anormaly this table may have (Note, describe insertion anormaly, deletion anormaly and update anormaly respectively)

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