From the following instance of a relational schema R(A,

Home » Database » Database miscellaneous » Question

From the following instance of a relational schema R(A, B, C), we can conclude that

1. A functionally determines B and B functionally determines C
2. A functionally determines B and B does not functionally determine C
3. B does not functionally determine C
4. A does not functionally determine B and B does not functionally determine C

Correct Option: C

Generally Normalization is done on the schema itself. From the relational instance given,we may strike out FD s that do not hold.
e.g.B does not functionally determine C(This is true). But we cannot say that A functionally determines B for the entire relation itself.This is because that, A → B holds for this instance,but in future there might be some tuples added to the instance that may violate A → B. So overall on the relation we cannot conclude that A → B,from the relational instance which is just a subset of an entire relation.