Hi,
If we get many to many relation ship while we r designing the database what do we do.
Please give me the exact answer.
Cheers,
Printable View
Hi,
If we get many to many relation ship while we r designing the database what do we do.
Please give me the exact answer.
Cheers,
Well, the 'exact answer' is to go to your Data Modeling material and look up "Associative Entity". An associative entity is a result of taking a many-to-many relationship, creating a new entity and having the two original entities each in a relationship with the associative entity 1-to-many.
Berfore:
E1 (m)----------------------(m) E2
After:
E1 (1)-----------(m) New Associative Entity (m)---------(1) E2
duplicate thread, closing... http://www.dbasupport.com/forums/sho...threadid=27864