Suppose you are given a relation R=(A,B,C,D,E) given below with the following…
Suppose you are given a relation R=(A,B,C,D,E) given below with the following functional dependencies: BD → E, A → C .
If the above relation R is decomposed into R1=(A,B,C) and R2=(D,E). Which is/are the correct statement?
- A.
Decomposition is incorrect
- B.
The decomposition is lossless
- C.
The decomposition is lossy
- D.
Cannot join the two relations because of no common attribute
Attempted by 79 students.
Sign up free to check your answer
Sign up freeLoading lesson…

