Multi-Fact Star Schema

The schema with more than one fact table linked by normalized dimension tables is often called a "Data Mart Schema" or a "Multi-Fact Star Schema."

This schema can be helpful when you have multiple fact tables that share some but not all dimensions and where the dimensions are normalized.

• Multiple Fact Tables: For different aspects of the business.

• Normalized Dimension Tables: To avoid redundancy and improve data integrity.

It's a complex, real-world adaptation designed to meet specific business needs.