retagged by
364 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
434 views
Answer -3.7
0 votes
0 votes
2 answers
2
SKMAKM asked Oct 21, 2022
354 views
Answer 1.18
0 votes
0 votes
0 answers
3
SKMAKM asked Oct 21, 2022
293 views
Answer 1.125
0 votes
0 votes
0 answers
4
SKMAKM asked Oct 20, 2022
529 views
Answer 3.12