Re: Designer 2000, use of foreign keys

Dan:

I hope you don't take this wrong but
[Quoted] please be careful with your terms. "Dependant" entities are not represented through simple FK relationships. The logical dependant relationship is represented in ERDs with the following symbol:

• - - ------------------|<

The vertical bar is frequently called a "UID bar" because of the way Des2K implements dependant relationships.

I don't mean to go crazy on terminology but the posting was from a beginner and it is important to not give them inaccurate terms.

Paul Dorsey
Dulcian, Inc.

> >
> Right. The way it works is the entity on the "from" end of the realation
 ship
> gets the added column. For example:
>
> ------------ -----------
> | Dept | | Emp |
> | |- - - - ------------<| |
> | | | |
> ------------ -----------
>
> Where the relationship is "from" EMP "to" DEPT. The EMP table would get
 the UID
> of the DEPT table as a column when the tables are created. Basically
 what you
> are doing is telling the design tool that the entity on the "from" end is
> dependant on the entity on the "to" end.
>
> Hope this helps!
>
> Dan Peacock, CNA
> Systems Engineer
> Great Lakes Hybrids, Inc.
>
  Received on Mon Oct 06 1997 - 00:00:00 CEST