Neco 2023 Computer Studies Question 48

Practice objective / multiple choice question 48 from the 2023 Neco Computer Studies examination.

Neco 2023 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 48 NECO • 2023 • COMPUTER_STUDIES • objective

For the relation \(R(A,B,C,D)\) the following functional dependencies are given: \[A\rightarrow B,\; B\rightarrow C,\; A\rightarrow D\] (a) List all candidate keys of \(R\). (b) State the highest normal form (up to BCNF) that \(R\) satisfies. (c) If \(R\) is not in BCNF, decompose it into a set of BCNF relations.

Answer Options

Correct Answer A. Candidate key: A; Relation is in 3NF but not BCNF; BCNF decomposition: R1(B,C) and R2(A,B,D)
B. Candidate key: A; Relation is in BCNF; BCNF decomposition: R1(A,B) and R2(A,C,D)
C. Candidate key: AD; Relation is in 3NF but not BCNF; BCNF decomposition: R1(A,D) and R2(B,C)
D. Candidate key: B; Relation is in 2NF but not 3NF; BCNF decomposition: R1(A,B) and R2(B,C,D)
Correct Answer
A
Correct Option:
Candidate key: A; Relation is in 3NF but not BCNF; BCNF decomposition: R1(B,C) and R2(A,B,D)

About This Question

This is Neco 2023 Computer Studies Question 48. It is one of the objective questions from the 2023 Neco Computer Studies examination.

Difficulty level: Hard .

View More Neco 2023 Computer Studies 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