Table $2$ below shows a shipping manifest. The assignment is as the following:

$1)$ In what normal form is this relation?

$2)$ It contains a series of partial dependencies and one transitive dependency. Please show the transitive dependency using the notation $$FD: A $$ B$.$

$3)$ Decompose the relation into a set of $3$NF relations. Please show the decomposed relations and the primary keys and foreign keys, i$.$e$.,$ PK and FK$.$Table $2$ below shows a shipping manifiest. The assignment is as the followings

In what normal form is this relation?

It contains a series of partial dependencies and one transitive dependency. Please show the

transitive dependency using the notation $"$FD: $AB".$

Decompose the relation into a set of $3$NF relations, Please show the decomposed relations and

the primary keys and foreign keys, i$.$e$.,$ PK and FK$.$

Table $2$ Shipping Manifest