Consider a relation scheme R = (A, B, C, D, E, H) on which the following…
Consider a relation scheme R = (A, B, C, D, E, H) on which the following functional dependencies hold: {A–>B, BC–>D, E–>C, D–>A}. Which one of the following is TRUE about the above schema?
- A.
The schema is in 3NF but not in BCNF
- B.
The schema is in BCNF
- C.
The schema is not in 2NF
- D.
The schema is in 2NF but not in 3NF
Attempted by 141 students.
Sign up free to check your answer
Sign up freeLoading lesson…

