Consider a relation with schema R (A, B, C, D) and FDs the set F: F=...

  

Transcribed Image Text:

Consider a relation with schema R (A, B, C, D) and FDs the set F: F= { a. b. C. d. } AB-C C-D DA Find all the candidate keys of R. Indicate all BCNF violations for R. Decompose the relations into collections of relations that are in BCNF. Indicate which dependencies, if any, are not preserved by the BCNF decomposition. Consider a relation with schema R (A, B, C, D) and FDs the set F: F= { a. b. C. d. } AB-C C-D DA Find all the candidate keys of R. Indicate all BCNF violations for R. Decompose the relations into collections of relations that are in BCNF. Indicate which dependencies, if any, are not preserved by the BCNF decomposition.