Re: Relational database comments

From: Carlos <miotromailcarlos_at_netscape.net>
Date: Fri, 08 Jun 2007 01:23:02 -0700
Message-ID: <1181290982.858587.109890@g4g2000hsf.googlegroups.com>

On 8 jun, 09:51, muddu <mudassar...._at_gmail.com> 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?

Surrogate keys.

HTH Cheers.

Carlos. Received on Fri Jun 08 2007 - 03:23:02 CDT