Essentials of MIS (13th Edition)
13th Edition
ISBN: 9780134802756
Author: Kenneth C. Laudon, Jane Laudon
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6, Problem 9HMP
Program Plan Intro
Industrial Supply Company Scenario:
- A data warehouse has to be created by the company where management can gain a single corporate-wide view of critical sales information for identifying best-selling products in specific geographic areas, sales trends as well as key customers.
- The information regarding sales and products are stored in both the divisional sales system that runs on a UNIX server and a corporate sales system that runs on an IBM mainframe.
- The main aim is to create a single standard format, which consolidates these data from both the systems.
Explanation of Solution
Easiness of creating a
- It is ideally easy to create a database with a single standard format. When a new database is constructed, data quality audits and data cleansing must be performed.
- Thee data quality suits and data cleansing can correct any redundancies and inaccuracies in the current systems.
- By using the data cleansing software, the company can combine and integrate the data from all the systems into a single standard format, which is uniform throughout the whole company...
Explanation of Solution
Problem Solving:
- Database specialists help to solve the problems by performing the data quality audits and database cleansing. It also helps to establish an information policy and develop the new database...
Explanation of Solution
Authority to finalize a single company-wide format:
- General business managers have the authority, as they are responsible for the data.
- They have the final power to decide, when managing data resources...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
What are the costs and benefits of different approaches to constructing massively distributed data environments?
This article will explain the differences between the two types of data flow charts. Data warehouses can't function without MetaData, so what makes it so essential?
Explore the concept of data warehousing architectures, including Kimball and Inmon methodologies. What are their core principles and differences, and when would you choose one over the other in a real-world scenario?
Chapter 6 Solutions
Essentials of MIS (13th Edition)
Ch. 6.3 - Identify the problem in this case study. To what...Ch. 6.3 - Prob. 2CQ1Ch. 6.3 - Prob. 4CQ1Ch. 6.5 - Prob. 1CQ2Ch. 6.5 - What people, organization, and technology issues...Ch. 6.5 - Prob. 3CQ2Ch. 6.5 - Prob. 4CQ2Ch. 6 - Prob. 1IQCh. 6 - Prob. 2IQCh. 6 - Prob. 3IQ
Ch. 6 - Prob. 4IQCh. 6 - Prob. 1RQCh. 6 - Prob. 2RQCh. 6 - Prob. 3RQCh. 6 - Prob. 4RQCh. 6 - Prob. 5DQCh. 6 - Prob. 6DQCh. 6 - Prob. 7DQCh. 6 - Prob. 8HMPCh. 6 - Prob. 9HMPCh. 6 - Prob. 11HMPCh. 6 - Prob. 13CSQCh. 6 - Prob. 14CSQCh. 6 - Prob. 15CSQCh. 6 - Prob. 16CSQCh. 6 - Prob. 17MLMCh. 6 - Prob. 18MLM
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- A data integration technique combining several data sources and different data sources might be as simple as changing the format or representation of the data or as sophisticated as data transformation. Is this a true or a false statement?arrow_forwardWhen designing data environments with a large degree of dispersion, it is necessary to strike a balance between a number of competing considerations.arrow_forwardWhat are the performance considerations when working with data binding in high-traffic or resource-intensive applications? How can developers optimize data binding to ensure efficiency?arrow_forward
- Data transformation can range from as simple as a change in data format or representation to as sophisticated as a data integration technique involving numerous data sources and many data sources. Is this statement correct or incorrect?arrow_forwardWhat compromises must be made when creating widely distributed data environments, according to computer science?arrow_forwardData transformation may be as basic as a change in data format or representation to as complicated as a data integration operation involving several data sources. Is this true or false?arrow_forward
- Discuss data warehousing architectures, such as Kimball and Inmon methodologies. What are the key differences between these approaches, and when might one be preferred over the other?arrow_forwardDiscuss the benefits and drawbacks of various data warehousing architectures, such as the Kimball and Inmon methodologies. When is each methodology most suitable?arrow_forwardWhat are the potential pitfalls of having excessively normalized data structures?arrow_forward
arrow_back_ios
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