Complete the following task. 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.

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 particular 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 specific 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.