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.
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.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.