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).

a. Using the assumptions stated above, estimate the number of rows in the fact table.

b. Estimate the total size of the fact table (in bytes), assuming an average of 5 bytes per field.

Please don't copy others' answer.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!