Principles of Information Systems (MindTap Course List)
13th Edition
ISBN: 9781305971776
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 5.4, Problem 2CTQ
Explanation of Solution
Additional
- For the given project, user can use the ecosystem such as Hadoop or Apache Spark or Apache storm, apache kafka and elastic search tool.
- Apache Hadoop:
- It is a collection of open-source software utilities that help using a network of various computers to solve difficulties involving large amount of data and computation.
- Apache spark:
- It is an open-source big data framework...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to maintain customer, invoice, and inventory data using its manual systems. In addition, KimTay Pet Supplies wants to build an Internet presence. With the data stored in a database, management will be able to ensure that the data is up-to-date and more accurate than in the current manual systems. In addition, managers will be able to obtain answers to their questions concerning the data in the database easily and quickly, with the option of producing a variety of useful reports.
The CUSTOMER table maintains information about each customer, such as their ID, first and last name, address, balance, and credit limit.
CUSTOMER table
In the INVOICES table contains information about each invoice, such as the invoice number, date, and the customer being invoiced.
INVOICES table
The INVOICE_LINE table…
The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to maintain customer, invoice, and inventory data using its manual systems. In addition, KimTay Pet Supplies wants to build an Internet presence. With the data stored in a database, management will be able to ensure that the data is up-to-date and more accurate than in the current manual systems. In addition, managers will be able to obtain answers to their questions concerning the data in the database easily and quickly, with the option of producing a variety of useful reports.
List the item ID, description, and on-hand value of each item whose number of units on hand is more than the average number of units on hand for all items.
Use a subquery.
People Relationship Management (CRM) is a rapidly expanding field, and Oracle's database management technology has been included into it. Do comparisons between Sibel and MySAP CRM make sense?
Chapter 5 Solutions
Principles of Information Systems (MindTap Course List)
Ch. 5.1 - Prob. 1RQCh. 5.1 - Which attribute would you designate as the primary...Ch. 5.1 - Prob. 1CTQCh. 5.1 - Prob. 2CTQCh. 5.2 - Prob. 1RQCh. 5.2 - Prob. 2RQCh. 5.2 - Prob. 1CTQCh. 5.2 - Prob. 2CTQCh. 5.3 - Prob. 1RQCh. 5.3 - Prob. 2RQ
Ch. 5.3 - What additional questions need to be answered...Ch. 5.3 - Prob. 2CTQCh. 5.4 - Prob. 1RQCh. 5.4 - Telefonica Brasil is one of the largest...Ch. 5.4 - Prob. 1CTQCh. 5.4 - Prob. 2CTQCh. 5.5 - Prob. 1RQCh. 5.5 - Prob. 2RQCh. 5.5 - Why is it unlikely that a traditional SQL database...Ch. 5.5 - Prob. 2CTQCh. 5 - Prob. 1SATCh. 5 - Prob. 2SATCh. 5 - Prob. 3SATCh. 5 - The ______________ model is a simple but highly...Ch. 5 - The ability to combine two or more tables through...Ch. 5 - Prob. 6SATCh. 5 - Prob. 7SATCh. 5 - Prob. 8SATCh. 5 - Prob. 9SATCh. 5 - Prob. 10SATCh. 5 - Prob. 11SATCh. 5 - Prob. 12SATCh. 5 - Prob. 13SATCh. 5 - Prob. 14SATCh. 5 - Prob. 15SATCh. 5 - Prob. 16SATCh. 5 - Prob. 1RQCh. 5 - In the hierarchy of data, what is the difference...Ch. 5 - Prob. 3RQCh. 5 - What is meant by data archiving? Why is this an...Ch. 5 - What is an entity-relationship diagram, and what...Ch. 5 - Identify four basic data manipulations performed...Ch. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Prob. 10RQCh. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - Prob. 15RQCh. 5 - Prob. 16RQCh. 5 - Prob. 17RQCh. 5 - Prob. 1DQCh. 5 - Outline some specific steps an organization might...Ch. 5 - SQL databases conform to ACID properties. Briefly...Ch. 5 - Prob. 4DQCh. 5 - Prob. 6DQCh. 5 - Prob. 8DQCh. 5 - Prob. 1PSECh. 5 - Describe the role of a database administrator....Ch. 5 - Prob. 2CECh. 5 - Prob. 1CTQ1Ch. 5 - Prob. 2CTQ1Ch. 5 - Prob. 3CTQ1Ch. 5 - Prob. 1CTQ2Ch. 5 - Prob. 2CTQ2Ch. 5 - Prob. 3CTQ2
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
- Imagine that a major database vendor makes its database system (for example, Oracle or SQL Server DB2) available for use as a cloud-based subscription service. In terms of cloudservice models, where does this go into the mix. Why?arrow_forwardOracle's database management technology has been included into People Relationship Management (CRM), which is becoming more popular. Does it make sense to contrast it with Sibel and MySAP CRM?arrow_forwardFarmers Marketmen is a regional business that provides wholesale, organic, non-GMO products to private contract vendors who sell products at farmers markets. Farmers Marketmen has a large inventory consisting of truly natural baked goods, cosmetics, toiletries, books, and sustainable educational material. Due to the recent growth of the business, Farmers Marketmen has outgrown its current DBMS and is looking to replace it with a system that will allow for future growth over the next five years. They have budgeted $10,000, aside from consultant costs, to fully implement this new system. You have been hired as a private consultant to assess and evaluate the current DBMSs available on the market (including open source and proprietary solutions) and recommend three BDMSs, ranking them in an order that you believe best suits Farmers Marketmen’s needs and budget. For the initial discussion question, research current DBMSs systems and provide the three that you believe best fit the…arrow_forward
- So that not all business operations are routed via a single system, your company has decided to disperse its product database among many servers. Which particular concerns will need to be addressed?arrow_forwardOracle's database management technology has been integrated into the increasingly popular People Relationship Management (CRM). Is it OK to compare it to Sibel and MySAP CRM?arrow_forwardAssume a major database vendor makes its database system (for example, Oracle or SQL Server DB2) available as a cloud service. What role does this play in the cloudservice models? Why?arrow_forward
- What kind of database successes or failures have you experienced? Consider the databases you might have utilized to do online shoe shopping. How successful has searching for a specific item, such as "blue suede shoes," been? On the website, how simple is it to find items in a certain category? What challenges did you have to overcome?arrow_forwardIn an IoT system, what's the starting point for thinking about how to use edge and cloud computing? Where should the database system be located?arrow_forwardA small manufacturing firm grows by opening additional locations around the nation. Right now, each individual runs their own Access or Excel database. The business is thinking about implementing a consolidated database management system for its accounting, personnel, production, and inventory systems. Part of the SDLC cycle includes the need for a feasibility study.arrow_forward
- Tshepo has put a lot of thought into the data that he wants to store in the carbon accounting database. He has also spoken to the CEOs of a number of companies in the group to get their inputs. Between them, they have come up with a set of business rules to be used as the basis for the data model design. Project ACME Green - Business Rules 1. A single database will be created that will track the carbon footprints of all the companies within the ACME Technologies™ group. 2. All tables in the database must have surrogate primary keys. 3. Each company has a name and consists of one or more departments. 4. Each company has one employee that is the CEO of the company. That employee may only be the CEO of one company, and not all employees are CEOs. 5. Each department must have exactly one employee who is the Green Champion - the person responsible for any initiatives related to the carbon footprint of the department. That employee may only be the Green Champion for a single department, and…arrow_forwardSome companies move their relational database (for instance a reporting database residing in MS SQL server) to Hadoop ecosystem. a. Do some web search and find out why do companies do that? b. What do they gain from that? c. Is it wise to do so? d. What is the upside and what is the downside?arrow_forwardCloud-based databases are required for clients with low resources. Customers are given software, hardware, and network resources to help them manage and operate databases. Nonetheless, the data and database queries are in the control of the distrusted service provider. Using examples, discuss the security criteria you should consider while outsourcing data to the cloud.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning