Re: How to prevent updates on foreign key default values

On Sun, 7 Oct 2001, richdillon_at_mindspring.com wrote:
> Christoffer,
>
> The problem here is that, by your business definition, the
> relationship between students and schools is optional -- a student
> may be entered without a school. Yet you are defining the
> relationship in the database as required and this is forcing the
> workaround of adding a bogus entry into the schools table (which
> might be better named "schools_and_misc_codes" as a result).
>

Yes. You are right. That is how I should have modeled this relationship. You have also made likely the fact that you are a human being by being able to identify 'NOT REGISTERED' as not a proper kind of school. Additional evidence is provided through your solution being based on the specific example I gave rather than on my general problem. For things would have been different if my preferred default was 'OKLAHOMA PRISON SCHOOL'. How can I ensure that this value is not changed?

Christoffer Received on Sun Oct 07 2001 - 15:50:27 CDT