Please answer asap!!
Draw an EER diagram for each of the following scenarios using standard Chen's notation that we have discussed in class and that is described in the course textbook. You may complete the scenarios for option A and B using drawing software such as draw.io or Visio which both have templates for EER diagramming. You may, instead, complete them as hand-drawn diagrams. A hand drawn diagram must be complete and legible. It may be scanned and uploaded or it can be an easily legible photograph from a cell phone camera. If we cannot read it, we will not be able to grade it. Scenario A - Fitness Club Extension In your previous practice work, you developed an ER diagram for the IM Building at Penn State. Campus Rec loves the idea and now determines they want to expand the database to be university-wide (University Park and all the other campuses). One of the aims for the project will be to record information about members that participate in group fitness sessions and also personal training sessions. You can do this problem by building on your diagram from the last homework assignment. We have added a few additional business requirements here. The entire problem will be restated here though in the new context. A fitness center is identified by a Center D, 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?) Sessions can be either personal or group training session. Trainers lead sessions. Each session (personal or group) requires exactly one trainer. The center stores the certification number, name, and phone number for each trainer. Sessions are identified by SessionID. When a trainer starts working for the center, it is possible they won't lead any sessions while they are completing their certifications. 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. 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.)
