Need help

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

Solaris Condominium Group has many condos that are available as weekly vacation rentals. Design a database 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 weekly rate.

Il AT&T? 09:47 a chegg.com 1 Solmurh Ocean 100 Ocean Ave. Bowon 31313 AD057 Adney Bnace and Jean 100 Ocean Ave Bo FL 31313 runewick GA 31522 ELOCS Bed Bil and Sandy 100 Ocean Ave FL 31313 Kain..31521 N0225 Nonon Peter and Cann 281Lakewood Ave. LawNble PA19111 672 Condor St 7822 CovestryDr. Rivard KE122 Kely Ayssa NononI 4944 RO123Robiaon Mike and Jane 900 Spring Labe De Springs M 49456 TR222Trent 405 Bayside Bd. Glander Bay FL 31044 CondoUnit 1 30 10 550 EL025 1625 AN175 575 BL.720 25 FE182 550 KE122 306 1,575 1204 1,1642 2 1,575 401 1,002 1 502 1 503 1,803 2 A03 2 AOI 745 1 670 RO123 190 TR222 1,0842 1,084 1235 No225 2 2 750 1 20 SM072 190 AN175 Bectrical Sysdems 5 Carpeeary Bact wall in paxery has Service rep has verited the mold indicating waterproblem uning Air condioning donnt cool. 3 1 10122015 beem caled Hardwood foon Semiceal 1036 2015 5 Molding in paery ut Cannot schedule un 3 Uit needs to be repainted Scheduled 1019 2015 4 Tenant complained that Sendce rep unable so 0 10362015 5 102015