Question
Consider the following dimensions, dimension attributes, and dimension sizes for Farm Coop-Insurance. Member(member_ID, Name, Address). On average, there are two members for each policy and
Consider the following dimensions, dimension attributes, and dimension sizes for Farm Coop-Insurance.
Member(member_ID, Name, Address). On average, there are two members for each policy and item covered by the policy.
InsuredItem(Item_ID, Description, Coverage_Type). There is an average of ten covered items per policy.
CoopOffice(Office_ID, Address, Manager_name). Each policy is registered and managed by only one office of the cooperative.
Policy(Policy_ID, Type). The company has approximately one million policies at the present time. Approximately five percent of these policies experience some change each month.
Period(Date_Key, Fiscal_Period). The length of the fiscal period is one month. The decision system reports are supposed to be based on five years of data.
Claim(Claim_ID, Claim_Description, Claim_Type).
The facts to be recorded for each combination of these dimensions are: Policy_Premium, Deductible, and Monthly_Claim_Total.
Design a star schema for this problem.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started