Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 13, Problem 12P
Using the answer to Problem 10 as your base, what command would you need to generate the same output but with subtotals in all columns? (Hint: Use the CUBE command.) Figure P13.12 shows the result of the query.
FIGURE P13.12 PROBLEM 12 RESULT
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Problem #11: 1111 FR 10 500000 300000
Problem #12 : 2222 NB 16 400000 300000
Problem #13: 3333 BO 16 400000 275000
Problem #14: 4444 PR 23 400000 200000
Use the following pseudocode for questions 18-20:
Main Program: Start Declare variables idno, location, dept, budget, spent, msg Input idno, location, dept, budget, spent budgetMsg() Output idno, location, dept, budget, spent, msg Stop
budgetMsg() If dept < 20 If budget > 350000 msg = cut 7% Else msg = cut 6%
Endif
Endif
Question at position 18
18
Fill in the Blank
1 point
Question 18 is unpinned. Click to pin.
Question at position 18
What would the msg be set to if the following was input:
Input: 1111 BO 20 400000 300000
Output: cut
Question Blank 1 of 1
Question at position 19
19
Question at position 19
What would msg be if the input was the following:
Input: 2222 PR 14 100000 110000
Output: cut
Question 20
What would msg be if the input was the following:
Input: 3333 FR 25 200000 100000
Use the following pseudocode for questions 21-23:
Main Program: Start Declare variables idno, location, dept, budget, spent, msg Input idno, location, dept, budget, spent budgetMsg() Output idno, location, dept, budget, spent, msg Stop
budgetMsg() If dept < 20 If budget > 350000 msg = cut 7% Else msg = cut 6% End if Else msg = cut 5% End if
Question at position 21
What would msg be with the following input?
Input: 1111 BO 20 400000 300000
Output: cut %
Question at position 22
What would msg be with the following input?
Input: 2222 PR 14 100000 110000
Output: cut %
Question at position 23
What would msg be with the following input?
Input: 3333 FR 25 200000 100000
Output: cut %
Chapter 13 Solutions
Database Systems: Design, Implementation, & Management
Ch. 13 - Prob. 1RQCh. 13 - Prob. 2RQCh. 13 - Prob. 3RQCh. 13 - Prob. 4RQCh. 13 - Prob. 5RQCh. 13 - What is a data warehouse, and what are its main...Ch. 13 - Prob. 7RQCh. 13 - Prob. 8RQCh. 13 - Prob. 9RQCh. 13 - Prob. 10RQ
Ch. 13 - Prob. 11RQCh. 13 - Prob. 12RQCh. 13 - Prob. 13RQCh. 13 - Prob. 14RQCh. 13 - Prob. 15RQCh. 13 - Prob. 16RQCh. 13 - Prob. 17RQCh. 13 - Prob. 18RQCh. 13 - Prob. 19RQCh. 13 - Prob. 21RQCh. 13 - Prob. 22RQCh. 13 - Prob. 23RQCh. 13 - Prob. 24RQCh. 13 - Prob. 25RQCh. 13 - Prob. 26RQCh. 13 - Prob. 27RQCh. 13 - Prob. 28RQCh. 13 - Prob. 30RQCh. 13 - What is the SQL command to list the total sales by...Ch. 13 - What is the SQL command to list the total sales by...Ch. 13 - What is the SQL command to list the total sales by...Ch. 13 - What is the SQL command to list the total sales by...Ch. 13 - What is the SQL command to list the number of...Ch. 13 - What is the SQL command to list the number of...Ch. 13 - What is the SQL command to list the number of...Ch. 13 - Using the answer to Problem 10 as your base, what...
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
- Please help me solve this financial accounting problem with the correct financial process.arrow_forwardI need help finding the accurate solution to this general accounting problem with valid methods.arrow_forwardI am searching for the correct answer to this general accounting problem with proper accounting rules.arrow_forward
- Can you explain this general accounting question using accurate calculation methods?arrow_forwardPlease provide the answer to this financial accounting question using the right approach.arrow_forwardPlease provide the correct answer to this general accounting problem using accurate calculations.arrow_forward
- Can you solve this general accounting question with the appropriate general analysis techniques?arrow_forwardPlease provide the correct answer to this general accounting problem using accurate calculations.arrow_forwardCan you solve this accounting problem using accurate calculation methods?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY