Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 9.42PAE
Program Plan Intro
Summarization of the arguments made by Kimball, Inmon and Armstrong on merits of independent and dependent data marts and normalized versus denormalized data marts.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Summarize the arguments made by Kimball, Inmon and Armstrong on merits of independent and dependent data marts and normalized versus denormalized data marts.
ER modeling is one approach in creating a data model. There are several approaches in creating a data model (bottom up, top down, inside out, and mix).
1. explain each of these approaches!2. Then explain when we use top down, bottom up, inside out and mix? what is the function of each of the approaches?
In what scenarios might a denormalized data model be preferred over a normalized one?
Chapter 9 Solutions
Modern Database Management
Ch. 9 - Prob. 9.1RQCh. 9 - Prob. 9.2RQCh. 9 - Prob. 9.3RQCh. 9 - List the five major trends that necessitate data...Ch. 9 - Prob. 9.5RQCh. 9 - Prob. 9.6RQCh. 9 - Prob. 9.7RQCh. 9 - Prob. 9.8RQCh. 9 - Prob. 9.9RQCh. 9 - Prob. 9.10RQ
Ch. 9 - List four objectives of derived data.Ch. 9 - Prob. 9.12RQCh. 9 - Prob. 9.13RQCh. 9 - Explain the pros and cons of logical data marts.Ch. 9 - Prob. 9.15RQCh. 9 - What is a helper table, and why is it often used...Ch. 9 - Describe the characteristics of a surrogate key as...Ch. 9 - Prob. 9.18RQCh. 9 - What is the purpose of conformed dimensions for...Ch. 9 - Prob. 9.20RQCh. 9 - Prob. 9.21RQCh. 9 - Prob. 9.22RQCh. 9 - Prob. 9.23RQCh. 9 - Prob. 9.24RQCh. 9 - Prob. 9.25RQCh. 9 - Describe the current key trends in data...Ch. 9 - Discuss the benefits of offering data warehousing...Ch. 9 - Prob. 9.28RQCh. 9 - List six typical characteristics of reconciled...Ch. 9 - Prob. 9.30RQCh. 9 - Prob. 9.31RQCh. 9 - Prob. 9.32RQCh. 9 - Prob. 9.33RQCh. 9 - Describe some field-level and record-level data...Ch. 9 - Prob. 9.35PAECh. 9 - Prob. 9.36PAECh. 9 - Prob. 9.37PAECh. 9 - Prob. 9.38PAECh. 9 - You are to construct a star schema for Simplified...Ch. 9 - Simplified Automobile Insurance Company would like...Ch. 9 - Prob. 9.41PAECh. 9 - Prob. 9.42PAECh. 9 - Prob. 9.43PAECh. 9 - Prob. 9.45PAECh. 9 - Prob. 9.46PAECh. 9 - Prob. 9.47PAECh. 9 - Prob. 9.48PAECh. 9 - Prob. 9.49PAECh. 9 - Prob. 9.50PAECh. 9 - Prob. 9.51PAECh. 9 - Prob. 9.52PAECh. 9 - Prob. 9.53PAECh. 9 - Prob. 9.54PAE
Knowledge Booster
Similar questions
- explain the concept of the balanced and unbalanced data set. Explain the effects of this situation on classification and the Synthetic Minority Oversampling Technique (SMOTE) methodarrow_forwardThere are two programming models in Big Data Ecosystem i.e. Map Reduce and Spark, what are the similarities and differences between them? Why Spark outperform Map Reduce in the execution time?arrow_forwardDiscuss the concept of denormalization in data modeling. When and why might denormalization be necessary, and what are the trade-offs?arrow_forward
- Explain how a data model helps in the context of the tried and true method of strength prediction.arrow_forwardCourse: Data Mining Language: R (although it might not be needed for this question) Suppose you are given the data to analyze that includes a single attribute age. Following are the age values in unsorted order, 22 46 13 70 35 20 19 45 25 40 15 22 33 35 33 30 35 35 21 36 52 25 20 25 16 16 25 17 Use smoothing by bin means to smooth these data, using a bin depth of 4. Illustrate your steps. Use smoothing by bin boundaries to smooth these data, using a bin depth of 4. Illustrate your steps. How might you determine the outliers in the data?arrow_forwardConsider the data about students in your university's database as a huge table containing a row for each student and a column for each data element. Sort the data into main categories such as contact information, medical information, financial information, and academic information. Which employment categories should be accessible to which groups of people? Who should have access to a single row within a group, who should have access to multiple rows but not to all rows, and who should have access to all rows in the table? Should anyone have the ability to view data but not alter it?arrow_forward
- What is the difference between forwards and reverse engineering in terms of data models?arrow_forwardASAP solve Given below are some events. You have to mark which one is based on data mining and which is not. If you say that the task is based on data mining then to which category (descriptive, predictive or prescriptive) does it belong to? If I want to arrange/sort the data of a company by employees id. Sasha is a very good doctor. She has some X-rays which are labelled for making decisions. She wants to find that whether a patient is ill by looking at the X-rays. Nadeem has graduated as an image analyst from Haka University. He has recently got some latest pictures from a lab. He wishes to detect the unique objects present in the picture automatically. He is not provided with any kind of previous knowledge In this advanced era, marketing is all about advertisements. Hence, Google just like other tech organizations wants to obtain information about such users who will click specific advertisements on a website. Recently, Ufone company has profited the maximum as compared to…arrow_forwardNOSQL is a new generation of databases that address specific challenges in the Big Data era. Suppose we must keep track of multiple academic staff members and their qualifications. A relational model representation would look as follows: STAFF_ID DOB DEGREE1 DEGREE2 DEGREE3 DEGREE4 123 1993/05/19 BSc 456 1985/09/27 BCom MCom Draw a key-value representation of the above data to show how it would translate to a NOSQL context.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education