1. Database Design A SmartFit is a fitness center, and they need to create a Fitness Center Management (FCM) system to keep track of their transactions. Assume that you are hired by an organization to develop a database to help them manage their daily transactions. To facilitate this, you need to design the database with several tables, some of them are; Members, Exercise Schedules and Trainers. You are required to read the requirements described in the scenario given below and answer the questions. User view 1 requirement/business rule - The FCM system can secure and monitor the activities and advise exercise schedules for the fitness center members - Members can book one or more exercise schedules, however there can be members with no booking schedules. - In each schedule there can be up to 10 members registered. Some schedules are new, and those schedules have zero members registered. User view 2 requirement/business rule - Each Trainer has a Unique ID, name, a contact number. - Trainers are assigned to schedules and each trainer can be assigned to many different schedules - Every Trainer must register for at least one exercise schedule. User view 3 requirement/business rule - For each MEMBER we keep track of the unique MemID, Name, Address, Payment, and the Date Of the membership - For each exercise schedule, it is important to record name of the schedule, day, and the time of the week it is conducting, and the TraineriD who will conduct the session. User view 4 requirement / business rule - On exercise schedule can be conducted in different registered sessions - System will store detalls of the members registered for exercise sessions such as; MemID, email_address and the schedule_ID, in order to email them the details of the sessions they registered. - Every registered exercise session needs an allocated room, and these rooms are identified by a unique number. User view 5 requirement/business rule - There are a number of exercise schedules running on different days of the week and each schedule is conducted by only one Trainer. Prepared by: Dr. Deppani Guruge Moderated by: Dr. Xiaoying Kong Aug 2022 1. Database Design A SmartFit is a fitness center, and they need to create a Fitness Center Management (FCM) system to keep track of their transactions. Assume that you are hired by an organization to develop a database to help them manage their daily transactions. To facilitate this, you need to design the database with several tables, some of them are; Members, Exercise Schedules and Trainers. You are required to read the requirements described in the scenario given below and answer the questions. User view 1 requirement/business rule - The FCM system can secure and monitor the activities and advise exercise schedules for the fitness center members - Members can book one or more exercise schedules, however there can be members with no booking schedules. - In each schedule there can be up to 10 members registered. Some schedules are new, and those schedules have zero members registered. User view 2 requirement/business rule - Each Trainer has a Unique ID, name, a contact number. - Trainers are assigned to schedules and each trainer can be assigned to many different schedules - Every Trainer must register for at least one exercise schedule. User view 3 requirement/business rule - For each MEMBER we keep track of the unique MemID, Name, Address, Payment, and the Date Of the membership - For each exercise schedule, it is important to record name of the schedule, day, and the time of the week it is conducting, and the TraineriD who will conduct the session. User view 4 requirement / business rule - On exercise schedule can be conducted in different registered sessions - System will store detalls of the members registered for exercise sessions such as; MemID, email_address and the schedule_ID, in order to email them the details of the sessions they registered. - Every registered exercise session needs an allocated room, and these rooms are identified by a unique number. User view 5 requirement/business rule - There are a number of exercise schedules running on different days of the week and each schedule is conducted by only one Trainer. Prepared by: Dr. Deppani Guruge Moderated by: Dr. Xiaoying Kong Aug 2022
