Question: //Database Management Suppose that we have the following three tuples in a legal instance of a relation schema S with attributes primary_key, A, B and
//Database Management
Suppose that we have the following three tuples in a legal instance of a relation schema S with attributes primary_key, A, B and C
| attribute names | primary_key | A | B | C |
| tuple 1 | 1 | 4 | 1 | 4 |
| tuple 2 | 2 | 8 | 3 | 7 |
| tuple 3 | 3 | 8 | 2 | 5 |
For each of the following dependencies, can you infer whether or not it holds over schema S? Why or why not?
1. A -> C
2. C -> A
Can you identify any functional dependencies that hold over fields A, B and C? If so, please name one.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
