Neco 2019 Computer Studies Question 14

Practice objective / multiple choice question 14 from the 2019 Neco Computer Studies examination.

Neco 2019 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 14 NECO • 2019 • COMPUTER_STUDIES • objective

A relation R(A,B,C,D,E) has the following functional dependencies: \(A \rightarrow B\), \(BC \rightarrow D\), \(D \rightarrow E\), \(E \rightarrow A\).\n\n(a) List all candidate keys of R.\n(b) State the highest normal form (up to BCNF) that R satisfies.

Answer Options

Correct Answer A. Candidate keys: AC and BC; Highest normal form: 1NF
B. Candidate keys: AC and AD; Highest normal form: 3NF
C. Candidate keys: AB and BC; Highest normal form: BCNF
D. Candidate keys: AB and AD; Highest normal form: 2NF
Correct Answer
A
Correct Option:
Candidate keys: AC and BC; Highest normal form: 1NF

About This Question

This is Neco 2019 Computer Studies Question 14. It is one of the objective questions from the 2019 Neco Computer Studies examination.

Difficulty level: Hard .

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