Note: USE SQL and View the necessary SQL Scripts here >> https://1drv.ms/u/s!AtdfILv3w6pWa0NsldjxiBurZfI?e=Q1ejRl/

2. Solmaris Condominium Group has many condos that are available as weekly vacation rentals. Design a database to meet the following requirements:

Figure 3-1. Colonial Adventure Tours TRIP Table

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, end date of the rental, and the weekly rental amount. The rental period is one or more weeks. NOTE: USE SQL and answer letter C