Consider a relation R(A,B,C,D,E) with functional dependencies: A o B, BC o D, D o E.

(a) List all candidate keys of R.
(b) State the highest normal form that R satisfies.
(c) Give a lossless‑join, dependency‑preserving decomposition of R into BCNF relations.

Question

Consider a relation R(A,B,C,D,E) with functional dependencies: A	o B, BC	o D, D	o E.

(a) List all candidate keys of R.
(b) State the highest normal form that R satisfies.
(c) Give a lossless‑join, dependency‑preserving decomposition of R into BCNF relations.

Accepted Answer

1NF; R1(A,B), R2(A,C,D), R3(D,E)

Neco 2023 Data Processing Question 25

Consider a relation R(A,B,C,D,E) with functional dependencies: A\to B, BC\to D, D\to E.\n\n(a) List all candidate keys of R.\n(b) State the highest normal form that R satisfies.\n(c) Give a lossless‑join, dependency‑preserving decomposition of R into BCNF relations.

Answer Options

About This Question

Master the Exam!