Entity Relationship Diagram.3
.pdf
School
Grand Canyon University**We aren't endorsed by this school
Course
BIT 310
Subject
Information Systems
Date
Jan 13, 2025
Pages
1
Uploaded by ChiefStar16807
Juice Bar SalesPKSale_IDFKCustomer_IDDateTotal AmountNameEmployee_Role (Trainer, Manager, Etc.)Hire DateSalaryEmployeeEmployee_IDPKClassPKClass_IDFKNameDescriptionSchedule_IDClass_IDTrainer_IDTimeDay of the WeekDurationClass ScheduleSchedule_IDPKFKFKTrainer SchedulePKTrainer_Schedule_IDFKSchedule_IDEmployee_IDTimeAvailable SlotsCustomer_IDClass_IDEnrollmentEnrollmentEnrollment_IDPKFKFKFKNameAddressEmailDate JoinedMembership TypePayment InfoVisit FrequencyCustomerCustomer_IDPKFKSalesPKSale_IDFKCustomer_IDMembership_IDDateTotal AmountFKCustomer_IDType (Annual, Monthly, etc.)Start DateEnd DatePrice PaidMembershipMembership_IDPKFKRenewalPKRenewal_IDFKCustomer_IDMembership_IDRenewal_DateRenewal_FeeFKOne-to-ManyOne-to-ManyOne-to-ManyOne-to-ManyOne-to-ManyOne-to-ManyOne-to-OneEntity Relationship DiagramTiffany TaylorMany-to-ManyOne-to-ManyMany-to-ManyOne-to-Many
