Neco 2021 Data Processing Question 50

Practice objective / multiple choice question 50 from the 2021 Neco Data Processing examination.

Neco 2021 Data Processing Objective / Multiple Choice Medium Difficulty
Question 50 NECO • 2021 • DATA_PROCESSING • objective

Consider the relation \(R(A,B,C,D)\) with the functional dependencies: \(A \rightarrow B\), \(BC \rightarrow D\), \(D \rightarrow A\).\n\n(a) List all candidate keys of \(R\).\n(b) State the highest normal form that \(R\) satisfies.\n(c) Decompose \(R\) into a set of relations that are in Boyce‑Codd Normal Form (BCNF).

Answer Options

A. Candidate keys: AB and CD; Highest normal form: 3NF; BCNF decomposition: R1(A,B), R2(B,C), R3(A,D).
B. Candidate keys: AC and BD; Highest normal form: 1NF; BCNF decomposition: R1(A,B), R2(B,C), R3(C,D).
Correct Answer C. Candidate keys: AC and CD; Highest normal form: 1NF; BCNF decomposition: R1(A,B), R3(A,D), R4(C,D).
D. Candidate keys: AD and BC; Highest normal form: 2NF; BCNF decomposition: R1(A,B), R2(B,C), R3(C,D).
Correct Answer
C
Correct Option:
Candidate keys: AC and CD; Highest normal form: 1NF; BCNF decomposition: R1(A,B), R3(A,D), R4(C,D).

About This Question

This is Neco 2021 Data Processing Question 50. It is one of the objective questions from the 2021 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2021 Data Processing Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support