Consider a relation (R(A,B,C,D)) with functional dependencies $A \rightarrow B$, $BC \rightarrow D$ and $D \rightarrow A$. Determine the highest normal form of (R) and give a lossless‑decomposition of (R) into relations that are in Boyce‑Codd Normal Form (BCNF).

Question

Accepted Answer

R is not in 3NF; BCNF decomposition: R1(D,A) and R2(B,C,D)

City Guilds Model Questions Vol1 2021 Information Technology Question 37

Consider a relation (R(A,B,C,D)) with functional dependencies \(A \rightarrow B\), \(BC \rightarrow D\) and \(D \rightarrow A\). Determine the highest normal form of (R) and give a lossless‑decomposition of (R) into relations that are in Boyce‑Codd Normal Form (BCNF).

Answer Options

About This Question

Master the Exam!