Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Relational database comments

Re: Relational database comments

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Fri, 08 Jun 2007 07:33:24 -0400
Message-ID: <5cst40F32l5f6U1@mid.individual.net>


muddu wrote:
> One of the properties of a relation or table is that every row is
> unique. If this is so,
> what do we do with a table of comments?
>
> Let's say, i want to put comments on a play in a relation. Two
> different people say
> "It was a great play". They both say exactly the same words. How
> can we put both comments
> in the relation if we must have uniqueness?
>

If you want to preserve which person said what then the persons make the row unique.
If you don't want to preserve which person said what, then there is indeed no need for the extra row.

Just my 2 cents
Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Fri Jun 08 2007 - 06:33:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US