Neco 2021 Computer Studies Question 45

Practice objective / multiple choice question 45 from the 2021 Neco Computer Studies examination.

Neco 2021 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 45 NECO • 2021 • COMPUTER_STUDIES • objective

For the relation \(R(A,B,C,D)\) the following functional dependencies are given:\n\n\(A \rightarrow B\)\n\(B \rightarrow C\)\n\(AD \rightarrow C\)\n\(C \rightarrow D\)\n\n(i) Find a minimal cover of the set of functional dependencies.\n(ii) State the highest normal form (up to BCNF) that \(R\) satisfies.\n(iii) Decompose \(R\) into a set of relations that are in BCNF.

Answer Options

A. Minimal cover: {A→B, B→C, AD→C}; Highest normal form: 1NF; BCNF decomposition: R1(A,B), R2(B,C), R3(A,D,C)
B. Minimal cover: {A→B, AD→C, C→D}; Highest normal form: 3NF; BCNF decomposition: R1(A,B), R2(AD,C), R3(C,D)
Correct Answer C. Minimal cover: {A→B, B→C, C→D}; Highest normal form: 2NF; BCNF decomposition: R1(A,B), R2(B,C), R3(A,D)
D. Minimal cover: {A→B, B→C, C→D, AD→C}; Highest normal form: 2NF; BCNF decomposition: R1(A,B), R2(B,C), R3(C,D), R4(A,D)
Correct Answer
C
Correct Option:
Minimal cover: {A→B, B→C, C→D}; Highest normal form: 2NF; BCNF decomposition: R1(A,B), R2(B,C), R3(A,D)

About This Question

This is Neco 2021 Computer Studies Question 45. It is one of the objective questions from the 2021 Neco Computer Studies examination.

Difficulty level: Hard .

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