Re: Relational database comments

> > 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.

Although one could say, that if these comments were added at a different time (eg: different performance of the play), that would make them unique.

:-)

-- 
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com