Answers to Selected Questions and Problems

Normalization of dimensional tables achieves semantic simplicity and facilitates end-user navigation through the dimensions. For example, if the location dimension table contains transitive dependencies between region, state, and city, those relationships can be revised to the third normal form (3NF). ................
................