Neco 2017 Data Processing Question 24

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

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

Consider the relation \(R(A,B,C,D)\) with the set of functional dependencies \(A \rightarrow B,\; B \rightarrow C,\; C \rightarrow D\). (a) List all candidate keys of \(R\). (b) State the highest normal form (up to BCNF) that \(R\) satisfies. (c) Decompose \(R\) into a collection of relations that are in Boyce‑Codd Normal Form (BCNF).

Answer Options

A. Candidate key: D; Highest NF: 2NF; BCNF decomposition: R1(A,D) and R2(B,C)
B. Candidate key: B; Highest NF: 1NF; BCNF decomposition: R1(A,B) and R2(C,D)
Correct Answer C. Candidate key: A; Highest NF: 2NF; BCNF decomposition: R1(B,C) and R2(A,B,D)
D. Candidate key: A; Highest NF: 3NF; BCNF decomposition: R1(A,B) and R2(B,C,D)
Correct Answer
C
Correct Option:
Candidate key: A; Highest NF: 2NF; BCNF decomposition: R1(B,C) and R2(A,B,D)

About This Question

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