Thanks for reviewing my 2 step question based on Database Design:Data Warehouses (Please don't copy answers from other chegg posts), You have been hired to construct a star schema for Geico.

The relevant dimensions, attributes and sizes are as follows:

Facts to be recorded for each combination of these dimensions are PolicyCost, Deductible, and TransactionCount.

Design the star schema in LucidChart or Cacoo, When complete export/screenshoot the diagram as a jpg or png

:

Dimension InsuredParty Attributes InsuredPartyID, Name Size Business Rules On average, there are 2 parties for each policy/covered vehicle. The average number of covered items per policy is 10. Coverageltem Agent Policy Period CoverageKey, Description AgentID, AgentName PolicylD, Type DateKey, FiscalPeriod There is one agent for each policy/vehicle. Currently, Geico has approximately 100,000 policies. Dimension InsuredParty Attributes InsuredPartyID, Name Size Business Rules On average, there are 2 parties for each policy/covered vehicle. The average number of covered items per policy is 10. Coverageltem Agent Policy Period CoverageKey, Description AgentID, AgentName PolicylD, Type DateKey, FiscalPeriod There is one agent for each policy/vehicle. Currently, Geico has approximately 100,000 policies