Question: I need help creating a entity relationship (ER) diagram for this given data Customer ID Customer State Customer Zip Membership Type Membership Start Date Membership

I need help creating a entity relationship (ER) diagram for this given data

I need help creating a entity relationship (ER)

Customer ID Customer State Customer Zip Membership Type Membership Start Date Membership Monthly Fee Trainer ID Trainer Hourly Rate Training Event ID Training Completed Training Hourly Price Additional Equipment Price Customer Name Customer Address Customer City Customer Phone Membership Type Trainer Name Training Date 12577 Tasmin Whitehouse 777 Brockton Avenue Sparks NV 89431 (530) 772-6003 100 6/16/19 Standard $72.00 208 Shanelle Bauer $75.00 161 1/29/20 TRUE $125.00 $25.00 Training Hours Training Notes Created specialized cardio/weight 1 routine Performed initial evaluation and 2 created routine Performed initial evaluation and 1 created routine 2 Supervised routine 18923 Ema Dolan 30 Memorial Drive Carson City 89701 (805) 788-4122 200 10/25/15 Corporate $65.00 218 Kirstie Firth $40.00 2/2/20 TRUE $100.00 $0.00 10058 Kerri Neale 10058 Kerri Neale 250 Hartford Avenue 250 Hartford Avenue Reno Reno 89521 89521 (775) 266-8551 (775) 266-8551 100 100 7/28/18 7/28/18 Standard Standard $72.00 $72.00 312 Olivier Petersen 312 Olivier Petersen $25.00 $25.00 163 164 2/3/20 2/5/20 TRUE TRUE $85.00 $65.00 $0.00 $0.00 10058 Kerri Neale 250 Hartford Avenue Reno 89521 (775) 266-8551 100 7/28/18 Standard $72.00 227 Avleen Meadows $35.00 2/9/20 TRUE $95.00 $35.00 0.5 Modified routine to include pilates Did posture evaluation and 3 created exercise structure 19800 Jose Haines 700 Oak Street Reno 89511 (775) 544-5688 100 1/23/19 Standard $72.00 312 Olivier Petersen $25.00 166 2/10/20 TRUE $75.00 $20.00 167 168 1 Modified routine to include pilates 1.5 Supervised routine 2.5 $35.00 $25.00 12577 Tasmin Whitehouse 12577 Tasmin Whitehouse 21500 Dianne Griffiths 12577 Tasmin Whitehouse 21500 Dianne Griffiths 18923 Ema Dolan 169 777 Brockton Avenue 777 Brockton Avenue 591 Memorial Dr 777 Brockton Avenue 591 Memorial Dr 30 Memorial Drive Sparks Sparks Reno Sparks Reno Carson City 89431 89431 89503 89431 89503 89701 100 100 150 100 (530) 772-6003 (530) 772-6003 (702) 348-9751 (530) 772-6003 (702) 348-9751 (805) 788-4122 6/16/19 6/16/19 11/28/18 6/16/19 11/28/18 10/25/15 Standard Standard Family Standard Family Corporate $72.00 $72.00 $125.00 $72.00 $125.00 $65.00 218 Kirstie Firth 312 Olivier Petersen 312 Olivier Petersen 263 Ceri Salinas 312 Olivier Petersen 218 Kirstie Firth $40.00 $25.00 $25.00 $25.00 $25.00 $40.00 2/18/20 2/24/20 3/2/20 3/6/20 3/10/20 3/11/20 TRUE TRUE FALSE FALSE FALSE FALSE $70.00 $50.00 $70.00 $50.00 $50.00 $50.00 NV NV 170 171 150 200 172 Customer ID Customer State Customer Zip Membership Type Membership Start Date Membership Monthly Fee Trainer ID Trainer Hourly Rate Training Event ID Training Completed Training Hourly Price Additional Equipment Price Customer Name Customer Address Customer City Customer Phone Membership Type Trainer Name Training Date 12577 Tasmin Whitehouse 777 Brockton Avenue Sparks NV 89431 (530) 772-6003 100 6/16/19 Standard $72.00 208 Shanelle Bauer $75.00 161 1/29/20 TRUE $125.00 $25.00 Training Hours Training Notes Created specialized cardio/weight 1 routine Performed initial evaluation and 2 created routine Performed initial evaluation and 1 created routine 2 Supervised routine 18923 Ema Dolan 30 Memorial Drive Carson City 89701 (805) 788-4122 200 10/25/15 Corporate $65.00 218 Kirstie Firth $40.00 2/2/20 TRUE $100.00 $0.00 10058 Kerri Neale 10058 Kerri Neale 250 Hartford Avenue 250 Hartford Avenue Reno Reno 89521 89521 (775) 266-8551 (775) 266-8551 100 100 7/28/18 7/28/18 Standard Standard $72.00 $72.00 312 Olivier Petersen 312 Olivier Petersen $25.00 $25.00 163 164 2/3/20 2/5/20 TRUE TRUE $85.00 $65.00 $0.00 $0.00 10058 Kerri Neale 250 Hartford Avenue Reno 89521 (775) 266-8551 100 7/28/18 Standard $72.00 227 Avleen Meadows $35.00 2/9/20 TRUE $95.00 $35.00 0.5 Modified routine to include pilates Did posture evaluation and 3 created exercise structure 19800 Jose Haines 700 Oak Street Reno 89511 (775) 544-5688 100 1/23/19 Standard $72.00 312 Olivier Petersen $25.00 166 2/10/20 TRUE $75.00 $20.00 167 168 1 Modified routine to include pilates 1.5 Supervised routine 2.5 $35.00 $25.00 12577 Tasmin Whitehouse 12577 Tasmin Whitehouse 21500 Dianne Griffiths 12577 Tasmin Whitehouse 21500 Dianne Griffiths 18923 Ema Dolan 169 777 Brockton Avenue 777 Brockton Avenue 591 Memorial Dr 777 Brockton Avenue 591 Memorial Dr 30 Memorial Drive Sparks Sparks Reno Sparks Reno Carson City 89431 89431 89503 89431 89503 89701 100 100 150 100 (530) 772-6003 (530) 772-6003 (702) 348-9751 (530) 772-6003 (702) 348-9751 (805) 788-4122 6/16/19 6/16/19 11/28/18 6/16/19 11/28/18 10/25/15 Standard Standard Family Standard Family Corporate $72.00 $72.00 $125.00 $72.00 $125.00 $65.00 218 Kirstie Firth 312 Olivier Petersen 312 Olivier Petersen 263 Ceri Salinas 312 Olivier Petersen 218 Kirstie Firth $40.00 $25.00 $25.00 $25.00 $25.00 $40.00 2/18/20 2/24/20 3/2/20 3/6/20 3/10/20 3/11/20 TRUE TRUE FALSE FALSE FALSE FALSE $70.00 $50.00 $70.00 $50.00 $50.00 $50.00 NV NV 170 171 150 200 172

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!