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 X1(Q, S), and X2(P, Q, R, S, T).
Which of the following statements are incorrect?
(1){PQ -> R} is a minimal cover for the FDs that
hold in X2.
(2) PQ -> R is a BCNF violation for X2.
(3) X2 should be decomposed further into X3(P, Q, R)
and X4(R, T)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!