Contact hobbies
contactid |
firstname |
lastname |
hobbies |
1639 |
George |
Barnes |
reading |
5629 |
Susan |
Noble |
hiking, movies |
3388 |
Erwin |
Star |
hockey, skiing |
5772 |
Alice |
Buck |
|
1911 |
Frank |
Borders |
photography, travel, art |
4848 |
Hanna |
Diedrich |
gourmet cooking |
In the above table, hobbies are the multivalued attributes.The problem with doing it is that it is now difficult (but possible) to search the table for any particular hobby that a person might have. Multivalued attributes need a separate table so in my example we have only one Multivalued attribute(hobbies), But in your example there will be 5 tables which will be T1(A,B,C), T2(A,D), T3(A,E), T4(A,F), T5(A,G).
Hobbies
contactid |
hobby |
1639 |
reading |
5629 |
hiking |
5629 |
movies |
3388 |
hockey |
3388 |
skiing |
1911 |
photography |
1911 |
travel |
1911 |
art |
4848 |
gourmet cooking |