Question
Using the database you created for Assignment 2, Add an Employee table containing the records shown in cyclone 2020EmployeeTable.xls. Change the salesperson column in the
- Using the database you created for Assignment 2,
- Add an Employee table containing the records shown in cyclone 2020EmployeeTable.xls.
- Change the salesperson column in the Sales table to EmployeeNo column and change values in each cell. For example, Drezen will now become E203, etc.
New Employee Table
| Employee | |||||
| employeeNo | employeename | employeestreet | employeecity | employeestate | employeecommission |
| E200 | Wilson | 102 Main | Ames | IA | 0.05 |
| E201 | Gammon | 105 University | Gilbert | IA | 0.06 |
| E202 | SuperCy | 408 Golden Lane | Ames | IA | 0.04 |
| E203 | Drezen | 890 Cardinal | Boone | IA | 0.05 |
| E204 | Martinez | 807 Spirit Road | Gilbert | IA | 0.06 |
| E205 | Burns | 202 Mascot Alley | Huxley | IA | 0.04 |
| E206 | Jackson | 102 Doran Road | Beaver | IA | 0.06 |
Revised Sales Table
| Sales | ||||
| invoiceno | Invdate | employeeno | custno | amount |
| 101 | 1/3/2020 | E203 | 1000 | 1549.9 |
| 102 | 1/5/2020 | E205 | 1003 | 299.85 |
| 103 | 1/5/2020 | E206 | 1002 | 1449.8 |
| 104 | 1/15/2020 | E203 | 1000 | 799.9 |
| 105 | 1/15/2020 | E204 | 1005 | 849.95 |
| 106 | 1/16/2020 | E204 | 1007 | 99.95 |
| 107 | 1/29/2020 | E205 | 1002 | 2209.7 |
| 108 | 2/3/2020 | E204 | 1000 | 779.9 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started