Answer to Question #50242 in Other Engineering for Sam

Question #50242
Given the following relational instance, A B C 1 2 3 3 1 2 1 3 2 4 1 5 Which of the following functional dependencies are satisfied? i) A -> B ii) B -> C iii) A-> C
Expert's answer
A functional dependency is a constraint between two sets ofattributes in a relation from a database.
Given a relation R, a set ofattributes X in R is said to functionally determine another
set of attributes Y, also in R, (written X → Y) if,
and only if, each X value is associated with precisely one Y
value; R is then said to satisfy the functional
dependency X → Y.
So, in our case, dependency A-> C is
That's why, the right answer is
iii) A-> C

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be first!

Leave a comment

Ask Your question

New on Blog