Referential integrity should be maintained by the program (programmer) using
the file handler/database.
We design all of our schemas with a Parent/Child hierarchy in mind. We
always have a unique key and there is always a column or key in common where
any relationship exists or could exist between tables.
Consider an invoice with a 1-many relationship. Header information
regarding the sold to, ship to, etc.. and the Detail containing the items,
quantity, etc... . These two tables would have an invoice number
field/column in common. The program used to Add,Edit,Delete would enforce
the relationship, thereby, maintaining referential integrity.
The concept of a DBA (read 'not a programmer') attempting to enforce
referential integrity by pure schema design without consideration of the
applications designed to use the data or the unlimited creativity of the
end-user at the keyboard over simplifies the process and itself imposes data
integrity questions.
Pat...
.
----- Original Message -----
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 14, 2001 9:28 PM
Subject: Re: Relationships???
> If you are really after referential integrity then perhaps you should
> consider another database or you could always modify the code.
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 15, 2001 8:32
> Subject: Relationships???
>
>
> > Hello all,
> >
> > Without explicitly creating foreign keys, what is the most common method
> to
> > create a truly relational database that enforces referential integrity?
> >
> > Any responses to this question are greatly appreciated!
> >
> > Sincerely,
> >
> > N. Silverwise
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
