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. Using the assumptions stated above, estimate the number of rows in the fact table. Estimate the total size of the fact table (in bytes), assuming an average of 5 bytes per field

In this question we have to understand about given Farm Coop-Insurance attributes and schema to…

Answered: Consider the following dimensions,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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 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.
Using the assumptions stated above, estimate the number of rows in the fact table.
Estimate the total size of the fact table (in bytes), assuming an average of 5 bytes per field

Expert Solution

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions