Neco 2023 Computer Studies Question 41

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

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

Consider a relation R(A,B,C,D,E) with the functional dependencies: \(A \rightarrow B\), \(B \rightarrow C\), \(CD \rightarrow E\), and \(E \rightarrow A\). (a) State the highest normal form (1NF, 2NF, 3NF, BCNF) that R satisfies. (b) Decompose R into a set of BCNF relations and state how many relations result from the decomposition.

Answer Options

Correct Answer A. 3NF, 3 relations
B. BCNF, 4 relations
C. 3NF, 2 relations
D. 2NF, 2 relations
Correct Answer
A
Correct Option:
3NF, 3 relations

About This Question

This is Neco 2023 Computer Studies Question 41. It is one of the objective questions from the 2023 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