Neco 2021 Data Processing Question 7

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

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

A relation R(A,B,C,D,E) has the functional dependencies: A \rightarrow B, A \rightarrow C, BC \rightarrow D, D \rightarrow E.\n\n(a) List all candidate keys of R.\n(b) State the highest normal form that R satisfies.\n(c) If R is not in BCNF, decompose it into BCNF relations and list the resulting schemas.

Answer Options

A. Candidate key: {A}. Highest normal form: 3NF. BCNF decomposition: R1(A,B), R2(C,D,E), R3(D,E).
B. Candidate key: {A,B}. Highest normal form: 1NF. BCNF decomposition: R1(A,B), R2(C,D,E).
C. Candidate key: {BC}. Highest normal form: 3NF. BCNF decomposition: R1(B,C), R2(A,D,E).
Correct Answer D. Candidate key: {A}. Highest normal form: 2NF. BCNF decomposition: R1(B,C,D), R2(A,B,C,E), R3(D,E).
Correct Answer
D
Correct Option:
Candidate key: {A}. Highest normal form: 2NF. BCNF decomposition: R1(B,C,D), R2(A,B,C,E), R3(D,E).

About This Question

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