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!
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
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
View Solution
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.
Question Details
Chapter #
14
Section: Review Questions
Problem: 37
Posted Date: September 15, 2023 07:28:59