Re: entity relationship question

Harold Gray wrote:
>
> This is a rather trivial question that has bugged me and is mentioned quite
> a bit in certification materials.
>
> I was wondering if someone out there could tell me the difference between a
> one-to-many and a many-to-one relationship concerning entities. Is it not
> just reflective of the order the entity is described?
>
> Thanks in advance!!
> Harold

Philosophically ... its just order in "entity space". Makes a -big- difference how you represent the relationships in tables, though ...

if A is one to many B, then a foreign key for A must be on the B table -- and conversely if A is many to one B, then a foreign key for B must be on the A table.

• sooz