Ab Fab Lab Fitness Centre Booking System PDF

Exam Revision Lecture Case Study - Ab Fab Lab The ‘Ab Fab Lab’ (AFL) is a health and fitness centre. The company has decided to develop an online booking system that allows fitness centre members to register on and retrieve information about fitness classes that are ava...

Exam Revision Lecture Case Study - Ab Fab Lab The ‘Ab Fab Lab’ (AFL) is a health and fitness centre. The company has decided to develop an online booking system that allows fitness centre members to register on and retrieve information about fitness classes that are available based on their fitness interests. For example, fitness centre members are able to view fitness class information such as class name, class description, class level, class duration, instructor, available places and class registration period. Fitness centre members can also view their previous class registrations. This system is intended to hold information both about the fitness instructors that run classes and the members that attend the classes. In terms of booking a place on a class, fitness centre members should be able to book themselves onto classes via an online interface. Bookings can be made up until 1 hour before the time of the class. Administrative staff members of AFL should also be able to take bookings from members over the telephone or at the reception desk at the fitness centre. The system should only allow administrative AFL staff members to check levels of attendance at each respective class and make cancellations on behalf of members where necessary. Therefore, fitness instructors have to liaise with administrative staff with appropriate system privileges to create a new fitness class or cancel a class on the system if 5 attendees or less are enrolled. Administrative staff are the only users who have the administrative rights to create new classes or cancel existing classes and browse total number of enrolments on the system, for each respective class. At the end of the class, the fitness instructor takes a note of the members that attended the class and passes a paper record in the form of an attendee list back to the administrator. The administrator then logs which fitness centre members were in attendance for that class. There are a total of 25 AFL fitness centres across the UK and Ireland. Company directors would like to implement this online booking system for all of their existing centres, and it is crucial that this system is up and running in all locations within 12 months and includes all the required functionality. They have set aside a fixed budget of £200,000 to have this work done. Company directors are very keen to be involved and monitor the progress of the project, as they believe any issues with the new system could have serious financial and reputational repercussions. AFL employees have little interest in the project, and it is unclear whether they will be consulted. An initial database design is provided below, which indicates some of the information that should be stored by the system. This is by no means a complete design and list of entities and attributes but provides some further insight into the sorts of functionality that the system will support. Database design  Instructor Instructor_ID Instructor_Name 1 Runs 1..* Member Fitness_Class Member_id Reservations Fitness_Class_id Member_Fname Makes Reservation_id Associated with Fitness_Class_name Member_Sname Member_Gender 1 1.. Member_id 1.. 1 Fitness_Class_day * Fitness_Class_id * Fitness_Class_duration Member_email Fitness_Class_fee Member_address Payment_Status Fitness_Class_start-time Member_DoB Fitness_Class_Location_ID 1..* Associated with 1 Fitness_Interest Fitness_Interest_ID Fitness_Interest_Name Fitness_Level_ID