Gce Model Questions Vol1 2017 Computer Studies Question 40

Practice objective / multiple choice question 40 from the 2017 Gce Model Questions Vol1 Computer Studies examination.

Gce Model Questions Vol1 2017 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 40 GCE_MODEL_QUESTIONS_VOL1 • 2017 • COMPUTER_STUDIES • objective

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

Answer Options

A. A; 3NF
Correct Answer B. A; 2NF
C. A; BCNF
D. AB; 2NF
Correct Answer
B
Correct Option:
A; 2NF

About This Question

This is Gce Model Questions Vol1 2017 Computer Studies Question 40. It is one of the objective questions from the 2017 Gce Model Questions Vol1 Computer Studies examination.

Difficulty level: Hard .

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