Neco 2022 Data Processing Question 36

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

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

The relation R(A,B,C,D,E) has the functional dependencies: (A \rightarrow B), (BC \rightarrow D), (D \rightarrow E), and (AB \rightarrow C). (a) List all candidate keys of R. (b) State whether R is in Third Normal Form (3NF). (c) If R is not in 3NF, give a lossless‑join, dependency‑preserving decomposition of R into relations that are in 3NF.

Answer Options

A. Candidate key: {B}. R is not in 3NF. A lossless‑join, dependency‑preserving 3NF decomposition is: R1(A,B), R2(C,D), R3(D,E).
Correct Answer B. Candidate key: {A}. R is not in 3NF. A lossless‑join, dependency‑preserving 3NF decomposition is: R1(A,B,C), R2(B,C,D), R3(D,E).
C. Candidate key: {A,B}. R is not in 3NF. A lossless‑join, dependency‑preserving 3NF decomposition is: R1(A,B), R2(B,C,D), R3(D,E).
D. Candidate key: {A}. R is in 3NF. No decomposition is required.
Correct Answer
B
Correct Option:
Candidate key: {A}. R is not in 3NF. A lossless‑join, dependency‑preserving 3NF decomposition is: R1(A,B,C), R2(B,C,D), R3(D,E).

About This Question

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

Difficulty level: Medium .

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