Neco 2019 Computer Studies Question 29

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

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

Consider a relation R(A, B, C, D, E) with the functional dependencies: \(A \rightarrow B\), \(B \rightarrow C\), \(C \rightarrow D\), and \(AD \rightarrow E\). (a) List all candidate keys of R. (b) State whether R is in Third Normal Form (3NF). (c) If it is not in 3NF, provide a lossless‑decomposition of R into relations that are in 3NF.

Answer Options

A. Candidate keys: AB, AC, AD, AE, BD. R is in 3NF; no decomposition needed.
Correct Answer B. Candidate keys: AB, AC, AD, AE. R is in 3NF; no decomposition needed.
C. Candidate keys: A, B, C, D, E. R is not in 3NF; decompose into (A,B,C) and (D,E).
D. Candidate keys: AB, AC, AD, AE. R is not in 3NF; lossless decomposition: R1(A,B), R2(C,D,E).
Correct Answer
B
Correct Option:
Candidate keys: AB, AC, AD, AE. R is in 3NF; no decomposition needed.

About This Question

This is Neco 2019 Computer Studies Question 29. 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