<div>
What exactly are you looking for? An example of the graphical representation of a data model? Or SQL code examples for each one of your requirements?
</div>


What exactly are you looking for? An example of the graphical representation of a data model? Or SQL code examples for each one of your requirements?

<div>
Graphical would be cool but if you can just indicate the foreign keys in the table description that's good. Thx much
</div>


Graphical would be cool but if you can just indicate the foreign keys in the table description that's good. Thx much

<div>
ScottPlecher:<br />
&nbsp; &nbsp; &nbsp;You haven't indicated the relationship 1to1 from B to B?
</div>


ScottPlecher:
     You haven't indicated the relationship 1to1 from B to B?

<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
&nbsp; I have a situation where there are two tables &nbsp;- Table A (a1 (PK)) and Table B (b1 (PK)) . <br />
I have business requirement to have the following relationships between the two tables. &nbsp;<br />
1) Many to Many relationship from A to A<br />
2) One to Many from B to A<br />
3) One to One from B to B<br />
<br />
&nbsp; &nbsp; &nbsp;Please let me know how can I model the best way.<br />
<br />
&nbsp; &nbsp; Also, I was trying to model the 3 relationships into one table cause the relationships have common attributes like start, end dates and codes. Please let me know if it is possible to model the above 3 relationships in one single table, and how?
</div>
</div>


Hi All

  I have a situation where there are two tables  - Table A (a1 (PK)) and Table B (b1 (PK)) . 
I have business requirement to have the following relationships between the two tables.  
1) Many to Many relationship from A to A
2) One to Many from B to A
3) One to One from B to B

     Please let me know how can I model the best way.

    Also, I was trying to model the 3 relationships into one table cause the relationships have common attributes like start, end dates and codes. Please let me know if it is possible to model the above 3 relationships in one single table, and how?

How to model 3 relationships into one table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

A modeling language is any artificial language that can be used to express information or knowledge or systems in a structure that is defined by a consistent set of rules. The rules are used for interpretation of the meaning of components in the structure; modeling languages can be either graphical or textual. The Unified Modeling Language (UML) is a general-purpose, developmental, modeling language in the field of software engineering, that is intended to provide a standard way to visualize the design of a system.