Neco 2024 Data Processing Question 36

Practice objective / multiple choice question 36 from the 2024 Neco Data Processing examination.

Neco 2024 Data Processing Objective / Multiple Choice Medium Difficulty
Question 36 NECO • 2024 • DATA_PROCESSING • objective

Consider a relation R(A,B,C,D) with functional dependencies \(A \rightarrow B\), \(B \rightarrow C\), and \(C \rightarrow D\). (i) State the highest normal form of R. (ii) Decompose R into relations that are in Boyce‑Codd Normal Form. (iii) Indicate whether the decomposition is lossless‑join and whether it preserves all functional dependencies.

Answer Options

A. R is in 2NF only; BCNF decomposition gives R1(A,B) and R2(B,C) and R3(C,D); the decomposition is lossless‑join (no) but not dependency‑preserving (no).
Correct Answer B. R is in 2NF only; BCNF decomposition gives R1(B,C) and R2(A,B,D); the decomposition is lossless‑join (yes) but not dependency‑preserving (no).
C. R is in 3NF only; BCNF decomposition gives R1(A,B) and R2(B,C,D); the decomposition is lossless‑join (no) but not dependency‑preserving (yes).
D. R is in 1NF only; BCNF decomposition gives R1(A,B,C) and R2(C,D); the decomposition is lossless‑join (yes) and dependency‑preserving (yes).
Correct Answer
B
Correct Option:
R is in 2NF only; BCNF decomposition gives R1(B,C) and R2(A,B,D); the decomposition is lossless‑join (yes) but not dependency‑preserving (no).

About This Question

This is Neco 2024 Data Processing Question 36. It is one of the objective questions from the 2024 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2024 Data Processing 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