Re: normalization problems

On Thu, 21 Dec 2000, Karen Osmond wrote:

> The Product_Category table is really a workaround so that I can tell
> which category table I need to look in to find more data on a product.
> So I would be hardcoding in something like:
> if (tableref='OLAP') {
> SELECT * FROM OLAP...
> }
> etc

Why do you need that table? Since the product number or id should be a primary key in all tables, it should be pretty fast to search for it. Hence, you could just do a `select' for the product on each of the category tables, and if that comes back nonempty you know that the product is in that category.

Or you just put it all in one table, that will introduce lots of null values but otherwise it'll still be normalized, I think.

kai

-- 
~/.signature