Provide 4-step dimensional model in the SQL comment section (4 points) and create data warehouse solution in SQL for the dimensional model that you propose
CEO of Entertainment Inc. wants to keep track of performance of engagement that the company has engaged. For each customer and agent, he wants…