| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: logical differing from physical
You will need an 'attibutive' or 'intersection' table to
resolve the M-M relation.
Logical:
\|/
|
|
|
|
/|\
-------------
| |
| |
| b |
| |
| |
Physical:
| |
| |
| intersection |
| |
| |
-----------------
\|/ \|/
| |
| |
| |
| |
| |
------------- -------------
| | | |
| | | |
| a | | b |
| | | |
| | | |
------------- -------------
Jared
On Wed, 23 Aug 2000, Weaver, Walt wrote:
> Guess I'll have to show a bit of ignorance here. Why would this take 3 > tables to implement properly? > > --Walt Weaver > Bozeman, Montana USA > > -----Original Message----- > Sent: Wednesday, August 23, 2000 10:48 AM > To: Multiple recipients of list ORACLE-L > > > 4. Many to Many relationships. This only requires 2 tables > to model, but at least 3 to implement. ( properly ) > > > Many more I'm sure, but this illustrates the point. > > Jared > -- > Author: Weaver, Walt > INET: wweaver_at_rightnowtech.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). >
Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-)
Regence BlueCross BlueShield of Oregon
Received on Wed Aug 23 2000 - 15:22:48 CDT
 |
 |