64 757
Assignments Done
99,3%
Successfully Done
In September 2018

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
satisfied.
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!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions