1. Using the database you created for Assignment 2,

1. Add an Employee table containing the records shown in cyclone 2020EmployeeTable.xls.
2. 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