Consider a relation R with 6 attributes S, U, N, D, A, Y. You are given the following Functional Dependencies:
SA à Y
UNà A
U à S
SA à U
S à D
R is in 1NF so one student first decomposes the relation R into R1(S,A, Y ) and R2(S, U, N, D, Y), he concludes that:
(a) this decomposition is lossless join
(b) R2(S, U, N, D, Y) is in BCNF
(c) this decomposition is dependency preserving
State whether each of his conclusions is true or false and justify very concisely.
(a). Answer:
(b) Answer:
(c) Answer:
