Re: Data Redundancy
From: x <x_at_not-exists.org>
Date: Thu, 16 Feb 2006 10:50:59 +0200
Message-ID: <dt1edn$ba1$1_at_nntp.aioe.org>
Date: Thu, 16 Feb 2006 10:50:59 +0200
Message-ID: <dt1edn$ba1$1_at_nntp.aioe.org>
"Jan Hidders" <jan.hidders_at_REMOVETHIS.pandora.be> wrote in message news:euOIf.259537$3u.7960634_at_phobos.telenet-ops.be...
> 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?
With a trigger, maybe.
As in an SQL DBMS in some cases like BCNF.
Received on Thu Feb 16 2006 - 09:50:59 CET