Part $3.$ Data Warehousing $(15$ pts$.)$

The following is the meta$-$data of a call center database. It records information about all calls made by the customers to call center agents regarding certain products. The agents' jobs are to take the calls, help customer figuring out what to do$,$ and to take actions by directing customers to a certain web page where the agent and the customer could conduct online chat and run diagnostic sessions..

a$.$ Identify the measures and constraints in the following business question: Report how often agents in different positions access web pages of each page type to perform customer support tasks for customers from each state in each month. Use attributes from the Metadata below to serve as the constraints. For example, the constraint "customer state" should be expressed as the attribute "Customer.State" $(5$ pts$)$

Measures:

Constraints: