-
Hi all,
When we r designing the database if we get the situation like many to many relation ship what do we do.
Please give me the answer as soon as possible.
Cheers.
-
You would add another table to handle the many-many mappings.
Suppose we have 2 table: fish and fish_food
Fish:
ID NAME
1 trout
2 bass
Fish_Food:
ID NAME
1 worms
2 minnows
3 bugs
4 frogs
A new table, fish_food_mapping, could be created to relate fish and fish_food
Fish_Food_Mapping:
Fish_ID Fish_Food_ID
1 1
1 2
1 3
2 2
2 4
Don't forget about PK and FKs in the mapping table.
--
Paul
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|