A fitness center is identified by a CenterID, a name (e.g. White Building), and a campus location. A fitness room belongs to a center.
Rooms can be booked for sessions (either group or personal training). Rooms have a RoomID, maximum capacity, and equipment
code(used by staff to identify special equipment in the room). Within each center, the room number will be unique. However,
recognize that Room 116, for example, could exist in more than one center (What entity type is this?)
Members can sign up for personal or group sessions in different centers (but it is possible they won't sign up for any sessions). If a
member signs up for a personal session, they receive a special credit in a personal training table to earn free personal training sessions.
Each member has a member ID number and an email address stored for them.
Each session (personal or group) requires exactly one trainer. The center stores the certification number and email address for each
trainer. Sessions are identified by SessionID. When a trainer starts working for the center they may not initially lead their own
sessions.
For a session, SessionID, the start time and minimum capacity will be recorded. For group sessions, the type should be recorded (i.e.,
aerobics, weight training, yoga, etc.).
