Question: based on the narrative draw the following ERD's , make sure you add the primary keys, foreign keys verbs that represent the relationship and Mark

based on the narrative draw the following ERD's , make sure you add the primary keys, foreign keys verbs that represent the relationship and Mark cardinality both lower and upper bounds for each diagram apply all four ERD rules based on the narrative draw the following ERD's , make sure you

OUFitRec+ has asked for your help to better understand the relationship between their customers, fitness sessions, and trainers. After speaking with FitRect, you've learned the following: customers may attend many fitness sessions and fitness sessions may have many customers. Each fitness session has one trainer and a trainer may train many sessions. For each. customer you should collect: name, address, all relevant email addresses, and type. For each fitness session, you need to track the session name, description of the session, and maximum size of the class. For each trainer you want to collect the name of the trainer, age, a phone number, and email address. You've also been asked to collect the day each customer attends a fitness session. ( 30 Points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!