Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Relational database comments
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 LabReceived on Fri Jun 08 2007 - 06:33:24 CDT
![]() |
![]() |