Consider a relation R with attributes ABCDEFG, and functional dependencies F-[BGAC, ABGDF, AG, DE, EC). Which...

 

Transcribed Image Text:

Consider a relation R with attributes ABCDEFG, and functional dependencies F-[BGAC, ABG→DF, A→G, D→E, E→C). Which of the following is true for R? Select all that apply. R is not in BCNF BDG is a super key AD is a candidate key Ris in 3NF Consider a relation R with attributes ABCDEFG, and functional dependencies F-[BGAC, ABG→DF, A→G, D→E, E→C). Which of the following is true for R? Select all that apply. R is not in BCNF BDG is a super key AD is a candidate key Ris in 3NF

Answer rating: 100% (QA)

Ans The correct ans is option B BDG is a super key Explanation The candidate key g... View the full answer