Home » Developer & Programmer » Designer » mapping resolving
mapping resolving [message #90442] Tue, 23 September 2003 11:49 Go to next message
Nandkishore Kadam
Messages: 1
Registered: September 2003
Junior Member
How to resolve one to one , many to many relations
while desiging the database.
Re: mapping resolving [message #90445 is a reply to message #90442] Thu, 25 September 2003 13:47 Go to previous message
Manish
Messages: 79
Registered: December 2000
Member
One to one is simple. Just decided which is the foreign key and build the tables.

for many to many you will have to build an intersection table between the two tables having the relationship.

The primary key of the intersection table will be the concatenated primary keys of both the tables.

HTH
Manish
Previous Topic: : when others probs thanks but some more clarification
Next Topic: TABLESPACES
Goto Forum:
  


Current Time: Wed Aug 23 05:15:52 CDT 2017

Total time taken to generate the page: 0.17015 seconds