Re: The Practical Benefits of the Relational Model

From: Leandro Guimarães Faria Corsetti Dutra <lgcdutra_at_terra.com.br>
Date: Fri, 08 Nov 2002 12:25:38 +0100
Message-ID: <aqg6vi$9nj79$2_at_ID-148886.news.dfncis.de>


Paul Vernon wrote:

> The idea being (I think) that any two projections that have the same
> predicate should also have the same value.
>
> So if we have P (Part PART_#, Part_name STRING) S (Supp SUPPLIER_#,
> Part PART_#)
>
> Then SELECT Part FROM S should equal SELECT Part FROM P
>
> as they have the same predicate.

        But, they do? The predicate to a relvar would be all its constraints.   Without knowing all the constraints to P and S, we can't know if their projections on Part have the same predicate.

-- 
  _
/ \ Leandro Guimarães Faria Corsetti Dutra        +41 (21) 216 15 93
\ / http://homepage.mac.com./leandrod/        fax +41 (21) 216 19 04
  X  http://tutoriald.sourceforge.net./      Orange Communications CH
/ \ Campanha fita ASCII, contra correio HTML      +41 (21) 644 23 01
Received on Fri Nov 08 2002 - 12:25:38 CET

Original text of this message