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

A Database Architecture represents the Database Management System’s (DBMS) design (schema). The DBMS architecture makes it easy to understand the components involved in the database system and their relations. The DBMS architecture may vary based on the …