Question: 1. What problem do you see with the following entity? Customers 2. Please normalize the following table [example from Microsoft Office 2010: Advanced (Shelly Cashman
1. What problem do you see with the following entity?
Customers

2. Please normalize the following table [example from Microsoft Office 2010: Advanced (Shelly Cashman Series)]. If you properly normalize, you will have two tables as answers.

Customer Number Customer First Name Customer Last Name Customer Phone Number Customer Email Client Num Client Name Street City State Current Due Last Name First Name Commission Recruiter Number 21 24 AC34 BH72 BL12 EA45 FD89 FH22 Alys Clinic Berls Hospital Benton Labs ENT Assoc. Ferb Dentistry Family Health 134 Central 415 Main 12 Mountain 867 Ridge 34 Crestview 123 Second Berridge Berls Denton Fort Stewart Berridge Tarleton 8 8 8 8 8 8 CO CO CO CO CO CO $17,500.00 $0.00 $38,225.00 $12,750.00 $12,500.00 $0.00 24 27 21 24 Kerry Reeves Reeves Fernandez Kerry Reeves Alyssa Camden Camden Jaime Alyssa Camden $17,600.00 $19,900.00 $19,900.00 $9,450.00 $17,600.00 $19,900.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
