Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

44. Simplified A add a Claims di plified Automobile Insurance Company would like to Claims dimension to its star schema (see Problem Exercise 9-39). Attributes

image text in transcribed
image text in transcribed
44. Simplified A add a Claims di plified Automobile Insurance Company would like to Claims dimension to its star schema (see Problem Exercise 9-39). Attributes of Claim are ClaimID, ClaimDescription, and Claim Type. Attributes of the fact e are now Policy Premium, Deductible, and Monthly- Claim Total. Extend the star schema from Problem and Exercise 9-39 to include these new data. b. Calculate the estimated number of rows in the fact table, assuming that the company experiences an aver- age of 2,000 claims per month Star schema: InsuredParty InsuredPartyID Name Policy @ Policy Facts InsuredPartyID PolicylD Type Coverageltem CoverageKey CoverageKey AgentID PolicyID Description DateKey Policy Premium Deductible Period DateKey FiscalPeriod Agent AgentID NumberOfTransactions AgentName

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

IBM Db2 11 1 Certification Guide Explore Techniques To Master Database Programming And Administration Tasks In IBM Db2

Authors: Mohankumar Saraswatipura ,Robert Collins

1st Edition

1788626915, 978-1788626910

More Books

Students also viewed these Databases questions

Question

The operating cycle is the recurring transition of a firm

Answered: 1 week ago

Question

b. Explain how you initially felt about the communication.

Answered: 1 week ago