Consider the Relational Schema R(A, B, C, D) $\rightarrow$ C, C $\rightarrow$

Essay

Consider the relational schema R(A, B, C, D). For each of the following functional dependencies identify the candidate key(s) for R and state its strongest normal form. If appropriate, decompose to BCNF.
(a) B $\rightarrow$ C, C $\rightarrow$ A, C $\rightarrow$ D
(b) B $\rightarrow$ C, D $\rightarrow$ A
(c) ABC $\rightarrow$ D, D $\rightarrow$ A
(d) A $\rightarrow$ B, A $\rightarrow$ C, BC $\rightarrow$ D
(e) AB $\rightarrow$ C, AB $\rightarrow$ D, C $\rightarrow$ A, D $\rightarrow$ B