Draw the physical ERD diagram without using the associative entities. foreign keys should be included.Any assumptions can be included.

You have a property management company that rents vacation properties through Airbnb. Your business model is being the middle person between property owners and Airbnb. Therefore, you find property owners in the Tampa Bay Area who want to rent their properties for summer, then list these properties on Airbnb on behalf of these property owners. You are responsible for all the logistics. And, you collect commissions from the property owners in return. You also take care of the housekeeping of these properties as well as their maintenance. You need to develop a database to keep track of your business. Requirements: You need to keep track of all owners and all of their properties under your management. Obviously, an owner can have more than one property, but a property has one owner. For each owner, you need to capture their name, current residence (different than the property address), and phone number. For each property, you need to capture the address of the property (that will be rented) along with the other characteristics of the property such as the type of property (condo/house/etc.), number of guests it can entertain, number of bedrooms, number of bathrooms, and number of beds. Sometimes, property owners refer other property owners to you. You want to keep track of these referrals (to provide discounts/promotions, etc.). A property owner can refer many other owners, but an owner can be referred by only one owner. You want to capture the amenities of each property to advertise on Airbnb. Currently, you have five types of amenities that a property can have: internet, cable, washer, dryer, and pool. (This list is likely to increase as you plan to capture other types of amenities in the future). It is possible that a property may have many amenities or none at all. Once a week, you send your crew to the properties to perform housekeeping (which includes cleaning, and restocking the disposables such as soaps, shampoo, etc.). For each housekeeping job, you want to keep track of the description (i.e., what was performed), its date, and its cost for the property owner. Obviously, a property can have many housekeeping jobs while it is under your management. You also want to keep track of the maintenance jobs performed on these properties. Each maintenance job is specific to a property. (For example, you will replace a window broken by a guest). Therefore, you want to keep track of the description of each maintenance job, the date it is performed, and its cost. Despite your best efforts, a property can have many maintenance jobs. Since the pricing of the rentals is your responsibility, you need to keep track of the prices of each property as well. To maximize your profits, you price the properties based on seasonal demand. For example, you can price a property as $100/night between Aug 1st and Aug 31st, but price the same property as $110/night between Sep 1st and Sep 30th. Therefore, you want to capture the starting and ending dates as well as the price that will be quoted to customers during that time. A property can have as many of these pricing schemas while it is under your management. Eventually, customers rent these properties. So, you want to keep track of each customer who rents a property. For each customer, you want to capture their name, address, and phone number. A property can be rented by many different customers. And it is possible that the same customer may rent many properties under your management. When a customer rents a property, you want to keep track of their check in and check out dates, as well as the number of guests. You also want to keep track of each customer's payment. So, you want to capture the amount paid by each customer and the date the payment is made. A customer can make more than one payment (since it possible that they can rent more than one property in their lifetime). Finally, you want to keep track of the reviews received by each property. (Note that reviews are anonymous). For each review, you want to keep track of the date of the review, the rating (out of 5 stars), and the comment provided by the customer. Naturally, a property can have more than one review.