S1: Every attr is the prime attribute then the relation is in 3nf
R(A, B , C, D) = { A -> C, C -> A, B - > D, D -> B}
KEY AB, CD
PRIME ATTR A, B, C, D.
HENCE STATEMENT 1 IS TRUE.
S2: Every attribute is the prime attribute then the relation is in BCNF,
consider the above case only, the relation is in 3nf not in BCNF.
Hence statement 2 is False.
S3: R(A,B,C,D) {A -> BCD, B - > ACD, C ->D, D-> C}
KEY A, B
here there is no case of partially dependency because, we have simple cand key, means single attributes candidate key,
So, statement 3 is also true,
Seeing the options,
D) S2 is false,
Is the correct option.
