[thelist] normalizing an abnormal table

Jacques Capesius jacques_capesius at cnt.com
Mon Oct 14 22:15:01 CDT 2002

- Promotion_Item_ID (PK, int, identity)
- Promotion_ID (FK, int)
- Product_ID (FK, int)
- Price_Domestic (money) *
- Price_Domestic_Premier (money) *
- Price_Intl (money) *
- Price_Intl_Premier (money) *
- Rate_Code_Domestic (varchar 10) *
- Rate_Code_Domestic_Premier (varchar 10) *
- Rate_Code_Intl (varchar 10) *
- Rate_Code_Intl_Premier (varchar 10) *
- Promotion_Item_Insert_Date (datetime)

Being that I'm one of those guys who think that normalization isn't all that
it's cracked up to be, especially where concerns e-commerce sites, a thing
you might want to consider doing is leaving this table abnormal. Insert an
extra attribute, that Is_Premier field into this table. That way, you can
get the premier and non premier pricing without having to do a join, which
will improve your website performance, especially as it starts to get a
lotta traffic.

Just my two bits. HTH

More information about the thelist mailing list