New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
computer science
database processing fundamentals
Database Processing Fundamentals, Design, and Implementation 14th edition David M. Kroenke, David J. Auer - Solutions
Write an SQL statement to show a unique SKU and SKU_Description for all products having a description that includes the word 'Climb'.
Write an SQL statement to show a unique SKU and SKU_Description for all products having a ‘d’ in the third position from the left in SKU_Description.
Explain the difference between the SQL built-in functions COUNT and SUM.
Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Name the sum TotalItemsOnHand and display the results in descending order of TotalItemsOnHand.
Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Omit all SKU items that have 3 or more items on hand from the sum, and name the sum TotalItemsOnHandLT3 and display the results in descending order of TotalItemsOnHandLT3.
Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand grouped by WarehouseID. Omit all SKU items that have 3 or more items on hand from the sum, and name the sum TotalItemsOnHandLT3. Show Warehouse ID only for warehouses having fewer than 2 SKUs in their
In your answer to Review Question 2.38, was the WHERE or HAVING applied first? Why?
Write an SQL statement to display the SKU, SKU_Description, WarehouseID, WarehouseCity, and WarehouseState for all items stored in the Atlanta, Bangor, or Chicago warehouse. Do not use the IN keyword.
Write an SQL statement to display the SKU, SKU_Description, WarehouseID, WarehouseCity, and WarehouseState of all items not stored in the Atlanta, Bangor, or Chicago warehouse. Do not use the NOT IN keyword.
Explain why you cannot use a subquery in your answer to question 2.52.
Explain how subqueries and joins differ.
There is an intentional flaw in the design of the INVENTORY table used in these exercises. This flaw was purposely included in the INVENTORY tables so that you can answer some of the following questions using only that table. Compare the SKU and INVENTORY tables, and determine what design flaw is
Explain how enterprise-class DBMS products use SQL.
Explain how Microsoft Access uses SQL.
What is the SQL SELECT/FROM/WHERE framework?
What does DDL stand for? What are DDL statements?
What does DML stand for? What are DML statements?
Why is SQL described as a data sublanguage?
What features have been added to SQL in versions subsequent to SQL-92?
What is SQL-92? How does it relate to the SQL statements in this chapter?
Summarize the background of SQL.
Explain, in general terms, the relationships of the RETAIL_ORDER, ORDER_ITEM, and SKU_DATA tables. What is the relationship of these tables to the CATALOG_SKU_2014 and CATALOG_SKU_2015 tables?
What does SQL stand for, and what is SQL?
Summarize how data were altered and filtered in creating the Cape Codd data extraction.
What does SKU stand for? What is an SKU?
What is an ad-hoc query?
What is an online transaction processing (OLTP) system? What is a business intelligence (BI) system? What is a data warehouse?
What job functions does a database administrator perform?
What has been the response of companies that sell proprietary DBMS products to the open source DBMS products? Include two examples in your answer.
Explain two ways that databases can be redesigned.
Describe the general process for designing a database for a new information system.
Explain two ways that a database can be designed from existing data.
What is a data warehouse? What is a data mart?
What does the term database migration mean?
What job functions does a database administrator perform? Explain.
Who was E.F. Codd?
What happened to the products in your answer to Review Question 1.56?
What is XML? What comment did Bill Gates make regarding XML?
What is the NoSQL movement? Name two applications that rely on NoSQL databases.
How do database applications read and write database data?
Name and explain the four categories of database applications that would use an enterprise-class database system.
Name the components of an enterprise-class database system.
Why does Microsoft Access hide important database technology?
Why would someone choose to replace the native Microsoft Access DBMS engine with SQL Server?
What is the name of the DBMS engine within Microsoft Access? Why do we rarely hear about that engine?
What is the function of the application generator in Microsoft Access?
Explain the components in Figure 1-17. FIGURE 1-17 Microsoft Access Compononte of a Microsoft Access Databasa System Form-Processing Application Data Entry Forms Report-Gonorator Application Reports DBMS Database Users Queries Query-Processing Application The DBMS can be either the native Microsoft
Is Microsoft Access a DBMS? Why or why not?
List the components of a database other than user tables and metadata.
What advantage is there in storing metadata in tables?
What is metadata? How does this term pertain to a database?
Why is a database considered to be self-describing?
Name three vendors of DBMS products.
What are the functions of the DBMS?
What does DBMS stand for?
What are the functions of application programs?
What is Structured Query Language (SQL), and why is it important?
Explain the components in Figure 1-9. Database Database DBMS Application Users • Create Process Administer
Explain why a small database is not necessarily simpler than a large one.
How do digital dashboard and data mining applications differ from transaction processing applications?
How do the e-commerce companies use the databases discussed in Review Question 1.15?
What is the purpose of the largest databases used by e-commerce companies such as Amazon.com?
What is an open source DBMS product? Which of the five DBMS products that you named in answering Review Question 1.39 is historically an open source DBMS product?
Summarize the various ways that you might work with database technology.
What job functions does a knowledge worker perform?
What need drove the development of the first database technology?
What are Data Language/I and CODASYL DBTG?
What were the early objections to the relational model?
Name two early relational DBMS products.
What are some of the reasons for the success of Oracle Database?
Name three early personal computer DBMS products.
What was the purpose of OODBMS products? Describe two reasons that OODBMS products were not successful.
What characteristic of HTTP was a problem for some database processing applications?
Give an example of information that could be determined using the two tables you provided in your answer to question 1.6.
Define the terms data and information. Explain how the two terms differ.
Explain how the two tables you provided in Review Question 1.6 are related. Which table contains the foreign key, and what it is the foreign key?
What is the most commonly used type of database?
What is the purpose of a database?
Read the description of the search process on the Pearson Web site. Using your own computer, find another retailer Web site (other than any of those discussed or mentioned in this chapter), and search for something of interest to you. Write up a description (with screen shots if possible) of your
Why do today’s Internet Web applications and smartphone apps need databases?
Describe the historic development of Internet and smartphone technology from the early days of personal computers (PCs) to today’s Internet Web application and smartphone app based information systems environment.
Showing 700 - 800
of 781
1
2
3
4
5
6
7
8
Step by Step Answers
Get 50% OFF
Claim Now
