Question: Why is the entity - relationship modeling technique not suitable for the data warehouse? How is dimensional modeling different?

Why is the entity-relationship modeling technique not suitable for the data warehouse?
How is dimensional modeling different?

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!

Q:

DQ 3 Create your initial post on the DQ3 Discussion Board in response to the following questions: - Why is Entity Relationship Modeling technique not suitable for data warehouse? How is Dimensional...

Q:

do all REVIEW QUESTIONS 1. Discuss the major design issues that need to be addressed before proceeding with the data design. 2. Why is the entity-relationship modeling technique not suitable for the...

Q:

Dr. Winkle and his colleagues have approved the system request and decided to proceed with the project. On the basis of the business case, Dr. Winkle made arrangements for a bank loan to fund the...

Q:

Dr. Winkle and his colleagues have approved the system request and decided to proceed with the project. On the basis of the business case, Dr. Winkle made arrangements for a bank loan to fund the...

Q:

*IMPORTANT PLEASE READ picture 1: (directions/assignment/task at hand) picture 2: entity relationship model picture 3: contents of data table Assignment \#2: Dimensional Modeling Instruction: -...

Q:

SUBJECT:IDSC MAJOR: MIS From the reading: "Why Projects Fail?" Match three reasons project fail to the appropriate phase of the SDLC , justify with specific deliverable and/or technique from the SDLC...

Q:

The Traditional 3-Way Matching Process The purchasing department of Company X completes a paper purchase order and sends it to Supplier A via fax, with a copy going to the accounts payable department...

Q:

Please answer all the MCQs. 11. Which of the following is a traditional process modeling technique? * A) Data Dictionary B) Data Flow Diagram C) Decision Tree D) Entity Relationship Diagram 12. Which...

Q:

Abstract This article describes CRISP-DM (Cross-Industry Sandand Process for Data Mining), a non-proprietary, documented, and freely available data mining model. Dezeloped by indias- try leaders...

Q:

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

Q:

On August 15, 2,500 shares of Collins Company are acquired at a price of $51 per share plus a $125 brokerage fee. On September 10, a $1.10-per-share dividend was received on the Collins Company...

Q:

What writing have you done at work or in your community that you think could be labelled technical writing? Why do you think it can be labelled technical writing? Please describe the writing...

Q:

Whether or not it is recurring, as a boolean Create five different objects to represent different expenses. Using a prompt box, display the income items and let the user add anotherentry. Using a...

Q:

In managing age discrimination, a strategy that can be successfully used by employers is phased retirement, where: Select one: a . Older employees phase into becoming consultants for the company. b ....

Q:

Discuss how to align a companys strategic direction with its human resource planning. page 199

Q:

List the major federal laws that require equal employment opportunity and the protections provided by each of these laws. page 114

Q:

Describe the different HRM issues and practices associated with various directional strategies. page 97