Tuples

Question

Consider a relation R(A,B,C) with the following functional dependency AC→B .A can take 200 distinct values, B can take 100 distinct values and C can take 1000 distinct values. What is the maximum and minimum possible tuples of the self join of R on C?

Comments

Since AC is key here , A can take 200 distinct values, C can take 1000 distinct value hence 200*1000=200000 (AC) And Since B can take 100 distinct values,each one of AC key will have 1 B,200000*100 Upon self join on C each tuple from AC will have 100 choices

I don't feel sure about this.

Do you have answer?

---

can u explain how you got this ?