The Gateway to Computer Science Excellence
+1 vote
114 views

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
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. 

0
Why cid-->>pno
0
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
198,057 comments
104,685 users