$9-39.$ You are to construct a star schema for Simplified Automobile Insurance

Company $($for a more realistic example, Kimball, $1996$b $).$ The relevant dimensions,

dimension attributes, and dimension sizes are as follows:

Facts to be recorded for each combination of these dimensions are PolicyPremium,

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

$10$ bytes per field.