Normalization and ACID properties aren't academic trivia, they're the difference between a schema that survives five years of feature creep and one that collapses under its own joins. I put together everything I actually use when designing databases, including how Slowly Changing Dimensions save you from historical da...
Open this link in a browser to read the full article.