Neco 2021 Data Processing Question 11

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

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

Consider a relation R(A,B,C,D,E) with functional dependencies \(A \rightarrow B\), \(BC \rightarrow D\), \(D \rightarrow E\), and \(AB \rightarrow C\). (a) List all candidate keys of R. (b) Decompose R into BCNF and give the resulting relation schemas.

Answer Options

A. Candidate key: {AB}. BCNF decomposition: R1(B,C,D), R2(A,B), R3(A,E), R4(C,E).
B. Candidate key: {A,D}. BCNF decomposition: R1(A,B), R2(B,C), R3(C,D), R4(A,E).
Correct Answer C. Candidate key: {A}. BCNF decomposition: R1(B,C,D), R2(A,B), R3(A,C), R4(A,E).
D. Candidate key: {B}. BCNF decomposition: R1(A,B,C), R2(B,D), R3(D,E), R4(A,E).
Correct Answer
C
Correct Option:
Candidate key: {A}. BCNF decomposition: R1(B,C,D), R2(A,B), R3(A,C), R4(A,E).

About This Question

This is Neco 2021 Data Processing Question 11. 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