Neco 2019 Computer Studies Question 16

Practice objective / multiple choice question 16 from the 2019 Neco Computer Studies examination.

Neco 2019 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 16 NECO • 2019 • COMPUTER_STUDIES • objective

Consider a relation R(A,B,C,D) with functional dependencies: \( A \rightarrow B \), \( B \rightarrow C \), and \( AC \rightarrow D \). (a) List all candidate keys of R. (b) State the highest normal form that R satisfies. (c) If R is not in Boyce‑Codd Normal Form, decompose it into BCNF relations and give the number of resulting relations.

Answer Options

A. AC; 1NF; 4
Correct Answer B. A; 2NF; 3
C. AB; 3NF; 2
D. AD; BCNF; 5
Correct Answer
B
Correct Option:
A; 2NF; 3

About This Question

This is Neco 2019 Computer Studies Question 16. It is one of the objective questions from the 2019 Neco Computer Studies examination.

Difficulty level: Hard .

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