Databases Reference
In-Depth Information
Complete the following tasks. In each exercise, represent your answer in both DBDL and with a diagram. You may use
any of the styles presented in this chapter for the diagram.
1.
Design a database to produce the following reports. Do not use any surrogate keys in your design.
a.
For each marina, list the marina number, name, address, city, state, and zip code.
b.
For each boat owner, list the owner number, last name, first name, address, city, state, and zip code.
c.
For each marina, list all the slips in the marina. For each slip, list the length of the slip; annual rental fee;
name and type of the boat occupying the slip; and boat owner's number, last name, and first name.
223
d.
For each service category, list the category number and description. In addition, for each service request
in each category, list the marina number, slip number of the boat receiving the service, estimated hours for
the service, hours already spent on the service, and next scheduled service date.
e.
For each service request, list the marina number, slip number, category description, description of the par-
ticular service, and a description of the current status of the service.
2.
Expand the database design you created in Exercise 1 so that it will also support the following situation: A spe-
cific technician handles each service request. Along with all the details concerning a service request listed in
Exercise 1, list the number, last name, and first name of the technician assigned to handle the request.
