Re: Data Redundancy

From: x <x_at_not-exists.org>
Date: Thu, 16 Feb 2006 10:50:59 +0200
Message-ID: <dt1edn$ba1$1@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 - 02:50:59 CST