can please someone help me with this assignment

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 condo location, list the location number, name, address, city, state, and postal code.

b. For each condo owner, list the owner number, last name, first name, address, city, state, and postal code.

c. For each condo location, list all the units in the condo. For each condo unit, list the square footage, bed- rooms, bathrooms, condo fee, and condo owners 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 location number, condo unit number of the condo receiving the service, esti- mated hours for the service, hours already spent on the service, and next scheduled service date.

e. For each service request, list the location number, condo unit 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 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.

3. Solmaris Condominium Group has many condos that are available as weekly vacation rentals. Design a data- base to meet the following requirements:

a. For each renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and email address.

b. For each property, list the condo location number, condo location name, address, city, state, postal code, condo unit number, square footage, bedrooms, bathrooms, maximum number of persons that can sleep in the unit, and the base weekly rate.

c. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, the end date of the rental, and the rental amount. Renters can rent for one or more weeks.