Fact Constellation schema is a logical database structure of a data warehouse. It is designed with the help of a denormalized fact.