Databases Reference
In-Depth Information
10.
Labor is billed at the rate of $60 per hour. List the slip ID, category number, estimated hours, and estimated labor
cost for every service request. To obtain the estimated labor cost, multiply the estimated hours by 60. Use the col-
umn name EstimatedCost for the estimated labor cost.
11.
List the marina number and slip number for all slips containing a boat with the type Sprite 4000, Sprite 3000,
or Ray 4025.
115
12.
List the marina number, slip number, and boat name for all boats. Sort the results by boat name within the
marina number.
13.
How many Dolphin 28 boats are stored at both marinas?
14.
Calculate the total rental fees Alexamara receives each year based on the length of the slip.
15.
For every boat, list the marina number, slip number, boat name, owner number, owner's first name, and own-
er's last name.
16.
For every completed or open service request for routine engine maintenance, list the slip ID, description,
and status.
17.
For every service request for routine engine maintenance, list the slip ID, marina number, slip number, esti-
mated hours, spent hours, owner number, and owner's last name.
18.
Create a new table named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and
OwnerNum columns in the MarinaSlip table for slips with lengths of 40 feet.
19.
Use an update query to change the rental fee of any slip in the LargeSlip table whose fee is currently $3,800
to $3,900.
20.
Use a delete query to delete slips in the LargeSlip table whose rental fee is $3,600.
