So we have a third fact table. A data warehouse is usually designed using a star schema. The star schema is basically one fact table connected to one or more dimension tables. A schema can have one or more facts, but these facts are not linked by any key relationship.