Course Discussion Forum

Normalisation is taught as a fundamental principle of good database design — yet many production databases, especially in data warehousing and analytics, are deliberately denormalised. Research the concept of a 'Star Schema' used in data warehousing. Draw a simple star schema for a Nigerian bank's transaction reporting database and explain why denormalisation is acceptable in this context. What would be the consequences of fully normalising a data warehouse?