Question: This is the code, i will give you a question, you answer it accordingly. MembershipStatuses ( StatusID , StatusName ) FitnessGoals ( FitnessGoalID , GoalName
This is the code, i will give you a question, you answer it accordingly. MembershipStatusesStatusID StatusName
FitnessGoalsFitnessGoalID GoalName
MembershipTypesMembershipTypeID TypeName
MembersMemberIDFirstName,LastName,Gender, Age,DOB Phone, Address, Email,HtWtFitnessGoalID MembershipTypeID MembershipStatusID,
MembershipRenewalsRenewalID MemberID, RenewalDate, RenewalAmount, PaymentMethod
AttendanceAttendanceID MemberID, Date, CheckInTime, CheckOutTime
StaffProfilesStaffID FirstName, LastName, Email, Phone, Role, Certification
WorkSchedulesScheduleID StaffID, StartTime, EndTime
CommunicationLogsLogID SenderID, ReceiverID, Message, Timestamp
RoomsRoomIDRoomName
GroupFitnessClassesClassID ClassName, Description, Duration, Enrolled, Capacity, RoomID, TrainerID, StartTime, EndTime
PersonalTrainingSessionID StartTime, EndTime, RoomID, MemberID, TrainerID
EventsEventId StartTime, EndTime, RoomID, Eventorganisername
MemberBookingsBookingID MemberID, ClassID, BookingTime
ClassRemindersReminderID MemberID, ClassID, ReminderTime
EquipmentManagementEquipmentID EquipmentName, EquipmentType, PurchaseDate, PurchaseCost, MaintenanceSchedule, LastMaintenanceDate, SafetyCompliance
UsageLogsLogID EquipmentID, LogDate, LogTime, MemberID, DurationMinutes
RepairHistoryRepairID EquipmentID, RepairDate, RepairDescription, RepairCost, RepairNotes
TransactionsTransactionID MemberID, TransactionDate, Amount, Description, PaymentMethod
RetailItemsItemIDItemName,Price
RecurringPaymentsPaymentIDMemberID,Amount,PaymentDate,PaymentGateway,PaymentStatus
AccessControlEntriesEntryIDEntryType,EntryLocation,AccessGranted,AccessTime,StaffID
SecurityIncidentsIncidentIDIncidentType,Description,DateOccurred,TimeOccurred,ReportedBy
WorkoutPlanPlanID PlanName, DurationInWeeks, Description, CreatedDate, LastModifiedDate, CreatedBy
ProgressTrackingTrackingID MemberID, PlanID, Date, Weight, BodyFatPercentage, MuscleMass, WorkoutCompleted
FitnessChallengesChallengeID ChallengeName, Description, StartDate, EndDate, Prize
NotificationsNotificationID NotificationType, NotificationMessage
NotificationRecipientsNotificationRecipientID NotificationID, RecipientID, SentDateTime
SurveyResponsessurveyid memberid surveydate, satisfactionrating, feedbackcomments, servicerating, staffinteractionrating, facilitycleanlinessrating, improvementsuggestions
Question is: create the ER model using the schema provided, the primary key is underlined.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
