Quoth andrew.ge...@gmail.com (Andrew Geery):
>
> I have a question about checking a constraint that is spread across multiple
> (in the example below, two) tables. In the example below, every food (food
> table) is in a food group (food_group table). For every person (person
> table), I want to
Andrew Geery wrote:
> [...]
> My questions are:
> (A) Is there a way to check (2) above using a constraint and not a trigger?
> (B) Is there an easier way to solve this problem? Does the complicated
> nature of the solution make the design poor?
> (C) Should I not worry about this constraint at
I have a question about checking a constraint that is spread across multiple
(in the example below, two) tables. In the example below, every food (food
table) is in a food group (food_group table). For every person (person
table), I want to enforce the constraint that there can only be one food i
