A relation R has five attributes ABCDE, with the following dependencies: A B, BC E, and ED
This problem has been solved!
Do you need an answer to a question different from the above? Ask your question!
A → B, BC → E, and ED → A.
a.) List one possible primary key from among the candidate keys for R. (6 points). REQUIRED: RATIONALE
b.) Given the dependencies above and the primary key you chose, is there a BCNF violation? (6 pts). REQUIRED: RATIONALE
Create a free account to access the answer
Cannot find your solution?
Post a FREE question now and get an answer within minutes. * Average response time.
Chapter # 14
Section: Review Questions
Posted Date: September 15, 2023 07:28:59