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.

1 vote

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

0

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.