#2
In this entity, people become members of a fitness facility by signing a contract of their choice. They are then granted access to fitness classes that they can sign up using their ID numbers. They choose from a series of classes based on the availability and desired type of class the member is interested in. Within the class, they have instructors that are leading the fitness activity and these instructors also schedule classes based on their availability. Those who have signup for a fitness class, get to participate in the activity.
#3
Data Modeling short paragraph:
I chose the domain of fitness because it is something that I am passionate about. Ever since I was in High School, fitness has been a huge aspect of my health. Therefore, I was interested in learning the hierarchy connection between members, classes and instructors. In this domain, the information that needs to be managed is what happens when a member joins and is interested in joining classes that are offered by the facilities. The relationships are as follows:
- Each member has an ID – Primary key for members entity
- Members are able to sign up with their ID which becomes a foreign key in member sign up entity
- Each member sign up can sign up for the same instructor or multiple instructor as often as they please but only one scheduled class at a time (foreign Key)– can’t sign up for two classes that occur at the same time.
- Each type of class example, Pilates, has many classes
#5
Breakdown:
Members of this gym are allowed to signup for classes once they become members. As they sign up for a class, they have uniquely identified a class they want to participate in. Their signup is distinguished by their ID number, granting them space in that class. In other words, a member can only signup for one class within the specific time stamp – no double booking for classes that occur simultaneously. For example, member #49 is signed up for scheduled class #312, Pilates (45 mins) with Casey on Monday July 6th, 2024 from 6-6:50 am”. The class schedule is the overall schedule that the fitness center has curved out for all members to sign up. It includes different types of classes, instructors, and date or time slot the classes would occur. A class can be scheduled numerous times in a day to allow chances for members to have options that align with their daily commitments. For example, Pilates is scheduled on Mondays, Wednesdays and Fridays at 6am and 5pm. Within each class, there is a subcategory that specifies the type of workouts members will be able to participate in. For example, “Wall Pilates” (45mins) is a subcategory under “Pilates” therefore, it is a type of “Pilates”. Each type of class such as Pilates, spin or Zumba has many classes with different instructors. Each instructor is able to have multiple scheduled classes.