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: which is the beter way to design a database
Next Topic: Range Value for SORT AREA Parameter in 9i
Goto Forum:
  


Current Time: Tue Mar 19 05:17:05 CDT 2024