Re: Designer/2000 ERD Cardinalities

>
>Oracle Entity-Relationship Modeling Convention:
>--------------------------------------------------------------------
>
>Each Source Entity [May be or Must be] relationship name [one and only
>one or one or more] destination entity.
>
>--------- Has ----------
>| E1 | >------------- - - - - - | E2 |
>--------- Belongs To ----------
>
>E2 Belongs To One or More E1 or E2 Belongs To atleast one
>possibly many E1
>E1 May have one and only one E2
> ---

Not quite, let me change it to be clearer....

  _________    on                                       ________ 
  |LINE ITEM| >----------------- - - - - - - - - -  |ORDER | 
  |_________|                        composed of  |_______|

would be read as "EACH LINE ITEM MUST BE ON ONE AND ONLY ONE ORDER" and "EACH ORDER MAY BE COMPOSED OF ONE OR MORE LINE ITEMS". -JJ

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456  Internet: jmjacobs_at_ix.netcom.com     Received on Tue Jan 07 1997 - 00:00:00 CET