Neco 2019 Data Processing Question 11

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

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

Consider a relation R(A,B,C,D) with functional dependencies \(A \rightarrow B\), \(BC \rightarrow D\), and \(C \rightarrow A\). Determine (i) the candidate key(s) of R, (ii) the highest normal form that R satisfies, and (iii) after decomposing R into BCNF, how many relations are obtained.

Answer Options

Correct Answer A. C, 2NF, 3
B. C, 3NF, 3
C. C, 2NF, 2
D. A, 2NF, 3
Correct Answer
A
Correct Option:
C, 2NF, 3

About This Question

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

Difficulty level: Medium .

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