Simplified Automobile Insurance Company would like to add a Claims dimension to its star schema (see Problem and Exercise 9-30). Attributes of Claim are ClaimID, ClaimDescription, and ClaimType. Attributes of the fact table are now PolicyPremium, Deductible, and MonthlyClaimTotal.

a. Extend the star schema from Problem and Exercise 9-30 to include these new data.

b. Calculate the estimated number of rows in the fact table, assuming that the company experiences an average of 2000 claims per month.

Transcribed Image Text:

InsuredParty Attributes: InsuredPartylD and Name. There is an average of two insured parties for each policy and covered item. Attributes: CoverageKey and Description. There is an average of 10 covered items per policy. Coverageltem Attributes: AgentID and AgentName. There is one agent for each policy and covered item. Agent Attributes: PolicylD and Type. The company has approximately 1 million policies at the present time. Policy Period Attributes: DateKey and Fiscal Period.