Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions

Question

=+Where does the focus of labor relations lie? Is it collective

Answered: 1 week ago

Question

=+With whom does the firm have to negotiate?

Answered: 1 week ago