Please normalize the following table [example from “MicrosoftOffice 2010: Advanced (Shelly Cashman Series)]. If youread the textbook carefully, you will be able to normalize thistable below. If you properly normalize, you will havetwo tables as answers.
Client Num | Client Name | Street | City | State | Current Due | Recruiter Number | Last Name | First Name | Commission |
AC34 | Alys Clinic | 134 Central | Berridge | CO | $17,500.00 | 21 | Kerry | Alyssa | $17,600.00 |
BH72 | Berls Hospital | 415 Main | Berls | CO | $0.00 | 24 | Reeves | Camden | $19,900.00 |
BL12 | Benton Labs | 12 Mountain | Denton | CO | $38,225.00 | 24 | Reeves | Camden | $19,900.00 |
EA45 | ENT Assoc. | 867 Ridge | Fort Stewart | CO | $12,750.00 | 27 | Fernandez | Jaime | $9,450.00 |
FD89 | Ferb Dentistry | 34 Crestview | Berridge | CO | $12,500.00 | 21 | Kerry | Alyssa | $17,600.00 |
FH22 | Family Health | 123 Second | Tarleton | CO | $0.00 | 24 | Reeves | Camden | $19,900.00 |
