I would to ask about the Part C: SQL Report question 4 to 9.Thank You!

Case Study: Event Management Customizer (EMC) EMC runs a start-up center based in Subang Jaya wishes to remodel the business database to store and manage information about their new start-up. The start-up center takes bookings from clients for adventure filled holidays and team building events. The client may or may not opt for accommodation but keen with team building activities and some just opt for accommodation and other relevant services. Based on your business, your clients are usually classified from family members, businesses, governmental institutions, and schools. Information stored about clients includes their unique client number, the client's name (School name, business name, etc.), and the names and mobile contact details of the persons representing the client organisation. Some schools, governmental institutions, and business clients have provided more contact details. This to ensure contact are reached precisely on time when required as also to provide on-going marketing information. The center has a number of accommodation options which includes: a four star hotel called Snoopy Lupiz offering different types of rooms (single, Double, King suite, Luxury suite and others); a hostel with large dormitories for children and smaller shared rooms for supervising adults; and a small camping ground. The name and type of these options is stored, along with the total number of people they can accommodate, address, and Their geographical locations (latitude and longitude). Each booking has a unique booking number, the date and time that booking was made, the person details who made the booking, and the dates of the stay. When booking is made, clients need to state how many people will be staying, and what type of accommodation is required. Type of accommodation have to be stored preciously based on accommodation types that the hotel, and hostel provide. Clients' needs to specify whether they will use the restaurant or self- catering facilities. The booking will also include any additional facilities required by the client. The center contains a number of additional facilities for hire. These include Board meeting rooms, conference/forum halls, and computing labs with Internet access. Portable multi-media projection and presentation equipment are also available for hire. You may consider payment chargers for all the facilities being offered. Charges information is to be tabulated by the startup team as the financial information will not be a predominant information till the system rollout. There are various outdoor pursuits' facilities including: climbing-wall with safety equipment, paintball-war games, canoes, swimming, basketball, football... etc. Details of these various facilities, including any hire charges, need to be stored on the database. During any booking, the client may use these facilities. The date when a facility is booked for use must be recorded. In order to monitor and facilitate the outdoor activities an experienced staff is assigned to team building activities. Staff may be trained to supervise more than one outdoor pursuit facility. Each member of staff has a unique staff number, and their name and contract details (full or part time) are also recorded. TAKE NOTE: The start-up team is also required to carry out findings (research) to improve the above requirement given. As a new team you need be aware of the services that you plan to offer and how you are planning to bring in this records into the database. The research phase is to bring the model to incorporate other relevant information that would make the database a more useful for EMC (relevant to item 4 tabled below in business process change). The above business requirement is derived from final version document of EMC System Requirement Specification (SRS). The above model requires some changes to cater for business process changes encountered from the year 2019. The detailed requirement have been tabulated to provide proper understanding of what is intended from the start-up team. Client information, booking information, activities, facilities...etc. have been detailed out clearly to provide a clear direction on what is intended to be part of the final database model required from the start-up team. Your task is to ensure that given information is properly analysed and considered for the database modelling phase. The Team lead have communicated the following information to you and expecting EMC to deliver the changes to accommodate to the current system as soon as possible. > Ignore the side effects of the global pandemic that started early 2019 during design and development stages. Business Process Change: Document V1.1.2 1. The system should detail down the customers address and multiple contact number for emergencies and direct marketing purpose. 2. The system need to record staff information, as a requirement for the knowing which staff whom brought the sales. This information is for all the bookings that are made personally with the staff. 3. Projections - the company would require the system to be able to sales being made. You are required to ensure that all the necessary information is recorded in the table, allowing the user to compute this totals without messy procedures. 4. Final requirement - open suggestion from your team to include 2 more requirements that would be added advantage for the system. Include the requirement into Business Process Change V1.1.2. C. SQL Report: (30 marks) 4. Provide a list of businesses that have the most service transaction (service transaction means - they have booked many facilities / services using this system) by state or Town. 5. Provide a list of clients by business clients, school and Youth group - representative (name & contact numbers). 6. Write SQL query to list down total number of rooms that are of type dormitories. QUESTION 7. Compute an increase of 6% on booking charges for all the facilities. Upon having the increased price now compute the raw income that would be been achieved in 2019 using the new price. 8. Provide a report that indicates the total number of booking closed by staff in the year 2020. 9. Identify from the system the staff that have closed the highest sales for the year 2020