a$.$ Identify all the functional dependencies in the Orders relation. $(2$ marks$)$

b$.$ Based on the functional dependencies identified, determine the highest normal

form $(1$NF$,2$NF$,3$NF$,$ or BCNF$)$ that the Orders relation currently satisfies.

Justify your answer. $(2$ marks$)$

c$.$ Decompose the Orders relation into a set of relations that are in Boyce$-$Codd

Normal Form $($BCNF$).$ Clearly show each step of your decomposition process. $(4$

marks$)$