Neco 2018 Data Processing Question 49

Practice objective / multiple choice question 49 from the 2018 Neco Data Processing examination.

Neco 2018 Data Processing Objective / Multiple Choice Medium Difficulty
Question 49 NECO • 2018 • DATA_PROCESSING • objective

Consider the relation \(R(A,B,C,D)\) with the functional dependencies:\n\\[\nA \rightarrow B,\quad BC \rightarrow D,\quad D \rightarrow A\n\\]\n\n(a) List all candidate keys of \(R\).\n(b) State the highest normal form that \(R\) satisfies.\n(c) Decompose \(R\) into a set of relations that are in Boyce‑Codd Normal Form (BCNF).

Answer Options

A. Candidate keys: BD, AC; Highest normal form: 2NF; BCNF decomposition: R1(A,B) and R2(C,D)
Correct Answer B. Candidate keys: BC, CD; Highest normal form: 1NF; BCNF decomposition: R1(D,A) and R2(B,C,D)
C. Candidate keys: B, D; Highest normal form: 3NF; BCNF decomposition: R1(A,D) and R2(B,C)
D. Candidate keys: AB, AD; Highest normal form: 1NF; BCNF decomposition: R1(A,B,C) and R2(D)
Correct Answer
B
Correct Option:
Candidate keys: BC, CD; Highest normal form: 1NF; BCNF decomposition: R1(D,A) and R2(B,C,D)

About This Question

This is Neco 2018 Data Processing Question 49. It is one of the objective questions from the 2018 Neco Data Processing examination.

Difficulty level: Medium .

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