The Gateway to Computer Science Excellence
+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

in Databases by Active (1.5k points) | 114 views

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. 

Why cid-->>pno
Its 3 MVD's na

Sid -> Cid

Sid -> Pno

Cid -> Pno

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,741 questions
57,251 answers
104,685 users