Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: normalization problems

Re: normalization problems

From: Kai Gro▀johann <Kai.Grossjohann_at_CS.Uni-Dortmund.DE>
Date: 29 Dec 2000 00:36:48 +0100
Message-ID: <vafbstwce3z.fsf@lucy.cs.uni-dortmund.de>

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
Received on Thu Dec 28 2000 - 17:36:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US