Question: Consider a relation X ( P , Q , R , S , T ) with the FD s: PQ - > R Q -
Consider a relation X P Q R S T with the FDs:
PQ R
Q S
ST P
Q S is a BCNF violation for X Suppose we decide
to decompose X into XQ S and XP Q R S T
Which of the following statements are incorrect?
PQ R is a minimal cover for the FDs that
hold in X
PQ R is a BCNF violation for X
X should be decomposed further into XP Q R
and XR T
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
