Re: Need some help in data design

always-the-correct-answer, _at_, comp.databases.theory wrote:
>
> Kyle Lahnakoski <kyle_at_arcavia.com>
>
> >
 

> > One poster suggested a single table, but I am sure that there
 are some
> > attributes that are common to all items. I will suggest two
> tables.
>
> Since you don't get it, do two tables first, then stare at it for
> several days, and you will see how to put the two tables into
> just one table.

Yes, one table could be used for everything. Makes you wonder why so much theory goes into DBs when a simple table can store everything. Maybe there are reasons?

-- 
----------------------------------------------------------------------
Kyle Lahnakoski                                  Arcavia Software Ltd.
(416) 892-7784                                 http://www.arcavia.com