$1)$ List all functional dependencies $($FDs$)$ for the receipt table. You can either list these

FDs as demonstrated in the instructional video for this module $($that is$,$ in the form

X $->$ Y$)$ or you can provide a dependency diagram as shown in Chapter $6$ of your

textbook. Either way provides the same information and either way is fine for this

assignment. This is true anywhere in the remainder of this assignment where you

are asked to specify dependencies.

$2)$ List all functional dependencies $($FDs$)$ for the product table.

$3)$ List all functional dependencies $($FDs$)$ for the line$\_$item table.

$4)$ The line$\_$item table is in third normal form $(3$NF$),$ which by definition means it is also

in second normal form $(2$NF$).$ What single column could you add to this table so it is

no longer in $2$NF$?$ Include an explanation of why this change means the table now

violates $2$NF$.$

$5)$ Consider the line$\_$item table in its original form, as shown on the previous page with

four columns. What single column could you add to this table so it is still in $2$NF but

is no longer in $3$NF$?$ Include an explanation of why this change means the table now

violates $3$NF$.$

Include in your submission document your answ