Consider the following relation: a. Given the previous extension (state), which of the following dependencies may hold

Question:

Consider the following relation:
Consider the following relation:
a. Given the previous extension (state), which

a. Given the previous extension (state), which of the following dependencies may hold in the above relation? If the dependency cannot hold, explain why by specifying the tuples that cause the violation.
i. A†’B,
ii. B†’C,
iii. C†’B,
iv. B†’A,
v. C†’A
b. Does the above relation have a potential candidate key? If it does, what is it? If it does not, why not?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Data Modeling and Database Design

ISBN: 978-1285085258

2nd edition

Authors: Narayan S. Umanath, Richard W. Scammel

Question Posted: