Design a database that can satisfy the following requirements: a. For each marina, list the number, name, address, city, state, and zip code. b. For each boat owner, list the 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, the annual rental fee, the name and type of the boat occupying the slip, and the boat owner’s number, last name, and first name. d. For each possible service category, list the category number and description. In addition, for each service request in a category, list the marina number, and slip number for the boat receiving the service, the estimated hours for the service, the hours already spent on the service, and the next date that is scheduled for the particular service.
Design a
a. For each marina, list the number, name, address, city, state, and zip code.
b. For each boat owner, list the 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, the annual rental fee, the name and type of the boat occupying the slip, and the boat owner’s number, last name, and first name.
d. For each possible service category, list the category number and description. In addition, for each service request in a category, list the marina number, and slip number for the boat receiving the service, the estimated hours for the service, the hours already spent on the service, and the next date that is scheduled for the particular service.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
