Home » Developer & Programmer » Designer » modelling
modelling [message #259753] Thu, 16 August 2007 07:00 Go to next message
Messages: 6
Registered: August 2007
Location: Hyderabad
Junior Member
Hi all,

Hereby i am attaching sample data model with one-to-many relationships.I want to set it as application with system as many-many relationship.could you please suggest me how do i set it as many-to-many relationships.

thanks in advance

  • Attachment: model.xls
    (Size: 19.00KB, Downloaded 438 times)
Re: modelling [message #281883 is a reply to message #259753] Mon, 19 November 2007 17:26 Go to previous message
Messages: 11
Registered: November 2007
Junior Member

You may have a solution already.

In general, the way you model a many to many relationship is through the creation of an intersection table. This is an artificial table that may contain no data other than the fact that the two items in question are related, or you may choose to add attributes that define the nature of their relationship or something else entirely.

In your example you have tables MD_SYSTEM and MS_APPLICATION. To create a many-to-many relationship you could create a table called MD_APPLICATION_SYSTEM. This is often modelled as having a composite primary key made up of the primary keys of the two related tables, which double up as foreign keys. In your example this would be SYSTEM_ID and APPLICATION_ID.

Does this answer your question?

Previous Topic: Table Design for Billing purpose
Next Topic: What is user's pre qualification to connect to Oracle Designer
Goto Forum:

Current Time: Sat Aug 19 19:34:34 CDT 2017

Total time taken to generate the page: 0.30012 seconds