Design efficient database schemas that optimize for analytical workloads and business reporting.
Design a star schema for a retail business, defining the fact table for sales and dimension tables for time, product, and store.