Gce Model Questions Vol1 2019 Computer Studies Question 21

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

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

Given a relation R(A,B,C,D,E) with functional dependencies: A\rightarrow B, BC\rightarrow D, D\rightarrow E, A\rightarrow C. (a) Find a minimal cover of the set of functional dependencies. (b) The relation is decomposed into R1(A,B,C), R2(B,D) and R3(D,E). State whether this decomposition is lossless‑join and whether it preserves all functional dependencies.

Answer Options

A. Minimal cover: {A→B, A→C, BC→D, D→E}. Lossless‑join: No. Dependency preserving: No.
B. Minimal cover: {A→B, BC→D, D→E}. Lossless‑join: Yes. Dependency preserving: Yes.
C. Minimal cover: {A→B, A→C, B→D, D→E}. Lossless‑join: Yes. Dependency preserving: No.
Correct Answer D. Minimal cover: {A→B, A→C, BC→D, D→E}. Lossless‑join: Yes. Dependency preserving: No.
Correct Answer
D
Correct Option:
Minimal cover: {A→B, A→C, BC→D, D→E}. Lossless‑join: Yes. Dependency preserving: No.

About This Question

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

Difficulty level: Hard .

View More Gce Model Questions Vol1 2019 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