9-39. You are to construct a star schema for Simplified Auto- mobile Insurance Company (for a more realistic example, Kimball, 1996b). The relevant dimensions, dimension attributes, and dimension sizes are as follows: InsuredParty Coverageltem Agent Attributes: InsuredPartyid 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 Attributes: AgentiD and AgentName. There is one agent for each policy and covered item. Attributes: PolicyID and Type. The company has approximately 1 million policies at the present time. Attributes: Datekey and FiscalPeriod. Policy Period Facts to be recorded for each combination of these dime sions are Policy Premium. Deductible, and Number ransactions. a. Design a sta b. Estimate the nun Design a star schema for this problem. See Figure 9.10 for the format you should follow. mate the number of rows in the fact table, using the assumptions stated previously. Estimate the total size of the fact table in bytes ing an average of 10 bytes per field. 44. Simplified A add a Claims di plified Automobile Insurance Company would like to Claims dimension to its star schema (see Problem Exercise 9-39). Attributes of Claim are ClaimID, ClaimDescription, and Claim Type. Attributes of the fact e are now Policy Premium, Deductible, and Monthly- Claim Total. Extend the star schema from Problem and Exercise 9-39 to include these new data. b. Calculate the estimated number of rows in the fact table, assuming that the company experiences an aver- age of 2,000 claims per month