Question 2 a) Consider the table below: в С A bi b2 ai Ci ai C2 b3 b3 a2 Ci a2 C2 For each of the functional dependencies listed below, indicate whether it holds or not. If it holds, write OK. If it...


Please show your solution.


Question 2<br>a) Consider the table below:<br>в С<br>A<br>bi<br>b2<br>ai<br>Ci<br>ai<br>C2<br>b3<br>b3<br>a2<br>Ci<br>a2<br>C2<br>For each of the functional dependencies listed below, indicate whether it holds or<br>not. If it holds, write OK. If it does not hold, indicate two tuples in the table above<br>that violate the functional dependency. Refer to the tuples as 1,2,3,4; for example,<br>+you may say that A → C fails because of the tuples 3,4.<br>FD<br>Holds?<br>В — А<br>C-A<br>А — В<br>С — В<br>A - C<br>В — С<br>ВС — А<br>АС — В<br>АВ — С<br>

Extracted text: Question 2 a) Consider the table below: в С A bi b2 ai Ci ai C2 b3 b3 a2 Ci a2 C2 For each of the functional dependencies listed below, indicate whether it holds or not. If it holds, write OK. If it does not hold, indicate two tuples in the table above that violate the functional dependency. Refer to the tuples as 1,2,3,4; for example, +you may say that A → C fails because of the tuples 3,4. FD Holds? В — А C-A А — В С — В A - C В — С ВС — А АС — В АВ — С

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here