Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question
100%
Question 47
A large spreadsheet contains the following information about local restaurants. A sample portion of the spreadsheet is shown below.
D
E
A
B
Number of
Average
Ассepts
Restaurant Name
Price Range
Customer Rating
Credit Cards
Customer Ratings
182
3.5
false
1
Joey Calzone's Pizzeria
lo
41
4.5
false
78th Street Bistro
med
Seaside Taqueria
214
4.5
true
3
med
lo
202
4.0
false
4
Delicious Sub Shop II
hi
116
4.5
true
5
Rustic Farm Tavern
6
ABC Downtown Diner
med
-1.0
true
• In column B, the price range represents the typical cost of a meal, where "lo" indicates under $10, "med" indicates $11 to $30, and "hi" indicates over $30.
• In column D, the average customer rating is set to -1.0 for restaurants that have no customer ratings.
A student wants to count the number of restaurants in the spreadsheet whose price range is $30 or less and whose average customer rating is at least 4.0. For a given row in the spreadsheet,
suppose prcRange contains the price range as a string and avgRating contains the average customer rating as a decimal number.
Which of the following expressions will evaluate to true if the restaurant should be counted and evaluates to false otherwise?
A
(avgRating è 4.0) AND ((prcRange = "lo") AND (prcRange = "med"))
(avgRating 2 4.0) AND ((prcRange = "lo") OR (prcRange = "med"))
(avgRating 2 4.0) OR ((prcRange = "lo") AND (prcRange = "med"))
%3D
D
(avgRating 2 4.0) OR ((prcRange = "lo") OR (prcRange = "med"))
%3D
expand button
Transcribed Image Text:A large spreadsheet contains the following information about local restaurants. A sample portion of the spreadsheet is shown below. D E A B Number of Average Ассepts Restaurant Name Price Range Customer Rating Credit Cards Customer Ratings 182 3.5 false 1 Joey Calzone's Pizzeria lo 41 4.5 false 78th Street Bistro med Seaside Taqueria 214 4.5 true 3 med lo 202 4.0 false 4 Delicious Sub Shop II hi 116 4.5 true 5 Rustic Farm Tavern 6 ABC Downtown Diner med -1.0 true • In column B, the price range represents the typical cost of a meal, where "lo" indicates under $10, "med" indicates $11 to $30, and "hi" indicates over $30. • In column D, the average customer rating is set to -1.0 for restaurants that have no customer ratings. A student wants to count the number of restaurants in the spreadsheet whose price range is $30 or less and whose average customer rating is at least 4.0. For a given row in the spreadsheet, suppose prcRange contains the price range as a string and avgRating contains the average customer rating as a decimal number. Which of the following expressions will evaluate to true if the restaurant should be counted and evaluates to false otherwise? A (avgRating è 4.0) AND ((prcRange = "lo") AND (prcRange = "med")) (avgRating 2 4.0) AND ((prcRange = "lo") OR (prcRange = "med")) (avgRating 2 4.0) OR ((prcRange = "lo") AND (prcRange = "med")) %3D D (avgRating 2 4.0) OR ((prcRange = "lo") OR (prcRange = "med")) %3D
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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.
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education