| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: The Practical Benefits of the Relational Model
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 01Received on Fri Nov 08 2002 - 05:25:38 CST
![]() |
![]() |