A Guide to SQL, Ninth Edition Solutions 1-1
Chapter 1: An Introduction to TAL Distributors, Colonial
Adventure Tours, and Solmaris Condominium Group
Solutions
Answers to Review Questions
Due to the nature of the material in Chapter 1, there are no Review Questions.
Answers to TAL Distributors Exercises
1.
CUSTOMER_NAME
All Season Gifts
Cards and More
Cricket Gift Shop
Grove Historical Museum Store
Johnson’s Department Store
The Everything Shop
Toys Galore
Unique Gifts
2.
ORDER_NUM
51617
51623
3.
ITEM_NUM
DESCRIPTION
ON_HAND_VALUE
CD33
Wood Block Set (48 piece)
3221.64
DL51
Classic Railway Set
1295.4
FD11
Rocking Horse
999.6
NL89
Wood Block Set (62 piece)
3832
TW35
Fire Engine
3568.5
4.
ITEM_NUM
DESCRIPTION
DR67
Giant Star Brain Teaser
FH24
Puzzle Gift Set
KD34
Pentominoes Brain Teaser
MT03
Zauberkasten Brain Teaser
5.
6.
ITEM_NUM
DESCRIPTION
PRICE
KL78
Pick Up Sticks
$10.95
7.
ORDER_NUM
ORDER_DATE
CUSTOMER_NUM
CUSTOMER_NAME
51608
10/12/2015
126
Toys Galore
51610
10/12/2015
334
The Everything Shop
51613
10/13/2015
386
Johnson’s Department Store
51614
10/13/2015
260
Brookings Direct
51617
10/15/2015
586
Almondton General Store
51619
10/15/2015
126
Toys Galore
51623
10/15/2015
586
Almondton General Store
51625
10/16/2015
796
Unique Gifts
8.
ORDER_NUM
CUSTOMER_NUM
CUSTOMER_NAME
51613
386
Johnson’s Department Store
51614
260
Brookings Direct
9.
REP_NUM
LAST_NAME
FIRST_NAME
15
Campos
Rafael
30
Gradey
Megan
10.
ORDER_NUM
ITEM_NUM
DESCRIPTION
CATEGORY
51608
CD33
Wood Block Set (48 piece)
TOY
51610
TR40
Tic Tac Toe
GME
51610
KL78
Pick Up Sticks
GME
11. [Critical Thinking] Student answers will vary. Obvious choices include: company telephone number and company
A Guide to SQL, Ninth Edition Solutions 1-3
Answers to Colonial Adventure Tours Exercises
1.
FIRST_NAME
LAST_NAME
Hal
Rowan
2.
TRIP_NAME
Sawyer River Ride
3.
TRIP_ID
TRIP_NAME
7
Bloomfield – Maidstone
11
Chocorua Lake Tour
19
Mason’s Farm
20
Lake Mephremagog Tour
22
Long Pond Tour
23
Lower Pond Tour
31
Missisquoi River – VT
32
Northern Forest Canoe Trail
34
Pontook Reservoir Tour
4.
TRIP_ID
TRIP_NAME
4
Bradbury Mountain Ride
12
Cadillac Mountain Ride
25
Mount Battie Ride
38
Sawyer River Ride
5.
TRIP_ID
TRIP_NAME
2
Mt Ascutney – North Peak
3
Mt Ascutney – West Peak
7
Bloomfield – Maidstone
11
Chocorua Lake Tour
19
Mason’s Farm
20
Lake Mephremagog Tour
22
Long Pond Tour
23
Lower Pond Tour
31
Missisquoi River – VT
32
Northern Forest Canoe Trail
34
Pontook Reservoir Tour
6.
24
7.
TRIP_NAME
Arethusa Falls
Blueberry Mountain
Cadillac Mountain
Huguenot Head Hike
Seal Beach Harbor
8.
TRIP_NAME
Park Loop Ride
Westfield River Loop
9.
FIRST_NAME
LAST_NAME
Hal
Rowan
Lori
Stevens
Glory
Unser
10.
5
11.
FIRST_NAME
LAST_NAME
TRIP_NAME
TYPE
Siam
Bretton-Borak
Sawyer River Ride
Biking
Siam
Bretton-Borak
Chocorua Lake Tour
Paddling
Brianne
Brown
Sawyer River Ride
Biking
Brianne
Brown
Cadillac Mountain Ride
Biking
Karen
Busa
Mount Garfield Hike
Hiking
Karen
Busa
Mount Battie Ride
Biking
Clement
Chau
Long Pond
Hiking
Clement
Chau
Cadillac Mountain Ride
Biking
Sadie
Gernowski
Bradbury Mountain Ride
Biking
Sadie
Gernowski
Mt. Cardigan – Firescrew
Hiking
Ryan
Goff
Crawford Path Presidentials Hike
Hiking
Ryan
Goff
Mount Cardigan Hike
Hiking
Liam
Northfold
Wachusett Mountain
Hiking
Liam
Northfold
Long Pond
Hiking
Arnold
Ocean
Mt Ascutney – West Peak
Hiking
Arnold
Ocean
Mt Ascutney – North Peak
Hiking
12.
LAST_NAME
Chau
Northfold
13.
8
14. [Critical Thinking] Place the trip cost (trip price) field in the TRIP table because it is dependent on only the type of
A Guide to SQL, Ninth Edition Solutions 1-6
Answers to Solmaris Condominium Group Exercises
1.
OWNER_NUM
LAST_NAME
FIRST_NAME
AD057
Adney
Bruce and Jean
AN175
Anderson
Bill
BL720
Blake
Jack
EL025
Elend
Bill and Sandy
FE182
Feenstra
Daniel
JU092
Juarez
Maria
KE122
Kelly
Alyssa
NO225
Norton
Peter and Caitlin
RO123
Robinson
Mike and Jane
SM072
Smeltz
Jim and Cathy
TR222
Trent
Michael
WS032
Wilson
Henry and Karen
2.
LAST_NAME
FIRST_NAME
Adney
Bruce and Jean
Elend
Bill and Sandy
3.
CONDO_ID
1
2
6
7
9
12
4.
LAST_NAME
FIRST_NAME
CITY
Anderson
Bill
Brunswick
Robinson
Mike and Jane
Springs
5.
LAST_NAME
FIRST_NAME
CITY
Anderson
Bill
Brunswick
Norton
Peter and Caitlin
Lawndale
Trent
Michael
Glander Bay
6.
UNIT_NUM
102
201
A Guide to SQL, Ninth Edition Solutions 1-7
UNIT_NUM
306
204
405
401
502
503
7.
4
8.
9
9.
LAST_NAME
FIRST_NAME
UNIT_NUM
Adney
Bruce and Jean
102
Elend
Bill and Sandy
201
Elend
Bill and Sandy
201
Blake
Jack
204
Feenstra
Daniel
405
Juarez
Maria
502
Trent
Michael
A03
Trent
Michael
A03
Smeltz
Jim and Cathy
B01
Robinson
Mike and Jane
C06
10.
CONDO_ID
SQR_FT
4.00
1,164
7.00
745
11.
CONDO_ID
LOCATION_NAME
4.00
Solmaris Ocean
14.00
Solmaris Bayside
12.
555.00