Neco 2024 Computer Studies Question 6

Practice objective / multiple choice question 6 from the 2024 Neco Computer Studies examination.

Neco 2024 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 6 NECO • 2024 • COMPUTER_STUDIES • objective

Consider a relation R(A,B,C,D,E) with functional dependencies: \(A\rightarrow B\), \(BC\rightarrow D\), \(D\rightarrow E\). Determine the highest normal form of R. Then decompose R into Boyce‑Codd Normal Form (BCNF) and state how many relations result from the decomposition.

Answer Options

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

About This Question

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