Computer Sciences > GATE 2021 SET-1 > Normalization
Consider the relation R(P, Q, S, T, X, Y, Z, W) with the following functional dependencies.
PQ -> X, P -> YX, Q -> Y, Y -> ZW
Consider the decomposition of the relation R into the constituent relations according to the following two decomposition schemes.
D1: R = [(P, Q, S, T); (P, T, X); (Q, Y); (Y, Z, W)]
D2: R = [(P, Q, S); (T, X); (Q, Y); (Y, Z, W)]
Which one of the following options is correct?
PQ -> X, P -> YX, Q -> Y, Y -> ZW
Consider the decomposition of the relation R into the constituent relations according to the following two decomposition schemes.
D1: R = [(P, Q, S, T); (P, T, X); (Q, Y); (Y, Z, W)]
D2: R = [(P, Q, S); (T, X); (Q, Y); (Y, Z, W)]
Which one of the following options is correct?
Correct : a
Similar Questions
A database of research articles in a journal uses the following schema.
(VOLUME, NUMBER, STARTPGE, ENDPAGE, TITLE, YEAR, PRICE)
The primary key is (VOLUME, NUM...
Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE ?
Given the following two statements: S1: Every table with two single-valued attributes is in 1NF, 2NF, 3NF and BCNF. S2: AB → C, D → E, E → C is...
Total Unique Visitors
Loading......