Saturday, June 8, 2013

Handling Many-to-Many relationship in relational model

When doing database design with logical model, we are allowed to create many-to-many (M:N) relationship.
M:N relationship ER modeling

But M:N relationship is not available in relational model. 

In this case, we have break the many-to-many relationship to two (2) one-to-many (1:M) relationship and add an intermediary in between the two entities.
M:N relationship relational modeling
With the above design, TABLE_1 and TABLE_2 are connected, with the M:N relationships stored in the INTERMEDIARY table. 

Oracle SQL Developer Data Modeler

M:N or many-to-many relationships could be easily handled by Oracle SQL Developer Data Modeler with the following steps:

1. Make sure that M:N logical data model has been created in Oracle SQL Developer Data Modeler.
2. click on the Engineer to Relational Model button ()
3. Choose required options > click Engineer.
Engineer to Relational Model dialog



  1. This comment has been removed by a blog administrator.

  2. Thanks for providing recent updates regarding the concern, I look forward to read more. como conquistar um homem

  3. hello!! Very interesting discussion glad that I came across such informative post. Keep up the good work friend. Glad to be part of your net community. como conquistar um homem

  4. Notwithstanding, machine information investigation is simply in its commencement organize, which makes it all the additionally energizing!Data Analytics Courses

  5. It is imperative that we read blog post very carefully. I am already done it and find that this post is really amazing. ExcelR Data Analytics Course

  6. I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end.
    Data Analytics Courses In Pune



Related Posts Plugin for WordPress, Blogger...