Gce Model Questions Vol1 2023 Computer Studies Question 32

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

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

Consider a relation \(R(A,B,C,D,E)\) with the functional dependencies \(A \rightarrow B\), \(BC \rightarrow D\), \(D \rightarrow E\) and \(A \rightarrow C\).\n\n(i) Identify the highest normal form (1NF, 2NF, 3NF or BCNF) that \(R\) satisfies.\n(ii) Decompose \(R\) into a set of BCNF relations, listing the attributes of each resulting relation.\n(iii) State whether the decomposition is lossless and whether it preserves all the original functional dependencies.

Answer Options

Correct Answer A. 2NF; R1(B,C,D), R2(A,B,C,E); lossless join: Yes; dependency preserving: No
B. 2NF; R1(A,B,C), R2(B,D,E); lossless join: No; dependency preserving: No
C. 3NF; R1(A,B), R2(B,C,D,E); lossless join: Yes; dependency preserving: Yes
D. BCNF; R1(A,B), R2(C,D,E); lossless join: Yes; dependency preserving: Yes
Correct Answer
A
Correct Option:
2NF; R1(B,C,D), R2(A,B,C,E); lossless join: Yes; dependency preserving: No

About This Question

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

Difficulty level: Hard .

View More Gce Model Questions Vol1 2023 Computer Studies Questions More Gce Model Questions Vol1 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