Re: Data Redundancy
From: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Wed, 15 Feb 2006 23:06:50 GMT
Message-ID: <euOIf.259537$3u.7960634_at_phobos.telenet-ops.be>
Date: Wed, 15 Feb 2006 23:06:50 GMT
Message-ID: <euOIf.259537$3u.7960634_at_phobos.telenet-ops.be>
B Faux wrote:
>
> In my world (MV), you would have an employee file (table) with a department
> attribute (row) that allows for an unlimited number of departments. Then
> you would also have a department file that would allow for an unlimited
> number of employees.
Just out of curiosity, in which MV DBMSs would it be possible to specify a declarative integrity constraint that said that one relationship (emp->dept) is the inverse of the other relationship (dept->emp)? Or how else would you prevent inconsistency in your database?
- Jan Hidders