Query-1: List all the contact details of a particular customer to show:• The customer's name• The contact type e.g. email• The contact details e.g. [email protected]: the customer's name is a parameter to enter when executing this query in Microsoft Access. A customer could have more than one contact e.g. email, mobile and home phone.Query-2: List all the rental properties that the asked prices (the price on the advertising) are the same as the rent prices (the price on the rent contract) to show:• The property type• The property address• The asked price2• The actual rent priceQuery-3: List all the sale properties that have been available for 6 months but not sold yet toshow:• The property type• The property address• The property sale price• The property available date• The property manager's nameQuery-4: List the properties that were sold in a particular suburb e.g. 'The Range' to show:• The buyer name• The property manager who sold the property• The property type• The property address• The asked price• The deal price• The date when the property was soldNote: the suburb name can be hardcoded in your query.Query-5: List the contact details of the solicitor who involved in a sold property of a particularaddress, e.g. '22 George Street' to show:• The property type• The property address• Solicitor name• All contact details of the solicitorNote: the property address can be hardcoded in your query.Query-6: List all rent properties which have 2 or more applications to show:• The property ID• The property type3• The property address• The weekly rent• The property manager's nameQuery-7: An owner wants to complain to a higher level officer about the management ofhis/her rental property. Find the supervisor of the property manager, who is currentlylooking after the property to show:• The property type• The property address• The owner name• The property manager's name• The supervisor's name of the property managerNote: the property address can be hardcoded in your query.Query-8: List all property managers in descendent order of the number of properties that theyhave been looking after to show:• The property type• The property address• The property status• The property manager's name3. Query ReportAssume that a property manager will contact the owner of a sale property to talk about the currentoffers for the property. Create a report to sort the offers in descending order (from the highest tothe lowest offered price) to show:• The property type• The property address• The property sale prices• The offered price• The name and his/her contact details of the customer who gave the offerNote: the property address can be hardcoded in your query.44. Implementation documentYou are to write a short report to demonstrate that you have thought carefully about the issues thatarise when implementing the database and the SQL queries. You need to address:• How you populate data for multi-valued attributes to make sure that they are enough tosupport the required SQL queries. Concrete examples from the database are required tojustify your statement.• Whether it is necessary to implement the property address as a composite attribute for therequired SQL queries. Concrete examples from the database are required to justify yourstatement.