OraFAQ Forum: Designer » how to design table for m:m relationships?

Home » Developer & Programmer » Designer » how to design table for m:m relationships?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to design table for m:m relationships? [message #26044]

Thu, 05 June 2003 03:06

Freeman
Messages: 1
Registered: June 2003

Junior Member

how to design table for m:m relationships?
for example:
there are some dramas and artists involved in the dramas, it means Artist_A may involve in Drama_A, Drama_B, Artist_B may involve in Drama_B, Drama_C;
Then Drama_B has two artists there.
How can I solve it??

Report message to a moderator

Re: how to design table for m:m relationships? [message #26045 is a reply to message #26044]

Thu, 05 June 2003 04:05

amit zhankar
Messages: 31
Registered: March 2003

Member

Hi,

You can use this design

1. Drama Master
drama_code
drama_desc
2. Artist_master
artist_code
artist_desc
3. drama_artist_link ( Detail Table )
drama_code
artist_code

try this this can solve ur problem

amit

Report message to a moderator

Previous Topic:	API for Designer 6i
Next Topic:	database design

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 13:27:46 CST 2024