Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 6, Problem 6.47PAE
Modify to include only those product lines the average price of which is higher than $200.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the DRIVER_ID. After the change, you need to insert the following driver:
First Name: Nursin
Last Name: Yilmaz
Driving License ID: 4141447
Start Date: 2021-12-28
Driving License Checked: True
Rating: 4.0
Below are some rows of the PROVIDERS table for a factory:
PCODE
10192
98411
0489035
NAME
Hans, Inc.
Tools and More
Motors Inc.
PHONE
231 - 3092
231-1029
993 - 1821
All providers from the factory zone of the city start with 231. You want to get the providers that are in
the factory zone of the city. Which of the following is more appropriate?
O a.
O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231'
O C.
O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%'
SELECT * FROM PROVIDERS WHERE PHONE LIKE
231
SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity
discounts. The following table shows the price per roll depending on order size:
Quantity Ordered
To
Price per Roll
From
1
70
$215
71
140
$195
141
280
$175
281
and up
$155
Click on the datafile logo to reference the data.
DATA file
(a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders.
(b) Use the COUNTIF function to determine the number of orders in each price bin.
From
Number of
To
Price per Roll
70
$215
!!!
140
$195
280
$175
and up
$155
1
71
141
281
Orders
172
Chapter 6 Solutions
Modern Database Management
Ch. 6 - Define each of the following terms: dynamic view...Ch. 6 - Match the following terms to the appropriate...Ch. 6 - Prob. 6.3RQCh. 6 - Prob. 6.4RQCh. 6 - Prob. 6.5RQCh. 6 - Explain the relationship between EXISTS and...Ch. 6 - Prob. 6.7RQCh. 6 - Under what conditions can a UNION clause be used?Ch. 6 - Prob. 6.9RQCh. 6 - Explain why it is necessary to limit the kinds of...
Ch. 6 - Describe a set of circumstances for which using a...Ch. 6 - Prob. 6.12RQCh. 6 - Prob. 6.13RQCh. 6 - Prob. 6.14RQCh. 6 - Prob. 6.15RQCh. 6 - Prob. 6.16RQCh. 6 - Prob. 6.17RQCh. 6 - Prob. 6.18RQCh. 6 - Prob. 6.19RQCh. 6 - List for advantages of SQL-invoked routines.Ch. 6 - Prob. 6.21RQCh. 6 - Prob. 6.22RQCh. 6 - Prob. 6.23RQCh. 6 - This chapter discusses the data dictionary views...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Write SQL retrieval commands for each of the...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Write SQL queries to answer the following...Ch. 6 - Write SQL queries to answer the following...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Prob. 6.31PAECh. 6 - Prob. 6.32PAECh. 6 - Prob. 6.33PAECh. 6 - What do you need to do if a tutor signs up and...Ch. 6 - Prob. 6.35PAECh. 6 - Write the SQL query to find any tutors who have...Ch. 6 - Prob. 6.37PAECh. 6 - Write an SQL query to determine the total number...Ch. 6 - Prob. 6.39PAECh. 6 - Prob. 6.40PAECh. 6 - Prob. 6.41PAECh. 6 - Prob. 6.42PAECh. 6 - Prob. 6.43PAECh. 6 - Which tutor needs to be reminded to tum in...Ch. 6 - Prob. 6.45PAECh. 6 - Write an SQL query to list all product line names...Ch. 6 - Modify to include only those product lines the...Ch. 6 - Prob. 6.48PAECh. 6 - Prob. 6.49PAECh. 6 - Write an SQL query to display the order number,...Ch. 6 - Prob. 6.51PAECh. 6 - Prob. 6.52PAECh. 6 - Prob. 6.53PAECh. 6 - Prob. 6.54PAECh. 6 - Prob. 6.55PAECh. 6 - Prob. 6.56PAECh. 6 - Prob. 6.57PAECh. 6 - Prob. 6.58PAECh. 6 - Write an SQL query to list each customer who...Ch. 6 - Prob. 6.60PAECh. 6 - Modify Problem and Exercise 6-60 so that the list...Ch. 6 - Prob. 6.62PAECh. 6 - Prob. 6.63PAECh. 6 - Prob. 6.64PAECh. 6 - Prob. 6.65PAECh. 6 - Prob. 6.66PAECh. 6 - Prob. 6.67PAECh. 6 - Prob. 6.68PAECh. 6 - Prob. 6.69PAECh. 6 - Prob. 6.70PAECh. 6 - Prob. 6.71PAECh. 6 - Rewrite your answer to Problem and Exercise 6-71...Ch. 6 - Display the customer ID, name, and order ID for...Ch. 6 - Prob. 6.74PAECh. 6 - Prob. 6.75PAECh. 6 - Prob. 6.76PAECh. 6 - Prob. 6.77PAECh. 6 - Prob. 6.78PAECh. 6 - Prob. 6.79PAECh. 6 - Write an SQL query to list the order number,...Ch. 6 - Prob. 6.81PAECh. 6 - Prob. 6.82PAECh. 6 - Prob. 6.83PAECh. 6 - Prob. 6.84PAECh. 6 - Prob. 6.85PAE
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
For the circuit shown, find (a) the voltage υ, (b) the power delivered to the circuit by the current source, an...
Electric Circuits. (11th Edition)
Suppose a small company has five employees and is planning to increase the number to six. Moreover, suppose one...
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
What is a priority queue?
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
This optional Google account security feature sends you a message with a code that you must enter, in addition ...
SURVEY OF OPERATING SYSTEMS
State whether the members are in tension or compression. Set P = 8 kN. Probs. 6-16/17
INTERNATIONAL EDITION---Engineering Mechanics: Statics, 14th edition (SI unit)
24. If we increase the temperature in a reactor by 90 degrees Fahrenheit [°F], how many degrees Celsius [°C] wi...
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
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
- Below are some rows of the PROVIDERS table for a factory: PCODE NAME PHONE 10192 Hans, Inc. 231 - 3092 98411 Tools and More 231 - 1029 0489035 Motors Inc. 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? a. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’ b. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’ c. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’ d. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’arrow_forwardQ4 There are 9 workers for ASH Development Sdn. Bhd. Unfortunately, there are only 4 rooms available for these workers. Every week, a worker name is randomly selected to do odd jobs for the company. When a worker has been selected randomly, a these rooms are full. Based on Figure Q4, worker's ID number 0 (Umar) is randomly selected for the first week, and the 4 boxes represent 4 rooms for as shown in Table Q4. room needs to be vacated if workers. Table Q4 Worker's ID Worker's Name Umar 1. Lukman Arif Yusuf Anas Muadz Aleef Hafiz 8. Amir 9. Taufik WI 4 6 2 9. 4 1 3 8 D R2 R3 R4 W W W1 w1 Wi w1 W1 w1 w1 wi Wi W1 2 3 4 56 78 9 1 2 3 4 5 6 8 9 Figure Q4 Investigate the number of page faults occur by illustrating the way how the room is managed using the list of weekly random selection of workers as shown in Figure Q4 using the following algorithms: (a) Optimal Page Replacement (OPR) replacement algorithm 2. RRRarrow_forwardRichardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12arrow_forward
- herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraintsarrow_forwardThe same description as Problem I. You are asked to display order's item list and meal cost to customer. Each meal must have at least one main item, but side item and drink are optional. Also, a 10% coupon code is available to use. So the main items can be decorated by the side items, drink and coupon. This gives a customer flexibility to order any number of sides or drinks for a meal. Please note that each side item and drink can be multiple or partial. The cost of multiple or partial side and drink is adjusted proportionally, for example, cost of 2 orders of Coke is 2x$1.00, 40% order of Fries is 0.4x$1.5. However, coupon can be used only once per order. We would like to use the Decorator pattern and Singleton pattern to create the receipt to show order's item name, quantity, item unit price, item cost, any coupon applied and final cost. The singleton is to ensure that the coupon can be applied only once in an order. Here is price for each item Main items, Hamburger: $6.5;…arrow_forwardCan someone help? Thank you in advance The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.arrow_forward
- Consider the following set of requirements for a university database that is used to keep track of students' of student enrollments in classes and students' final grades: a. The university is organized into colleges (COLLEGE), and each college has a unique name (CName), a main office (COffice) and phone (CPhone), and particular faculty member who is dean of the college. Each college administers a number of academic departments (DEPT). Each department has a unique name (RName), a unique code number (RCode), a main office (ROffice) and phone (RPhone), and a particular faculty member who chairs the department. We keep track of the start date (CStartDate) when that faculty member began chairing the department. b. A department offers a number of courses (COURSE), each of which has a unique course name (COName), a unique code number (CCode), a course level (Level: this can be coded as 1 for freshman level, 2 for sophomore, 3 for junior, 4 for senior, 5 for MS level, and 6 for PhD level), a…arrow_forwardDepartment DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo Sname Fname DepartmentID 111 Ali Ahmed 1 112 Sana Waqar 2 113 Afzal Ikram 2 There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having: A) Structures, structure definitions and required initializations for the above scenario.arrow_forwardThe following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…arrow_forward
- The data section called Transaction Growth shows how many clothing sets were sold each month. Felicia entered a formula into the range O6:O10 to calculate the highest amount of each set sold over the course of the year. She notices that all of the values in the range are 2,146, even though more clothing sets than this were sold in some months. Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting.arrow_forwardFind the staff name who has the maximum salaryfor each branchFind the staff name who has the maximum salaryfor each cityFind the branch that does not have any staff Find the city that does not have any staffarrow_forwardLook up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME MAJOR ROOM 2 58 3 4 NAME MAJOR ROOM 5 $1 CIS DBH 6 S2 7 3 A/F DBH A/F DBH 8 $4 мом SCI 9 S5 мом DBH 10 56 CIS SCI 11 S7 CIS DBH 12 S8 A/F 13 S9 мом 14 S10 CIS Size Color Price Item T. 15 Size L T M 16 Color R. 17 Price 28 H. 29 30 XL R. 18arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License