Repeat Exercise 10.26 for the following different set of functional dependencies G = HA, B} -7 {C}, {B, D} -7 {E, F}, {A, D} -7 {G, H}, {A} -7 {l}, {H} -7 {l}}. Consider the following relation: a....



Repeat Exercise 10.26 for the following different set of functional dependencies


G = HA, B} -7 {C}, {B, D} -7 {E, F}, {A, D} -7 {G, H}, {A} -7 {l}, {H} -7 {l}}.


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 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?



May 26, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here