Neco 2025 Computer Studies Question 27

Practice objective / multiple choice question 27 from the 2025 Neco Computer Studies examination.

Neco 2025 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 27 NECO • 2025 • COMPUTER_STUDIES • objective

Consider a relation R(A,B,C,D) with functional dependencies \\(A \\rightarrow B\\), \\(BC \\rightarrow D\\), and \\(D \\rightarrow A\\). Determine (a) the highest normal form of R, (b) a lossless‑join decomposition of R into BCNF, and (c) whether the decomposition preserves all functional dependencies.

Answer Options

A. Highest normal form: 3NF. BCNF decomposition: R1(A,D) and R2(B,C). Lossless join: No. Dependency preservation: No.
B. Highest normal form: 2NF. BCNF decomposition: R1(A,B) and R2(B,C,D). Lossless join: Yes. Dependency preservation: Yes.
C. Highest normal form: 1NF. BCNF decomposition: R1(A,B,C) and R2(C,D). Lossless join: Yes. Dependency preservation: Yes.
Correct Answer D. Highest normal form: 1NF. BCNF decomposition: R1(D,A) and R2(B,C,D). Lossless join: Yes. Dependency preservation: No.
Correct Answer
D
Correct Option:
Highest normal form: 1NF. BCNF decomposition: R1(D,A) and R2(B,C,D). Lossless join: Yes. Dependency preservation: No.

About This Question

This is Neco 2025 Computer Studies Question 27. It is one of the objective questions from the 2025 Neco Computer Studies examination.

Difficulty level: Hard .

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