retagged by
368 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
435 views
Answer -3.7
0 votes
0 votes
2 answers
2
SKMAKM asked Oct 21, 2022
356 views
Answer 1.18
0 votes
0 votes
0 answers
3
SKMAKM asked Oct 21, 2022
296 views
Answer 1.125
0 votes
0 votes
0 answers
4
SKMAKM asked Oct 20, 2022
533 views
Answer 3.12