Neco 2017 Data Processing Question 20

Practice objective / multiple choice question 20 from the 2017 Neco Data Processing examination.

Neco 2017 Data Processing Objective / Multiple Choice Medium Difficulty
Question 20 NECO • 2017 • DATA_PROCESSING • objective

In relation \(R(A,B,C,D)\) the following functional dependencies hold: \(A \rightarrow B\), \(C \rightarrow D\), and \(AB \rightarrow C\).\n\n(a) List all candidate keys of \(R\).\n(b) State the highest normal form (up to BCNF) that \(R\) satisfies.\n(c) Decompose \(R\) into a collection of relations that are in BCNF.

Answer Options

A. (a) {A,B}; (b) 3NF; (c) R1(A,B) and R2(C,D)
B. (a) {C}; (b) 1NF; (c) R1(A,B) and R2(C,D)
C. (a) {A,C}; (b) BCNF; (c) R1(A,B,C) and R2(C,D)
Correct Answer D. (a) {A}; (b) 2NF; (c) R1(C,D) and R2(A,B,C)
Correct Answer
D
Correct Option:
(a) {A}; (b) 2NF; (c) R1(C,D) and R2(A,B,C)

About This Question

This is Neco 2017 Data Processing Question 20. It is one of the objective questions from the 2017 Neco Data Processing examination.

Difficulty level: Medium .

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