retagged by
360 views

1 Answer

Best answer
2 votes
2 votes

https://gateoverflow.in/3512/gate-it-2007-question-67

According to multivalued dependency definition.

SSN -> -> CollegeName means

If we have the below tuples

SSN CollegeName Hobby
100 Global Academy Of Technology Music
100 SJBIT Swimming

then we also need to have the below two tuples.

SSN CollegeName Hobby
100 Global Academy Of Technology Swimming
100 SJBIT Music

 

So ans can be:-

0 1 6
0 1 4
0 5 2
0 5 4
0 9 2
0 9 6
1 2 2
1 3 3

 

selected by

Related questions

0 votes
0 votes
0 answers
1
SKMAKM asked Oct 22, 2022
429 views
Answer -3.7
0 votes
0 votes
2 answers
2
SKMAKM asked Oct 21, 2022
351 views
Answer 1.18
0 votes
0 votes
0 answers
3
SKMAKM asked Oct 21, 2022
292 views
Answer 1.125
0 votes
0 votes
0 answers
4
SKMAKM asked Oct 20, 2022
527 views
Answer 3.12