Question: Q3. In DBMS adding derived attribute in a database is not considered a good idea, whereas in Data Warehouse such an attempt can be justified.

Q3. In DBMS adding derived attribute in a database is not considered a good idea, whereas in Data Warehouse such an attempt can be justified. How? Give suitable examples.

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!

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

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

As in most areas of life and work, advances in information technology have focused attention on the importance of good information systems to support logistics and distribution activities. The...

Read the text in photos and answer the following question As in most areas of life and work, advances in information technology have focused attention on the importance of good information systems to...

Montonya Company has the following selected data for the current year: Sales (10,000 units) $90,000 Direct materials 30,000 Direct labor costs 10,000 Variable manufacturing overhead 3,500 Fixed...

Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...

Read the attached article and answer the following questions in report format: Discuss the factors that drove Harrah's customer relationship strategy. Discuss whether Harrah's business and IT...

Let f be a functional on an open subset S of n. Then f is continuously differentiable (C1) if and only if each of the partial derivatives Dif[x] exists and is continuous on S. We now present some...

If the DLOM for Giant Corp. is given as 6% and the total discount is given as 9.76%, then the value of the control premium is closest to: Select one: a. 3.91% b. 4.00% c. 4.17% Clear my choice

An S corporation election terminates automatically if: Select one: 3 . The corporation has 1 0 1 shareholders, which includes a married couple b . The corporation has 9 9 shareholders, which includes...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Describe the criteria for selecting the style for a social business message.

Use appropriate alternatives to ensure unbiased language in messages.

Describe the appropriate use of supplementary parts of a letter.