Re: Relationship Question

Logan wrote:
> Is the following a true and accurate statement within the context of a
> physical schema?
>
> "a foreign key constraint defines a relationship to another table"
>
> Thanks,
> Logan

It would be more accurate to say "enforces" rather than "defines". Relationships are represented by values within tuples within relations. A foreign key constraint is just one type of constraint (not the only one) for guaranteeing the integrity of certain binary relationships.

A foreign key is part of the logical model rather than the physical one.

-- 
David Portas