DataBase Normalization Approach

[RushiShroff]

I recently posted one question of finding out no of Subcategories within a particular category.

Now I have right now this database structure.In short

Master Tables
1) m_Category
-Cat_Cd(PK)
-Cat_Name

2) m_SubCategory
-Cat_Cd
-SubCat_Cd
(Above fields Composite PK)
-SubCat_Name

Transaction Table
t_Offers
-Offer_Cd(PK)
-Cat_Cd(FK to m_Category)
-SubCat_Cd(FK to m_SubCategory)
-Offer_Desc

I dont think this is the right way of doing database normalization in this case ??Anyhow It was not done by me !!

Anymore suggestions from experts,SQL masters for better approches are welcome.

Rushi Shroff

 

[derren]

Rushi

The only part of the tables which does not follow strict normalisation rules is that you have Cat_cd in your transaction table, where you could say that you can get the cat_cd from looking at the sub category table. Other than that it is spot on.

It is a classic database structure for this type of setup and I suspect the only "improvements" will simply be a variation on what you already are using. Derren
[The only person in the world to like Word]