Neco 2022 Computer Studies Question 37

Practice objective / multiple choice question 37 from the 2022 Neco Computer Studies examination.

Neco 2022 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 37 NECO • 2022 • COMPUTER_STUDIES • objective

Consider a relation R(A,B,C,D,E) with the functional dependencies: A→B, A→C, BC→D, and D→E. (i) List all candidate keys of R. (ii) State the highest normal form (up to BCNF) that R satisfies.

Answer Options

Correct Answer A. Candidate key: A; Highest normal form: 2NF
B. Candidate key: B; Highest normal form: 2NF
C. Candidate key: A; Highest normal form: 3NF
D. Candidate key: AB; Highest normal form: 2NF
Correct Answer
A
Correct Option:
Candidate key: A; Highest normal form: 2NF

About This Question

This is Neco 2022 Computer Studies Question 37. It is one of the objective questions from the 2022 Neco Computer Studies examination.

Difficulty level: Hard .

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