Neco 2019 Computer Studies Question 3

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

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

Relation R(A,B,C,D,E) has the functional dependencies: A→B, B→C, AC→D, D→E. a) List all candidate keys of R. b) State the highest normal form (up to BCNF) that R satisfies. c) Provide a lossless‑decomposition of R into relations that are in BCNF.

Answer Options

A. a) AD; b) 2NF; c) {R1(A,B), R2(B,C), R3(D,E)}
Correct Answer B. a) AC; b) 1NF; c) {R1(A,B), R3(D,E), R4(A,C,D)}
C. a) A; b) BCNF; c) {R1(A,B), R2(B,C), R3(C,D), R4(D,E)}
D. a) AB; b) 3NF; c) {R1(A,B,C), R2(C,D), R3(D,E)}
Correct Answer
B
Correct Option:
a) AC; b) 1NF; c) {R1(A,B), R3(D,E), R4(A,C,D)}

About This Question

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

Difficulty level: Hard .

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