Neco 2020 Data Processing Question 11

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

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

Consider a relation R(A,B,C,D) with functional dependencies: A \rightarrow B, BC \rightarrow D, and D \rightarrow A. (a) List all candidate keys of R. (b) Decompose R into BCNF. How many relations result from the decomposition?

Answer Options

A. Candidate keys: A, B, C; Number of BCNF relations: 2
B. Candidate keys: AB, AD, BD; Number of BCNF relations: 4
Correct Answer C. Candidate keys: AC, BC, CD; Number of BCNF relations: 3
D. Candidate keys: AC, BD, CD; Number of BCNF relations: 5
Correct Answer
C
Correct Option:
Candidate keys: AC, BC, CD; Number of BCNF relations: 3

About This Question

This is Neco 2020 Data Processing Question 11. It is one of the objective questions from the 2020 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2020 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