Neco 2018 Computer Studies Question 16

Practice objective / multiple choice question 16 from the 2018 Neco Computer Studies examination.

Neco 2018 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 16 NECO • 2018 • COMPUTER_STUDIES • objective

Consider a relation R(A,B,C,D,E) with functional dependencies \( \{A \rightarrow B, A \rightarrow C, BC \rightarrow D, D \rightarrow E\} \). (a) State the highest normal form that R satisfies. (b) Decompose R into BCNF using the standard decomposition algorithm and give the number of resulting relations.

Answer Options

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

About This Question

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