Answer for this problem "construct a star schema for Simplified Automobile Insurance Company"
The relevant dimensions, dimension attributes, and
dimension sizes are as follows:
Insured Party. Attributes: Insured_Party_ID, Name. There is an average of two insured parties for each policy and covered item.
Coverage Item. Attributes: Coverage_Key, Description. There is an average of 10 covered items per policy. Agent. Attributes: Agent_ID, Agent_Name. There is one agent for each policy and covered item.
Policy. Attributes: Policy_ID, Type. The company has approximately one million policies at the present time.
Period. Attributes: Date_Key, Fiscal_Period.
Facts to be recorded for each combination of these dimensions are:
Policy_Premium, Deductible, and Number_of_Transactions.
a. Design a star schema for this problem.