NEED ERD DIAGRAM OF THIS SCENARIO chargers for all the facilities being offered. Charges information is to be tabulated by the startupteam 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 variousfacilities, 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 toteam 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 parttime) are also recorded.TAKE NOTE:The start-up team is also required to carry out findings (research) to improve the aboverequirement given. As a new team you need be aware of the services that you plan to offer andhow you are planning to bring in this records into the database. The research phase is to bring themodel to incorporate other relevant information that would make the database a more useful forAK (relevant to item 4 tabled below in business process change).The above business requirement is derived from final version document of AK SystemRequirement Specification (SRS). The above model requires some changes to cater for businessprocess changes encountered from the year 2019. The detailed requirement have been tabulatedto 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 cleardirection on what is intended to be part of the final database model required from the start-upteam. Your task is to ensure that given information is properly analysed and considered for thedatabase modelling phase. The Team lead have communicated the following information to youand expecting AK to deliver the changes to accommodate to the current system as soon aspossible.Ignore the side effects of the global pandemic that started early 2019 during design anddevelopment stages.Business Process Change: Document V1.1.21. The system should detail down the customers address and multiple contact numberfor emergencies and direct marketing purpose.2. The system need to record staff information, as a requirement for the knowing whichstaff whom brought the sales. This information is for all the bookings that are madepersonally 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 requirementsthat would be added advantage for the system. Include the requirement into BusinessProcess Change V1.1.2. Case Study: AK managementAK management just started its business in Damansara. AK management wishes toremodel the business database to store and manage information about their new start-up. Thestart-up centre takes bookings from clients for adventure filled holidays and team buildingevents. The client may or may not opt for accommodation but keen with team building activitiesand 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 includestheir unique client number, the client's name (School name, business name, etc.), and thenames and mobile contact details of the persons representing the client organisation. Someschools, 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-goingmarketing information.The centre has a number of accommodation options which includes: a four star hotel calledSnoopy Lupiz offering different types of rooms (single, Double, King suite, Luxury suite andothers); a hostel with large dormitories for children and smaller shared rooms for supervisingadults; and a small camping ground. The name and type of these options is stored, along withthe 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, theperson details who made the booking, and the dates of the stay. When booking is made, clientsneed 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 thehotel, and hostel provide. Clients' needs to specify whether they will use the restaurant or selfcatering facilities. The booking will also include any additional facilities required by the client.The centre contains a number of additional facilities for hire. These include Board meetingrooms, conference/forum halls, and computing labs with Internet access. Portable multi-mediaprojection and presentation equipment are also available for hire. You may consider paymentPage 5 of 11

E-R Diagram:- How entities relate to one another is shown in an entity relationship diagram. Simply…

Case Study: AK management AK management just started its business in Damansara. AK management wishes to remodel the business database to store and manage information about their new start-up. The start-up centre 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 centre 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 centre 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 Page 5 of 11