retagged by
374 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
440 views
Answer -3.7
0 votes
0 votes
2 answers
2
SKMAKM asked Oct 21, 2022
366 views
Answer 1.18
0 votes
0 votes
0 answers
3
SKMAKM asked Oct 21, 2022
297 views
Answer 1.125
0 votes
0 votes
0 answers
4
SKMAKM asked Oct 20, 2022
541 views
Answer 3.12