create table EmployeeInfo ( employee_id int(3), name varchar(25), email varchar(20), area_code int(3), phone char(8), office varchar(20), salary int(6) ); create table EmployeeProjects ( employee_id int(3), project_id int(3) ); create table Projects ( id int(3), name varchar(25), cost int(7), office_id int(5) ); create table Offices ( id int(5), city varchar(15), state char(2), street_address varchar(25), phone_number char(12) ); insert into EmployeeInfo values(783, 'Hercules', 'herc@buildit.com', 423, '789-1393', 'Mt. Olympus', 25000); insert into EmployeeInfo values(500, 'Zeus', 'zeus@buildit.com', 865, '386-3868', 'Mt. Olympus', 100000); insert into EmployeeInfo values(43, 'Mickey Mouse', 'mickey@disney.com', 650, '486-3153', 'Disneyworld', 50000); insert into EmployeeInfo values(381, 'Donald Duck', 'duck@disney.com', 650, '486-4862', 'Disneyworld', 200000); insert into EmployeeProjects values(783, 123); insert into EmployeeProjects values(500, 123); insert into EmployeeProjects values(381, 123); insert into EmployeeProjects values(783, 323); insert into EmployeeProjects values(43, 123); insert into EmployeeProjects values(500, 583); insert into EmployeeProjects values(783, 583); insert into Offices values(37996, 'Knoxville', 'TN', '1119 Volunteer Blvd', '865-974-1000'); insert into Offices values(58683, 'Athens', 'GR', '500 Parthenon Way', '386-586-8386'); insert into Projects values(123, 'Claxton Renovation', 105000, 37996); insert into Projects values(583, 'Parthenon Renovation', 2005000, 58683); insert into Projects values(323, 'Magic Kingdom', 3105000, 37996);