How to find all mvd's in this table.i know mvd defination according to that we let t1,t2,t3,t4 in table but in this table ,which tuple we take t1,t2,t3,t4 .and how defination of.mvd constraints satisfy
Here is two MVD.
1) Sid ->> Cid
2) Sid ->> Pno
We have to check if there exist for a single value of Sid, there exist multiple value in Cid. If there exist then it form MVD. Read this article for more information.