Question: Consider the following relation: a. Given the previous extension (state), which of the following dependencies may hold in the above relation? If the dependency cannot
.png)
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. AB,
ii. BC,
iii. CB,
iv. BA,
v. CA
b. Does the above relation have a potential candidate key? If it does, what is it? If it does not, why not?
A | B | C | TUPLE# 10 b1 c1 10 b2 c2 22 11 b4 c1 13 b1 c1 14 B3 C46
Step by Step Solution
3.43 Rating (166 Votes )
There are 3 Steps involved in it
a 1 A B does not hold good in current state of relation as attribute ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1013-C-S-O-S (804).docx
120 KBs Word File
