Employee ID Employee Last Name Employee First Name Street Address City State ZIP Code Department Manager ID Position Salary

$1005$ Doe Janet $312$ Maple Drive Anytown FL $32829$ Board of Directors $1000$ President $$100,000$

$1010$ Eyre Jane $1200$ First Street Anytown FL $32829$ Administration $1005$ Vice President $$95,000$

$1011$ Bronte Charlotte $4989$ Fleur de Lane Sometown FL $32829$ Administration $1005$ Vice President $$75,000$

$2060$ Poe Edgar $12$ Arcadia Avenue Anytown FL $32829$ Information Technology $1015$ Programmer II $$70,000$

$2090$ Dickens Charles $687$ Gulf View Street Sometown FL $32830$ Information Technology $1015$ Programmer I $$45,000$

$2100$ Doyle AC $1209$ Pine Tree Lane Sometown FL $32831$ Information Technology $1015$ Programmer I $$60,000$

$3230$ Uberville Tess $5435$ Main Street Anytown FL $32831$ Sales $1021$ Sales Representative $$50,000$

$3330$ Dumas Alex $3$ Post Drive Sometown FL $32831$ Sales $1021$ Sales Representative $$35,000$

$1.$ Create the Tables in MySQL

The final step is to create the new tables in MySQL so that the result is in $3$NF$.$ You will provide the SQL statements used to create the tables and screen prints of the final results.

Remember, you will have to create primary key$($s$)$ for the additional tables you add!

Paste the SQL statements and screen prints of the results into the Word document.