This assessment is an individual assignment.
You are required to design (use-case diagram and Entity Relationship Model (ERM) a database solution for a sports club record system.
The sports club scenario
You have been employed as a database designer to design and implement a new membership record system that is capable of storing information about members, sports club staff and sports activity bookings.
Each sports club member needs to have a unique member reference number, as well as storing first name, surname, address, telephone number, email address and date of birth and any medical conditions.
Each sports club staff member has a unique staff number, first name, surname, role and a contact number.
Each member can book up to five sports classes per week. Each sports class has a unique class code, title, day and time of delivery.
The system should allow an instructor (sports club staff member) to search for the activities running on a particular day. Each member can only sign up for one sports during any two-hour time slot (9am-5pm) and no activities that overlap can be booked concurrently.
Sports club staff members and staff can check and update their personal details, sports centre staff can record attendance for a class they are teaching, and each member can view their daily or weekly activity bookings.