You are to construct a star schema for Simplified Automobile Insurance Company (see Kimball, 1996b, for a more realistic example). The relevant dimensions, dimension attributes, and dimension sizes are as follows:

Facts to be recorded for each combination of these dimensions are PohcyPremium, Deductible, and NumberOfTransactions.
a. Design a star schema for this problem. See Figure 9-10 for the format you should follow.
b. Estimate the number of rows in the fact table, using the assumptions stated previously.
c. Estimate the total size of the fact table (in bytes), assuming an average of 5 bytes per field.

Transcribed Image Text:

Insured Party Attributes: InsuredPartylD and Name. There is an average oftwo 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 and covered item Coverageltem Agent agent for each policy Attributes: PolicylD and Type. The company has Policy approximately 1 million policies at the present time. Attributes: DateKey and FiscalPeriod Period