| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: Many to Many relationships
Peter,
Unlike Access, Oracle doesn't care about the cardinality of your relationships. There is no way to specify a 1:1, 1:M, or M:N relationship in Oracle. So the answer to your question is that there is no joining table required. You can use one if you want though...
HTH,
Brian
Peter Mount wrote:
>
> Hello
>
> I have just recently started to learn Oracle at my school.
>
> I just need to know if Oracle handles Many to Many relationships in the ER
> Diagram (as part of the Data Modelling process) in the same way as MS
> Access - i.e. with a joining table in between the two tables with the many
> to many relationship with each other.
>
> Thanks
>
> Peter Mount
> pmount_at_optusnet.com.au
--
 |
 |