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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: which is the beter way to design a database
Next Topic: Range Value for SORT AREA Parameter in 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 00:56:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.