Gce Model Questions Vol1 2018 Computer Studies Question 50

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

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

Consider a relation R(A,B,C,D) with the functional dependencies: A → B, B → C, C → D, and D → A. (a) Determine the highest normal form (up to BCNF) that R satisfies. (b) Decompose R into BCNF and state the minimum number of tables required. Provide the normal form and the number of tables as your answer.

Answer Options

Correct Answer A. 2NF, 3 tables
B. 3NF, 4 tables
C. BCNF, 1 table
D. 1NF, 2 tables
Correct Answer
A
Correct Option:
2NF, 3 tables

About This Question

This is Gce Model Questions Vol1 2018 Computer Studies Question 50. It is one of the objective questions from the 2018 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