Neco 2021 Data Processing Question 39

Practice objective / multiple choice question 39 from the 2021 Neco Data Processing examination.

Neco 2021 Data Processing Objective / Multiple Choice Medium Difficulty
Question 39 NECO • 2021 • DATA_PROCESSING • objective

Consider a relation R(A,B,C,D) with the functional dependencies: A → B, B → C, and A → D.\n\n(a) List all candidate keys of R.\n(b) State the highest normal form (up to BCNF) that R satisfies.\n(c) Decompose R into a collection of relations that are in BCNF.

Answer Options

A. Candidate key: A; Highest normal form: BCNF; BCNF decomposition: R1(A,B) and R2(B,C,D)
Correct Answer B. Candidate key: A; Highest normal form: 2NF; BCNF decomposition: R1(B,C) and R2(A,B,D)
C. Candidate key: B; Highest normal form: 1NF; BCNF decomposition: R1(A,B) and R2(B,C,D)
D. Candidate key: A,B; Highest normal form: 3NF; BCNF decomposition: R1(A,B) and R2(C,D)
Correct Answer
B
Correct Option:
Candidate key: A; Highest normal form: 2NF; BCNF decomposition: R1(B,C) and R2(A,B,D)

About This Question

This is Neco 2021 Data Processing Question 39. It is one of the objective questions from the 2021 Neco Data Processing examination.

Difficulty level: Medium .

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