Dimensional Design

When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.

This article provides a step-by-step practical example on how to create a dimensional modeling with MySQL for analyzing sales data.

A blog about databases and data architecture

Designing a star schema data warehouse based on the Northwind database and implementing the ETL process using the SSIS tool. - JokoCyber/northwind-date-warehouse

IBM Documentation.

A semantic layer is a semantic data model that shows to the business user: a dimensional view (dimensional schema) from a relational schema. It will create/model a logical star schema by: ...

Understanding the difference between Fact and Dimension tables in the context of the Star Schema and Data Warehousing