Neco 2018 Data Processing Question 40

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

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

Consider the relation \(R(A,B,C,D,E)\) with the set of functional dependencies: \(A \rightarrow B,\; B \rightarrow C,\; A \rightarrow D,\; D \rightarrow E\). (a) Identify all candidate keys of \(R\). (b) Decompose \(R\) into a set of relations that are in Third Normal Form (3NF). List the resulting relations and state how many tables are needed after decomposition.

Answer Options

Correct Answer A. Candidate key: {A}. 3NF decomposition: R1(A,B,D), R2(B,C), R3(D,E). Number of tables = 3.
B. Candidate key: {A,B}. 3NF decomposition: R1(A,B), R2(B,C), R3(D,E). Number of tables = 3.
C. Candidate key: {A}. 3NF decomposition: R1(A,B), R2(B,C,D), R3(D,E). Number of tables = 3.
D. Candidate key: {A}. 3NF decomposition: R1(A,B,D), R2(B,C), R3(D,E), R4(A,E). Number of tables = 4.
Correct Answer
A
Correct Option:
Candidate key: {A}. 3NF decomposition: R1(A,B,D), R2(B,C), R3(D,E). Number of tables = 3.

About This Question

This is Neco 2018 Data Processing Question 40. 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