Re: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?

From: Bob Badour <>
Date: Tue, 25 Feb 2003 02:43:46 -0500
Message-ID: <QxF6a.333$>

"Mikito Harakiri" <> wrote in message news:KVz6a.16$
> "Bob Badour" <> wrote in message
> news:YcX4a.103$
> > > Database A and B together can be viewed as a distributed database.
> > is
> > > a redundancy here: the data in both tables should be maintained in
> >
> > Strictly speaking, it's not possible to keep them in sync because a user
> can
> > insert a phone in phones without a fax. Contacts cannot represent this,
> and
> > what you claimed was a reverse mapping is not a reverse mapping.
> The view
> select id, 'VOICE' type, voice phone
> from contact
> union
> select id, 'FAX' type, fax phone
> from contact
> implies the following constraint
> For any 'id' and 'num' such that tuple
> <id, 'PHONE', num> is in the 'phones' view
> there exists 'num1' such that <id, 'FAX', num1> is in the 'phones' view as
> well.

That may be, but it does not match the predicate of the table it simulates in the other database, nor does the contact table have a predicate enforcing this. Received on Tue Feb 25 2003 - 08:43:46 CET

Original text of this message