SALES FACTS DATE TRANSACTION DateKey AgentID CustomerID PolicyID TransactionID Commission Value TransactionID Transaction Description DateKey DayOfWeek Day Month Year Quarter Weekday Flag AGENT...


In the image provided which keys would be Primary, Foreign, or Surrogate in this star schema?


SALES FACTS<br>DATE<br>TRANSACTION<br>DateKey<br>AgentID<br>CustomerID<br>PolicyID<br>TransactionID<br>Commission Value<br>TransactionID<br>Transaction Description<br>DateKey<br>DayOfWeek<br>Day<br>Month<br>Year<br>Quarter<br>Weekday Flag<br>AGENT<br>CUSTOMER<br>AgentID<br>AgentName<br>CustomerID<br>StartDate<br>EndDate<br>DateOfHire<br>POLICY<br>TerritorylD<br>CustomerName<br>Street<br>City<br>State<br>Zipcode<br>PolicylID<br>Туре<br>Face Value<br>InitComm<br>InForce<br>EffectiveDate<br>TERRITORY<br>TerritoryID<br>LastRedistrict<br>ZIPCODE<br>Territory ID<br>ZipCode<br>

Extracted text: SALES FACTS DATE TRANSACTION DateKey AgentID CustomerID PolicyID TransactionID Commission Value TransactionID Transaction Description DateKey DayOfWeek Day Month Year Quarter Weekday Flag AGENT CUSTOMER AgentID AgentName CustomerID StartDate EndDate DateOfHire POLICY TerritorylD CustomerName Street City State Zipcode PolicylID Туре Face Value InitComm InForce EffectiveDate TERRITORY TerritoryID LastRedistrict ZIPCODE Territory ID ZipCode

Jun 05, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?