Which of the following best describes a fact constellation schema in a data warehouse?

A fact constellation schema, also known as a galaxy schema, is a complex schema used in a data warehouse where: • Multiple fact tables exist (e.g., Sales Fact, Shipment Fact). • These fact tables share dimension tables (like Time, Product, Customer). • It supports complex business processes that cannot be represented by a single fact table. This schema is more advanced than star and snowflake schemas and is suitable for enterprise-level data warehousing. • Option A describes a star schema. • Option B vaguely refers to hierarchy in dimensions (e.g., snowflake). • Option D refers to normalization, relevant for snowflake schema but not fact constellation. • Option E is incorrect because fact constellation is used in OLAP systems.