“Property Rental WA” offers specialist property services to rent real estate throughout Western Australia. The company has more than 10 branches across Western Australia and has at least one branch in every major city such as Perth and Joondalup. The company plans to develop a website to provide online rental service to tenants and landlords. Potential tenants can retrieve property details posted by landlords. The website also allows potential tenants to make appointments to view chosen properties including apartments, houses, villas and townhouses. These tasks can all be performed 24 hours of the day, 7 days a week on the website. Potential tenants are free to retrieve property details (such as address, size, price, property type and so on) but they must register before they can make appointments to inspect properties. The website needs to be able to store client details such as name, date of birth, address and so on. A valid email address and phone number must also be provided and stored. Once an appointment is confirmed, details of the appointment will be saved and a confirmation email will be sent to the potential tenant. A client service representative will be assigned to follow up with the appointment by phone calls. CIO of Property Rental WA, Clinton Wilson, has asked your team to come up with a database that can support the online rental services website. Clinton wants the new database to be able to store data about landlords, tenants, properties and appointments. He also wishes to use this data to generate the following reports using SQL: • A list of the most/least popular properties in a particular year (per property type) • A list of staff who handles the most/least appointments in a particular month and year • A list of potential tenants who has never made an appointment to inspect properties • Display name, age and gender of the oldest female potential tenant(s) as well as the youngest male potential tenant(s). For PART 1 of the assignment, you are required to submit: • an ER Diagram • SQL Script to create tables. Each table creation script must include two extra queries to demonstrate data insertion • at least 5 SQL queries to generate the business reports • submit any Business Rules or Assumptions made