= 4 (5 points) Let R be a relation with attributes ABC. Consider the join dependency (JD) o = [AB, BC, CA]. Recall that
Posted: Thu May 12, 2022 12:09 pm
- 4 5 Points Let R Be A Relation With Attributes Abc Consider The Join Dependency Jd O Ab Bc Ca Recall That 1 (56.93 KiB) Viewed 20 times
up
= 4 (5 points) Let R be a relation with attributes ABC. Consider the join dependency (JD) o = [AB, BC, CA]. Recall that an instance I of R satisfies o if I = 1 AB(I) TBC(1) MACAI). Show by a direct proof that II( there is no set of MVDs over R that is equivalent to o. Hint: It is enough to find an instance I over ABC that satisfies o but does not satisfy any MVD over ABC.