search
Log In
1 vote
131 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 131 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.

Related questions

0 votes
0 answers
1
161 views
A.dep-->>job B.dep-->>part C.both a and b D.none of these
asked May 6, 2016 in Databases Sourabh Kumar 161 views
0 votes
1 answer
3
534 views
Multi Valued Dependencies(MVD) satisfied by relation R(A,B,C) with tuples: (a1,b1,c1),(a1,b1.c2), (a2,b1,c1), (a2,b1,c3) A⇢⇢B B⇢⇢A, BC⇢⇢A, B⇢⇢AC
asked Jul 4, 2016 in Databases gate_forum 534 views
31 votes
3 answers
4
4.6k views
Consider the following implications relating to functional and multivalued dependencies given below, which may or may not be correct. if $A \rightarrow \rightarrow B$ and $A \rightarrow \rightarrow C$ then $A \rightarrow \rightarrow BC$ if $A \rightarrow B$ and $A \rightarrow C$ then ... $A \rightarrow \rightarrow C$ Exactly how many of the above implications are valid? $0$ $1$ $2$ $3$
asked Oct 30, 2014 in Databases Ishrat Jahan 4.6k views
...