in Databases retagged by
134 views
1 vote
1 vote

Please Explain

ans is 8

in Databases retagged by
134 views

1 comment

@Amit Mehta This video will solve all your remaining doubts too. 

136. 4th normal form - YouTube

1
1

1 Answer

2 votes
2 votes
Best answer

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

1 comment

correct 👍 got the same!
1
1