Consider a relation schema R = (A, B, C). For each part below (note that each part
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider a relation schema R = (A, B, C). For each part below (note that each part is separate), supply a relation (table) T on R having just four rows and satisfying the given functional dependency (or dependencies) but NOT satisfying any other functional dependencies except trivial ones and those that are derivable from the given one(s). The values of the attributes in your rows should be lower-case letters with subscripts (e.g. a1, b3, c2).
a. A -> BC, B -> C
b. A -> BC
c. AB -> C
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: