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!

Due Date: Submit your Enhanced Entity Relationship (EER) diagram as a PDF or a Word file or an image file to the Blackboard by 11:59 pm on Friday, February 3, 2023 Note: To draw your ER diagram, you...

The store hired you to design a database management system to assist in keeping track of its customers and rental inventory. Draw your EER diagram based on the following narrative about a computer...

Creating an Entity Relationship Diagram (ERD) Create an ER Diagram for the following business rules: Sales rep data include a sales rep number (unique identifier), name, and phone number. A sales rep...

Needing help with this project anything is appreciated. The model with the relationships is throwing me through a loop. Thanks Database Project Part 1: 150 points Due: See Canvas for Due Dates...

I need help creating a Formal Proposal using the following directions and current business plan. Thank you to anyone who assists in this assignment Directions: Organize a Plan: Now that you've got...

Create a logical ERD for each of the problems on the following pages using the crowsfoot notation discussed in class. Be sure that each entity has the entity name at the top of the box, the primary...

Create an EER diagram using MySQL Workbench (Crow's Foot Notation) to support the described business scenario and its operations. After, translate the diagram into a DB schema consisting of tables...

SEE problem 4.25 which is attached in pdf format. I need detailed and correct answer 148 PART TWO / Databases Purchasing agent Order goods Merchandise inventory Vendor Receive goods Receiving clerk...

Good afternoon, I have a question about my CIS database management class assignment. Below are the questions. And under the quest is how it should be formatted. Thank you so much! Create a conceptual...

Assume that an application-layer protocol is written to use the services of UDP. Can the application-layer protocol use the services of TCP without change?

Which food has more Calories: 3 oz of salmon, which contains 17 g of protein and 5 g of fat, or 3 oz of chicken, which contains 20 g of protein and 3 g of fat? (Compare the Calories after taking...

3. What change would you make to the BinToAsc procedure in Section 7.2.3 in order to display the binary bits in reverse order?

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...