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
Get step-by-step solutions from verified subject matter experts
