Part $3.$ Data Warehousing $(15$ pts$.)$The tolowing ls the meta$-$data of a call center database. It records information about all callsmade by the customers to call center agents regarding certaln products. The agents jobs are totake the call, help customer figuring out what to do$,$ and to take actions by directing customersto a certain web page where the agent and the customer could conduct online chat and rundiagnostic sessions.a$.$ ldentity the measures and constraints in the following business question: Reporthow often agents in different positlons access web pages of each page type toperform customer support taslks for customers from each state in each month. Useattributes from the Metadata below to serve as the constraints. For example, theconstraint "customer state should be expressed as the attribute "Customer.State$($S pts$)$Measures:Constraints:b$.$ Given the metadata below, design a star schema that helps you answer quetion$($a$).$ You need to:$$ dearly name each dimension and fact tableMake sure that all keys are properly created$$ Include some attributes in each table. All attributes in your star schemamust come from the metadata blow. You can choose the attributes thatyou think to be necessary for meanlngful querles to be generated. $(10$ pts$)$

$\backslash$table$[[$Table Name,Attributes,Description$],[$Customer$,$ClD$,],[$Name$,],[$Gender$,],[$city$,],[$State$,],[$Country$,],[$Income Level,Value: $1-10],[$Education level,Value: $1-10],[$Internet usage level,Value: $1-10],[$Product$,$PID,$],[$evame$,],[$PCID$,],[-,$ADD,$],[$AName$,],[$Agender$,],[$Abranch$,],[$Agent$,$Bostion,$],[$Experience$.$aleved,$],[$Hitios$\_$Date.,$],[$Managerald$.,$T$],[$Task$,$IID$],[$AID$,],[$cID$,],[$PID$,],[$trucoalabotor$,],[$Beplo$.$Time,$],[$End$.$Time.,$],[\_,]]$

$\backslash$table$[[$Task Category,$\backslash$table$[[$TC ID$],[$TC$.$ Name$]],],[$Action$,$ACID,$],[$Page$\_$URL,$],[$Description$,],[$Webrase$,$PaseUR!,URL of a web page$],[$Pasetype$,$page, product description, corporate information and order page etc.$],[$Agentaslick$,$IID,$5],[$Pagelush$],[$Eotox Time$]]$