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 11, Problem 24P
Problems 22–24 are based on the following query:
| SELECT | P_CODE, P_DESCRIPT, P_PRICE, P.V_CODE, V_STATE |
| FROM | PRODUCT P, VENDOR V |
| WHERE | P.V_CODE = V.V_CODE |
| AND V_STATE = 'NY' | |
| AND V_AREACODE = '212' | |
| ORDER BY | P_PRICE; |
Write the command(s) used to generate the statistics for the PRODUCT and VENDOR tables.
Expert Solution & Answer
Trending nowThis is a popular 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 11 Solutions
Database Systems: Design, Implementation, & Management
Ch. 11 - Prob. 1RQCh. 11 - What index should you create? Write the required...Ch. 11 - What is the focus of most performance-tuning...Ch. 11 - What are database statistics, and why are they...Ch. 11 - How are database statistics obtained?Ch. 11 - What database statistics measurements are typical...Ch. 11 - How is the processing of SQL DDL statements (such...Ch. 11 - In simple terms, the DBMS processes a query in...Ch. 11 - If indexes are so important, why not index every...Ch. 11 - What is the difference between a rule-based...
Ch. 11 - Prob. 11RQCh. 11 - What are some general guidelines for creating and...Ch. 11 - Prob. 13RQCh. 11 - Prob. 14RQCh. 11 - Prob. 15RQCh. 11 - SELECT SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE,...Ch. 11 - Problem 1 and 2 are based on the following query:...Ch. 11 - Using Table 11.4 as an example, create two...Ch. 11 - Problems 46 are based on the following query:...Ch. 11 - Problems 46 are based on the following query:...Ch. 11 - Prob. 6PCh. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 732 are based on the ER model shown in...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 1114 are based on the following query:...Ch. 11 - Problems 15 and 16 are based on the following...Ch. 11 - Problems 15 and 16 are based on the following...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Problems 1721 are based on the following query:...Ch. 11 - Prob. 19PCh. 11 - Prob. 20PCh. 11 - Problems 1721 are based on the following query:...Ch. 11 - SELECT SELECT P_CODE, P_DESCRIPT, P_PRICE,...Ch. 11 - Problems 2224 are based on the following query:...Ch. 11 - Problems 2224 are based on the following query:...Ch. 11 - Problems 25 and 26 are based on the following...Ch. 11 - Problems 25 and 26 are based on the following...Ch. 11 - Prob. 27PCh. 11 - Problems 27 and 28 are based on the following...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...Ch. 11 - Problems 2932 are based on the following query:...
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
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
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