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
Messages: 79
Registered: December 2000
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.

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: Sat Jul 31 07:23:41 CDT 2021