Ab Fab Lab Online Booking System Overview

Ab Fab Lab Online Booking System

• The company, Ab Fab Lab (AFL), is a health and fitness centre
• They are developing an online booking system for fitness classes
• The system allows members to register, retrieve class info, and view previous registrations
• Members can view class details (name, description, level, instructor, availability, registration period)
• Members can book classes online up to 1 hour before the class
• Administrative staff can also take bookings by phone or at reception
• Staff can check attendance, cancel classes (for <5 attendees) for members
• Instructors provide attendance records to administrators
• AFL has 25 centres in the UK and Ireland
• The system must be implemented at all locations within 12 months
• Budget for the project is £200,000

System Functionality

• Members book classes online or by phone/reception
• Bookings can be made up to 1 hour before the class
• System tracks attendance for each class
• Admin staff manage class creation, cancellation, and attendance checking
• Instructors submit attendance records

Database Design (partial)

• Members: Member ID, First Name, Last Name, Gender, Email, Address, Date of Birth
• Reservations: Reservation ID, Member ID, Class ID, Payment Status
• Classes: Class ID, Name, Day, Duration, Time, Fee, Location, Level, Instructor
• Fitness Interests: Interest ID, Name
• Instructors: Instructor ID, Name
• Relationships between tables such as Reservations linked to Members and Classes, classes with Fitness Interests and Instructors.