Neco 2018 Data Processing Question 23

Practice objective / multiple choice question 23 from the 2018 Neco Data Processing examination.

Neco 2018 Data Processing Objective / Multiple Choice Medium Difficulty
Question 23 NECO • 2018 • DATA_PROCESSING • objective

Consider a relation \(R(A,B,C)\) with the functional dependencies \(A \rightarrow B\) and \(B \rightarrow C\). Decompose \(R\) into a set of relations that are in Boyce‑Codd Normal Form (BCNF) while preserving dependencies and ensuring a lossless‑join. List the resulting relations.

Answer Options

A. R1(A,C) and R2(A,B)
B. R1(A,B) and R2(A,C)
C. R1(A,B) and R2(B,C)
Correct Answer D. R1(B,C) and R2(A,B)
Correct Answer
D
Correct Option:
R1(B,C) and R2(A,B)

About This Question

This is Neco 2018 Data Processing Question 23. It is one of the objective questions from the 2018 Neco Data Processing examination.

Difficulty level: Medium .

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