for the fitness retail store datawarehouse to summarize a sale fact table to its dimensions

$$write complete CREATE TABLE statements. Apply design transformations, especially the flatten and merge transformations whereappropriate