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

$$Franchise $$Merchandise$,$ Customers, Members and Servic For each table, you shhould define the table name, primary key, andcolumns. You do not need to write complete CREATE TABLE statements. Applydesign transformations, especially the flatten and merge transformations whereappropriate