Re: Is this bad design ?
Date: 9 Mar 2004 02:21:53 -0800
Message-ID: <c0e3f26e.0403090221.48b08766_at_posting.google.com>
"ben brugman" <ben_at_niethier.nl> wrote in message news:<404c9b34$0$281$4d4ebb8e_at_read.news.nl.uu.net>...
> Mother table.
> fields:
> mother_id
> still_valid boolean
> etc_fields
>
> Child table
> fields:
> mother_id
> still_valid boolean
> more_fields
>
>
> The child.still_valid field always contains a true, because only mothers
> withs are still_valid can have children, to enforce this; a relation is
> defined on the fields mother_id and still_valid.
> (A child can not exist without its mother).
>
> Because a field in the child table always has the same value, I think
> there is something wrong. But if this field is taken away a mother might
> become un_valid by another action.
>
> Is this bad design ?
> what is a alternative ?
>
> (As I understand constraints should be implemented in the RDBMS and
> not in the code).
>
> ben brugman
An alternative would be to use database triggers, but you would need triggers on both tables and all events that might lead to a violation. Received on Tue Mar 09 2004 - 11:21:53 CET