CEO of Entertainment Inc. want to keep track with the life cycle of engagement contract. Particularly, he want to know the total numbers of entertainers participated, the contract price, commission rate when contract is created and authorized, negotiated, executed and monitored, and closeout. He is also interested in how many customers, and agents engaged for each contract life cycle phrase. Build data warehouse tables in SQL to provide this information,

How should I go about providing this fact table? There is only Engagement, Customer, Agent, and an entertainer table to use when creating the DIm Tables.