Look again at the dimensions in Figure 4-1. These three tables are clearly denormalized (i.e., in zero normal form), as they should be. But DBA instincts being what they are, far too often mistakenly attempt to normalize star schema designs. In effect, they try to apply OLTP logic to their data warehouse. In data warehousing parlance, such forced normalization attempts are called snowflakes. Let's look at a snowflake example to avoid.
First, the PRODUCT dimension clearly violates third normal form (i.e., a non-key column depends on another non-key column) in three places:
MFG_NAME depends entirely on MFG_CODE.
CATEGORY_NAME depends entirely on CATGEORY_CODE.
SUBCATEGORY_NAME depends entirely on SUBCATEGORY_CODE.
Likewise, the LOCATION ...