Question: MVCH Table 9-1 provides some details regarding the two data marts MVCH is considering. a. Design a star schema for each data mart. b. Calculate

MVCH Table 9-1 provides some details regarding the two data marts MVCH is considering.

a. Design a star schema for each data mart.

b. Calculate the expected number of rows in each fact table and its estimated size (bytes).

c. For the detailed data mart, why is it necessary to assume that a given treatment may be performed only once by a given physician for a given patient on a given day?
Suggest a way to overcome this.

d. Would you recommend that MVCH implement both data marts? Why or why not? If yes, then what should MVCH do to ensure consistency across the two data marts?

e. Using SQL, create two star queries for each of the data marts.

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 Database Management Systems Questions!

INTERNATIONAL REVIEW OF L AW C OMPUTERS & TECHNOLOGY , VOLUME 11, N UMBER 2, P AGES 251-261, 1997 The Data Mart: A New Approach to Data Warehousing PAM ELA PIPE Introduction Vendors have recently...

Schema Data Mart and Data Warehouses. Reading is below........ 1. Does this schema represent a data mart or data warehouse? Why? 2. There are two predominant schema designs mentioned in the reading...

4.3 Assignment 2: Data Mart (DM) data staging, ETL, implementations and considerations (50%) Formative feedback for task 3 is available in class in week 11 Task 1: Extract, Transform and Load (ETL)...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

(1) Income Statement Referencing this week?s readings and lecture, address the following: ? What are the two causes of an increasing or decreasing sales number? ? Discuss all the reasons that might...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Business Research MethodologyQuestion Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

Can you please answer this questions below QUESTION 1 The key to any successful report is clarity, ____, completeness, and correctness. a. actuality b. longevity c. brevity 2 points QUESTION 2 A is a...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

The management of Hershey Foods has asked union workers in two of their highest cost Pennsylvania plants to accept higher health insurance premiums and take a wage cut. The workers portion of the...

A space shuttle S and a satellite A are in the circular orbits shown. In order for the shuttle to recover the satellite, the shuttle is first placed in an elliptic path BC by increasing its speed by...

? _ _ _ f u n d i n g i s m e a s u r e d u s i n g s u p e r v i s o r y a s s u m p t i o n s o n t h e c h a r a c t e r i s t i c o f t h e l i q u i d i t y r i s k p r o f i l e s o f a D I ' s...

Phoenix Plastic Inc. has accumulated the following data over a six-month period: Separate the machine-related costs into their fixed and variable components, using the high-lowmethod. Machine Hours...