15. Create a new table named Hiking that includes all columns in the Reservation table where the trip type is Hiking. 16. Use an update query to change the OtherFees value in the Hiking table to $5.00 for all records on which the OtherFees value is $0.00. 17. Use a delete query to delete all trips in the Hiking table where the trip date is 6/12/2016.
15. Create a new table named Hiking that includes all columns in the Reservation table where the trip type is Hiking. 16. Use an update query to change the OtherFees value in the Hiking table to $5.00 for all records on which the OtherFees value is $0.00. 17. Use a delete query to delete all trips in the Hiking table where the trip date is 6/12/2016.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
15. Create a new table named Hiking that includes all columns in the Reservation table where the trip type is
Hiking.
16. Use an update query to change the OtherFees value in the Hiking table to $5.00 for all records on which the
OtherFees value is $0.00.
17. Use a delete query to delete all trips in the Hiking table where the trip date is 6/12/2016.
18. One of the reservations agents at Colonial Adventure Tours created the query shown in Figure 2-46 to list each
trip name and the last name and first name of each corresponding guide. The query results included 410
records and he knows that this result is incorrect. Why did he get so many records? What should he change in
the query design to get the correct query results?
Transcribed Image Text:Reservation
ReservationID TripID TripDate
NumPersonsTripPrice OtherFees CustomerNum
1600001
40
3/26/2016
6/8/2016
9/12/2016
26 10/16/2016
6/25/2016
6/18/2016
7/9/2016
9/12/2016
9/11/2016
5/14/2016
9/15/2016
6/12/2016
7/9/2016
10/1/2016
7/23/2016
7/23/2016
6/18/2016
9/18/2016
2
$55.00
$0.00 101
1600002
21
2
$95.00
$0.00 101
1600003
28
1
$35.00
$0.00 103
1600004
$45.00
$15.00 104
1600005
39
5
$55.00
$0.00 105
1600006
32
1
$80.00
$20.00 106
1600007
22
8.
$75.00
$10.00 107
1600008
28
2
$35.00
$0.00 108
1600009
38
$90.00
$40.00 109
1600010
$25.00
$0.00 102
1600011
$25.00
$0.00 102
1600012
1
$15.00
$0.00 115
1600013
8.
1.
$20.00
$5.00 116
1600014
12
$40.00
$5.00 119
1600015
10
1
$20.00
$0.00 120
1600016
11
6.
$75.00
$15.00 121
1600017
39
$20.00
$5.00 122
1600018
38
$85.00
$15.00 126
1600019
25
8/29/2016
8/27/2016
6/11/2016
6/8/2016
9/11/2016
9/11/2016
10/1/2016
9/19/2016
7/25/2016
$110.00
$25.00 124
1600020
28
$35.00
$10.00 124
1600021
32
3
$90.00
$20.00 112
1600022
21
1
$95.00
$25.00 119
1600024
38
1.
$70.00
$30.00 121
1600025
38
2
$70.00
$45.00 125
1600026
12
$40.00
$0.00 126
1600029
$105.00
6.
4
4
$25.00 120
1600030
15
$60.00
$15.00 104
Transcribed Image Text:Trip
TripID TripName
StartLocation
State Distance MaxGrpSize Type
Season
Harts Location
10 Hiking
6 Hiking
10 Hiking
8 Biking
10 Hiking
8 Hiking
6 Paddling Late Spring
12 Hiking
10 Hiking
8 Hiking
15 Paddling Summer
16 Biking
8 Hiking
1 Arethusa Falls
NH
5
Summer
2 Mt Ascutney - North Peak
3 Mt Ascutney - West Peak
4 Bradbury Mountain Ride
5 Baldpate Mountain
6 Blueberry Mountain
Weathersfield
Weathersfield
Lewiston-Auburn
North Newry
Batchelders Grant
VT
5
Late Spring
Early Fall
Early Fall
| Late Spring
Early Fall
VT
6.
ME
25
ME
6.
ME
8.
7 Bloomfield - Maidstone
Bloomfield
CT
10
8 Black Pond
9 Big Rock Cave
10 Mt. Cardigan - Firescrew
Lincoln
NH
8.
Summer
Tamworth
NH
Summer
Orange
NH
7
Summer
11 Chocorua Lake Tour
Tamworth
NH
12
Bar Harbor
Early Fall
Late Spring
Early Fall
12 Cadillac Mountain Ride
ME
8.
13 Cadillac Mountain
Bar Harbor
ME
7
14 Cannon Mtn
Franconia
NH
6.
6 Hiking
4 Hiking
16 Hiking
10 Hiking
6 Hiking
7 Paddling Late Spring
15 Paddling Late Spring
12 Hiking
10 Paddling Summer
15 Paddling Late Spring
6 Hiking
15 Crawford Path Presidentials Hike
Crawford Notch
NH
16
Summer
16 Cherry Pond
17 Huguenot Head Hike
18 Low Bald Spot Hike
Whitefield
NH
Spring
Early Fall
Early Fall
Bar Harbor
ME
5
Pinkam Notch
NH
8.
19 Mason's Farm
North Stratford
CT
12
20 Lake Mephremagog Tour
21 Long Pond
22 Long Pond Tour
Newport
VT
Rutland
MA
8.
Summer
Greenville
ME
12
23 Lower Pond Tour
Poland
МЕ
Randolph
Camden
24 Mt Adams
NH
Summer
25
Mount Battie Ride
ME
20
8.
Biking
Farly Fall
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education