Question

1 Approved Answer

Posted on Jul 18, 2024

1.What is relationships do Steven Kings dependents have with them? 2.How many dependents are in Canada? 3. How many dependents are in Seattle? 4.How many

1.What is relationships do Steven Kings dependents have with them?

2.How many dependents are in Canada?

3. How many dependents are in Seattle?

4.How many employees do not have children?

5. Which department has the highest maximum salary?

6. Which department has the lowest maximum salary?

7. Which department has the highest minimum salary?

8. Which department has the lowest minimum salary?

9. Which department(s) have the maximum number of dependents?

10. Which department(s) have the minimum number of dependents?

11.What is the street address of dependent, Nick Higgins?

image text in transcribed

CREATE TABLE regions ( region_id INT (11) AUTO INCREMENT PRIMARY KEY, region_name VARCHAR (25) DEFAULT NULL }; CREATE TABLE countries ( country_id CHAR (2) PRIMARY KEY, country_nane VARCHAR (40) DEFAULT NULL, region_id INT (11) NOT NULL, FOREIGN KEY (region_id) REFERENCES regions (region_id) ON DELETE CASCADE ON UPDATE CASCADE }; CREATE TABLE locations ( location_id INT (11) AUTO_INCREMENT PRIMARY KEY, street address VARCHAR (48) DEFAULT NULL, postal code VARCHAR (12) DEFAULT NULL, city VARCHAR (38) NOT NU DEFAULT NULL, state province VARCHAR (25) DEFAULT NULL, NULL, country_id CHAR (2) NOT NULL, FOREIGN KEY (Country_id) REFERENCES countries (country_id) ON DELETE CASCADE ON UPDATE CASCADE CREATE TABLE jobs ( job_id INT (11) AUTO_INCREMENT PRIMARY KEY, jab title VARCHAR (35) NOT NULL, min_salary DECIMAL (8, 21 DEFAULT NULL, max_salary DECIMAL (8, 21 DEFAULT NULL }; CREATE TABLE departments [ department_id INT (11) AUTO_INCREMENT PRIMARY KEY, department_nane VARCHAR (30) NOT NULL, location_id INT (11) DEFAULT NULL, FOREIGN KEY (location_id) REFERENCES locations (location_id) ON DELETE CASCADE ON UPDATE CASCADE }; CREATE TABLE enployees ( employee_id INT (11) AUTO INCREMENT PRIMARY KEY, first name VARCHAR (20) DEFAULT NULL, last name VARCHAR (25) NOT NULL, email VARCHAR (100) NOT NULL, phone number VARCHAR (20) DEFAULT NULL, hire date DATE NOT NULL, job_id INT (11) NOT NULL, salary DECIMAL (8, 2) NOT NULL, manager_id INT (11) DEFAULT NULL, department_id INT (11) DEFAULT NULL, FOREIGN KEY (job_id) REFERENCES jobs (job_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (department_id) REFERENCES departments (department_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (nanager_id) REFERENCES employees (employee_id) CREATE TABLE dependents ( dependent_id INT (11) AUTO INCREMENT PRIMARY KEY, first name VARCHAR (50) NOT NULL, last name VARCHAR (50) NOT NULL, relationship VARCHAR (25) NOT NULL, employee_id INT (11) NOT NULL, FOREIGN KEY (employer_id) REFERENCES employees (employee_id) ON DELETE CASCADE ON UPDATE CASCADE }; /4Data for the table regions */ INSERT INTO regions (region_id, region_name) VALUES (1, 'Europe'); INSERT INTO regions (region_id, region_name) VALUES (2, 'Anericas'); INSERT INTO regions (region_id, region_name) VALUES (3, 'Asia'); INSERT INTO regions (region_id, region_name) VALUES (4, 'Middle East and Africa'); G /4Data for the table countries */ INSERT INTO countries (country_id, country_name, region_id) VALUES ('AR', 'Argentina', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('AU', 'Australia',3); INSERT INTO countries (country_id, country_name, region_id) VALUES ("BE', 'Belgium',1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('BR', 'Brazil',21; INSERT INTO countries (country_id, country_name, region_id) VALUES ('CA', 'Canada',21; INSERT INTO countries (country_id, country_name, region_id) VALUES ('CH', 'Switzerland", 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ("CN", "China",3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('DE', 'Germany',1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('DK', 'Denmark',1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('EG', 'Egypt', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ("FR', 'France',1); INSERT INTO countries (country_id, country_name, regian_id) VALUES ('HK', 'HongKong',3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('IL', 'Israel',41; INSERT INTO countries (country_id, country_name, region_id) VALUES (IN', 'India',3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('IT', 'Italy 1 INSERT INTO countries (country_id, country_name, region_id) VALUES ('JP, Japan,3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('KW', 'Kuwait,41; INSERT INTO countries (country_id, country_name, region_id) VALUES ('MX', 'Mexico',21; INSERT INTO countries (country_id, country_name, region_id) VALUES ('NG', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ('NL', INSERT INTO countries (country_id, country_name, region_id) VALUES ('SG', 'Singapore',3); INSERT INTO countries (country_id, country_name, region_id) VALUES (UK', 'United Kingdom',1); "NU 10: INSERT INTO countries (country_id, country_name, region_id) VALUES ('US', 'United States of America', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('ZM', 'Zambia',41; INSERT INTO countries (country_id, country_name, region_id) VALUES ('ZW', 'Zimbabwe', 4); /+Data for the table locations */ INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (1408, 2014 Jabberwocky Rd', '26192', 'Southlake', 'Texas', 'US'); INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (1508, 2011 Interiors Blvd', '99236', 'South San Francisco', "California', 'US'); INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (1708, 2004 Charade Rd', '98199', 'Seattle', 'Washington', 'US'1; INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (1808, 147 Spadina Ave', 'M5V 2L7', 'Toronto', "Ontario', 'CA'); province, country_id) VALUES (2400, 8204 Arthur St',NULL, 'London',NULL, 'K'); INSERT INTO locations (location_id,street_address, postal code, city, state INSERT INTO locations (location_id, street_address, postal code, city, state province, country_id) VALUES (2508, "Magdalen Centre, The Oxford Science Park', '0x9 9ZB', 'Oxford', "Oxford", "UK'); INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (2708, "Schwanthalerstr. 7831', '88925', 'Nunich', 'Bavaria', 'DE'); /4Data for the table jobs */ INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (1, 'Public Accountant, 1200.00,9000.00); INSERT INTO jobs(job_id, job_title, nin_salary, nax_salary) VALUES (2, 'Accounting Manager,8200.00, 16000.00); INSERT INTO jobs(job_id,job_title,nin_salary, nax_salary) VALUES (3, 'Administration Assistant', 3000.00, 6080.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary! VALUES (4, 'President',20000.00,40000.00); INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (5, 'Administration Vice President',15800.00,30000.00); INSERT INTO jobs(job_id,job_title,nin_salary, nax_salary) VALUES (6, 'Accountant', 4200.00, 9000.00); INSERT INTO jobs(job_id, job_title, nin_salary, nax_salary) VALUES (7, 'Finance Manager',8280.00,16000.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary! VALUES (8, 'Human Resources Representative',4800.00,9008.08); INSERT INTO jobs (job_id,job_title, nin_salary, nax_salary) VALUES (9, 'Programmer', 4000.00, 10000.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary) VALUES (10, Marketing Manager,9008.00, 15000.00); INSERT INTO jobs(job_id, job_title, nin_salary, nax_salary) VALUES (11, Marketing Representative',4088.88,9800.00); INSERT INTO jobs(job_id,job_title,nin_salary, nax_salary! VALUES (12, 'Public Relations Representative",4580.00,18500.00); INSERT INTO jobs (job_id,job_title, nin_salary, nax_salary! VALUES (13, 'Purchasing Clerk',2500.00,5500.00); INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (14, 'Purchasing Manager',8080.80,15008.08); INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (15, 'Sales Manager',10080.00,20000.00); INSERT INTO jobs(job_id,job_title,nin_salary, nax_salary) VALUES (16, 'Sales Representative",6008.08,12800.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary) VALUES (17, 'Shipping Clerk',2500.00,5500.00); INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (18, 'Stock Clerk',2080.80,5000.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary) VALUES (19, 'Stock Manager',5508.00, 8500.00); /+Data for the table departments */ INSERT INTO departments (department_id, department_nane, location_id) VALUES (1, 'Administration',1700); INSERT INTO departments (department_id, department_name, location_id) VALUES (2, 'Marketing',1880); INSERT INTO departments (department_id, department_name, location_id) VALUES (3, 'Purchasing', 1700); INSERT INTO departments (department_id, department_name, location_id) VALUES (4, 'Human Resources',2488); INSERT INTO departments (department_id, department_name, location_id) VALUES (5, 'Shipping', 1500); INSERT INTO departments (department_id, department_name, location_id) VALUES (6, 'IT',1480); G INSERT INTO departments (department_id, department_nane, location_id) VALUES (7, 'Public Relations',2780); INSERT INTO departments (department_id, department_name, location_id) VALUES (8, 'Sales',2500); INSERT INTO departments (department_id, department_name, location_id) VALUES (9, 'Executive', 1780); INSERT INTO departments (department_id, department_name, location_id) VALUES (10, 'Finance', 1788); INSERT INTO departments (department_id, department_name, location_id) VALUES (11, 'Accounting', 1700); /*Data for the table employees */ INSERT INTO employees (employee_id, first name, last name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (100, 'Steven', 'King', steven.king@saltutorial.org', '515.123.4567', '1987-06-17,4,24880.80,NULL,9); INSERT INTO employees (employce_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (101, 'Neena', 'Kochhar', 'neena.kochhar@sqltutorial.org', '515. 123.4568', '1989-09-21,5,17800.00, 100, 9); INSERT INTO employees (employee_id, first name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (102, 'Lex', 'De Haan', 'lex.de haan@sqltutorial.org', '515.123.4569', '1993-81-13,5,17088.00,108,91; INSERT INTO employees (employnastane, email, phone number,hire_date, job_id, salary, manager_id, department_id) VALUES (103, 'Alexander', "Hunold', 'alexander.hunold@sqltutorial.org', '590.423.4567', '1998-01-03,9,9000.00,102,6); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id,department_id) VALUES (184, 'Bruce', 'Emst', 'bruce.ernst@sqltutorial.org', '590.423.4568', '1991-05-21',9,6088.00,183,61; INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (105, 'David', 'Austin', 'david. austin@sqltutorial.org', '598.423.4569', '1997-86-25,9,4800.00, 103,6); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (106, 'Valli', 'Pataballa', 'valli.pataballagsqltutorial.org', '598.423.4560', '1998-82-85,9,4800.80,103,6); INSERT INTO employees (employee_id, first_name, last_nane, email, phone number, hire_date, job_id, salary, manager_id,department_id) VALUES (187, 'Diana', 'Lorentz', 'diana. Lorentz@sqltutorial.org', '590.423.5567', '1999-02-07,9,4200.00,103,6); INSERT INTO employees (employee_id, first name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (188, 'Nancy', 'Greenberg', 'nancy.greenberggsqltutorial.org', '515.124.4569', '1994-88-17,7,12800.00, 101, 10); INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (109, 'Daniel', 'Faviet', 'daniel.faviet@sqltutorial.org', '515.124.4169', '1994-08-16,6,9000.00,108,10); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (110, 'John', 'Chen', 'john.chen@sqltutorial.org', '515.124.4269', '1997-09-28,6,8200.00,108,10); INSERT INTO employees (employee_id, first_name,last_nane, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (111, 'Ismael', 'Sciarra', 'ismael.sciarra@sqltutorial.org', '515.124.4369', '1997-09-30,6,7700.00, 108, 101; INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id,department_id) VALUES (112, 'Jose Manuel', 'Urman', "Jose nanuel.urmanesqltutorial.org', '515.124.4469', '1998-03-07,6,7808.00, 108, 10); INSERT INTO employees (employee_id, first_name, last_nane, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (113, 'Luis', 'Popp', 'luis.popp@sqltutorial.org', '515.124.4567', '1999-12-07,6,6900.00,108,10); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (114, 'Den', 'Raphaely', 'den. raphaely@sqltutorial.org', '515.127.4561', '1994-12-87,14,11080.00,100,3); INSERT INTO employees (employee_id, first_name, last_nane, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (115, 'Alexander', 'Khoo', 'alexander.khoo@sqltutorial.org', '515.127.4562', '1995-05-18,13,3100.00,114,31; INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department 10) VALUES (116, 'Shelli', 'Baida", 'shelli.baidaysqltutorial.org', '515.127.4563', '1997-12-24,13, 2908.00, 114,3); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (117, 'Sigal', 'Tobias', 'sigal. tobias@sqltutorial.org', '515.127.4564', '1997-87-24,13, 2800.00, 114,31; INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (118, 'Guy', 'Hinuro', "guy.hinuro@sqltutorial.org', '515.127.4565', '1998-11-15,13, 2600.00, 114,3); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (119, 'Karen', 'Colmenares', 'karen.colmenares@sqltutorial.org', '515.127.4566', '1999-08 -10,13,2500.88,114,3); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_10) VALUES (120, 'Matthew', 'Weiss', 'natthew.weissgsqltutorial.org', '650.123.1234', '1996-07-18,19,8800.00, 100,5); INSERT INTO employees (employee_id, first_name, last_nane, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (121, 'Adam', 'Fripp', "adan. fripp@sqltutorial.org',650.123.2234', '1997-84-18,19,8200.00,100,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (122, 'Payan', 'Kaufling','payam.kaufling@sqltutorial.org', '658.123.3234', '1995-05-01,19,7908.00,108,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (123, 'Shanta', 'vollman','shanta.vollman@sqltutorial.org', '658.123.4234', '1997 10 10,19,6508.00,188,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, manager_10, department_id) VALUES (126, 'Irene', 'Mikkilineni', 'irene.nikkilineni@sqltutorial.org', '650.124.1224, 1998-89-28, 18, 2700.00, 120,5); INSERT INTO employees (employee_id, first_name, Last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (145, 'John', 'Russell', 'john.russell@sqltutorial.org',NULL, "1996-10-01',15,14000.00,180,8); INSERT INTO employees (employee_id, first_name, Last_name, email, phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (146, 'Karen', 'Partners', 'karen.partners@sqltutorial.org',NULL, '1997-01-05,15, 13500. 80, 100,8); INSERT INTO employees (employee_id, first_name, last_nane, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (176, 'Jonathan', 'Taylor', 'jonathon. taylor@sqltutorial.org',NULL, '1998-83-24",16,8600.00,100,8); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (177, 'Jack', 'Livingston', 'jack.livingstongsqltutorial.org',NULL, '1998-84-23, 15, 8400.00, 100,8); INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES G '1999-85-24, 16,7000.00, 100,8); (178, 'Kimberely', 'Grant', 'kimberely.grant@sqltutorial.org',NULL, INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (179, 'Charles', 'Johnson', 'charles.johnsongsqltutorial.org',NULL, '2000-81-84", 16,6200.00, 100,8); INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (192, 'Sarah', 'Bell', 'sarah.bell@sqltutorial.org', 650.501.1876', '1996-82-84,17,4000.00,123,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (193, 'Britney', 'Everett', 'britney.everett@sqitutorial.org', '650.501.2876', '1997-83-83,17,3900.00, 123,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (200, 'Jennifer', 'Whalen', 'jennifer.whalengsqltutorial.org', '515. 123.4444', '1987-89-17,3,4400.00,101,1); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (201, 'Michael', 'Hartstein', 'michael.hartstein@sqltutorial.org', '515.123.5555', '1996-82-17, 10, 13008.08,188,2); INSERT INTO employees (employee_id, first_name, last_nane, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (202, 'Pat', 'Fay', 'pat. fay@sqltutorial.org", '603.123.6666', '1997-08-17,11,6008.00,201,21; INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (203, 'Susan', 'Mavris', 'susan.mavris@sqltutorial.org', '515.123.7777', '1994-86-87,8,6500.00, 101,4); INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (204, 'Hermann', 'Baer', 'hermann.baer@sqltutorial.org', '515.123.8888', '1994-86-87,12,10000.00,101,7); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (205, 'Shelley', 'Higgins', 'shelley.higgins@sqltutorial.org', '515.123.8880', '1994-86-87,2,12800.00, 101, 11); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (206, 'William', 'Gietz', 'willian.gietz@sqltutorial.org', '515.123.8181', '1994-06-07',1,8380.00,205,11); /*Data for the table dependents */ INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (1, 'Penelope', 'Gietz', 'Child',206); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (2, 'Nick', 'Higgins', 'Child",205); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (3, 'Ed', 'Whalen', 'Child", 2001; INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (4, 'Jennifer', 'King', 'Child", 100); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (5, Johnny', 'Kochhar', 'Child',101); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee id) VALUES (6, 'Bette', 'De Haan', 'Child", 102); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (7, 'Grace', 'Faviet', 'Child",109);" INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee id) VALUES (8, 'Matthew', 'Chen', 'Child',110); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (9,'Joe', 'Sciarra', 'Child',111); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (10, 'Christian', "Urman', 'Child",112); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (11, 'Zero', 'Popp", 'Child',113);" INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (12, 'Karl', 'Greenberg', 'Child',108); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (13, 'Una', 'Mavris', 'Child',283); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (14, 'Vivien', 'Hunold', 'Child',103); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (15, 'Cuba', 'Ernst', 'Child',184); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (16, 'Fred', 'Austin', 'Child",105); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (17, 'Helen', 'Pataballa', 'Child',106); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (18, 'Dan', 'Lorentz', 'Child",187); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (19, 'Bob', 'Hartstein', 'Child',201); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (20, 'Lucille', 'Fay', 'Child',2021; INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (21, 'Kirsten', 'Baer', 'Child',204); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (22, 'Elvis', 'Khoo', 'Child',115); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee id) VALUES (23, 'Sandra', 'Baida', 'Child", 116); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (24, 'Cameron', 'Tobias', 'Child',117); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (25, 'Kevin', 'Himuro', 'Child",118); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (26, 'Rip', 'Colmenares', 'Child',119); INSERT INTO dependents (dependent_id, first name, last_name, relationship, employee id) VALUES (27, 'Julia', 'Raphaely', 'Child',114); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (28, 'Woody', 'Russell', 'Child',145); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee id) VALUES (29, 'Alec','Partners', 'Child',146); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (30, 'Sandra', 'Taylor', 'Child',176); G CREATE TABLE regions ( region_id INT (11) AUTO INCREMENT PRIMARY KEY, region_name VARCHAR (25) DEFAULT NULL }; CREATE TABLE countries ( country_id CHAR (2) PRIMARY KEY, country_nane VARCHAR (40) DEFAULT NULL, region_id INT (11) NOT NULL, FOREIGN KEY (region_id) REFERENCES regions (region_id) ON DELETE CASCADE ON UPDATE CASCADE }; CREATE TABLE locations ( location_id INT (11) AUTO_INCREMENT PRIMARY KEY, street address VARCHAR (48) DEFAULT NULL, postal code VARCHAR (12) DEFAULT NULL, city VARCHAR (38) NOT NU DEFAULT NULL, state province VARCHAR (25) DEFAULT NULL, NULL, country_id CHAR (2) NOT NULL, FOREIGN KEY (Country_id) REFERENCES countries (country_id) ON DELETE CASCADE ON UPDATE CASCADE CREATE TABLE jobs ( job_id INT (11) AUTO_INCREMENT PRIMARY KEY, jab title VARCHAR (35) NOT NULL, min_salary DECIMAL (8, 21 DEFAULT NULL, max_salary DECIMAL (8, 21 DEFAULT NULL }; CREATE TABLE departments [ department_id INT (11) AUTO_INCREMENT PRIMARY KEY, department_nane VARCHAR (30) NOT NULL, location_id INT (11) DEFAULT NULL, FOREIGN KEY (location_id) REFERENCES locations (location_id) ON DELETE CASCADE ON UPDATE CASCADE }; CREATE TABLE enployees ( employee_id INT (11) AUTO INCREMENT PRIMARY KEY, first name VARCHAR (20) DEFAULT NULL, last name VARCHAR (25) NOT NULL, email VARCHAR (100) NOT NULL, phone number VARCHAR (20) DEFAULT NULL, hire date DATE NOT NULL, job_id INT (11) NOT NULL, salary DECIMAL (8, 2) NOT NULL, manager_id INT (11) DEFAULT NULL, department_id INT (11) DEFAULT NULL, FOREIGN KEY (job_id) REFERENCES jobs (job_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (department_id) REFERENCES departments (department_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (nanager_id) REFERENCES employees (employee_id) CREATE TABLE dependents ( dependent_id INT (11) AUTO INCREMENT PRIMARY KEY, first name VARCHAR (50) NOT NULL, last name VARCHAR (50) NOT NULL, relationship VARCHAR (25) NOT NULL, employee_id INT (11) NOT NULL, FOREIGN KEY (employer_id) REFERENCES employees (employee_id) ON DELETE CASCADE ON UPDATE CASCADE }; /4Data for the table regions */ INSERT INTO regions (region_id, region_name) VALUES (1, 'Europe'); INSERT INTO regions (region_id, region_name) VALUES (2, 'Anericas'); INSERT INTO regions (region_id, region_name) VALUES (3, 'Asia'); INSERT INTO regions (region_id, region_name) VALUES (4, 'Middle East and Africa'); G /4Data for the table countries */ INSERT INTO countries (country_id, country_name, region_id) VALUES ('AR', 'Argentina', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('AU', 'Australia',3); INSERT INTO countries (country_id, country_name, region_id) VALUES ("BE', 'Belgium',1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('BR', 'Brazil',21; INSERT INTO countries (country_id, country_name, region_id) VALUES ('CA', 'Canada',21; INSERT INTO countries (country_id, country_name, region_id) VALUES ('CH', 'Switzerland", 1); INSERT INTO countries (country_id, country_name, region_id) VALUES ("CN", "China",3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('DE', 'Germany',1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('DK', 'Denmark',1); INSERT INTO countries (country_id, country_name, region_id) VALUES ('EG', 'Egypt', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ("FR', 'France',1); INSERT INTO countries (country_id, country_name, regian_id) VALUES ('HK', 'HongKong',3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('IL', 'Israel',41; INSERT INTO countries (country_id, country_name, region_id) VALUES (IN', 'India',3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('IT', 'Italy 1 INSERT INTO countries (country_id, country_name, region_id) VALUES ('JP, Japan,3); INSERT INTO countries (country_id, country_name, region_id) VALUES ('KW', 'Kuwait,41; INSERT INTO countries (country_id, country_name, region_id) VALUES ('MX', 'Mexico',21; INSERT INTO countries (country_id, country_name, region_id) VALUES ('NG', 4); INSERT INTO countries (country_id, country_name, region_id) VALUES ('NL', INSERT INTO countries (country_id, country_name, region_id) VALUES ('SG', 'Singapore',3); INSERT INTO countries (country_id, country_name, region_id) VALUES (UK', 'United Kingdom',1); "NU 10: INSERT INTO countries (country_id, country_name, region_id) VALUES ('US', 'United States of America', 2); INSERT INTO countries (country_id, country_name, region_id) VALUES ('ZM', 'Zambia',41; INSERT INTO countries (country_id, country_name, region_id) VALUES ('ZW', 'Zimbabwe', 4); /+Data for the table locations */ INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (1408, 2014 Jabberwocky Rd', '26192', 'Southlake', 'Texas', 'US'); INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (1508, 2011 Interiors Blvd', '99236', 'South San Francisco', "California', 'US'); INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (1708, 2004 Charade Rd', '98199', 'Seattle', 'Washington', 'US'1; INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (1808, 147 Spadina Ave', 'M5V 2L7', 'Toronto', "Ontario', 'CA'); province, country_id) VALUES (2400, 8204 Arthur St',NULL, 'London',NULL, 'K'); INSERT INTO locations (location_id,street_address, postal code, city, state INSERT INTO locations (location_id, street_address, postal code, city, state province, country_id) VALUES (2508, "Magdalen Centre, The Oxford Science Park', '0x9 9ZB', 'Oxford', "Oxford", "UK'); INSERT INTO locations (location_id,street_address, postal code, city, state province, country_id) VALUES (2708, "Schwanthalerstr. 7831', '88925', 'Nunich', 'Bavaria', 'DE'); /4Data for the table jobs */ INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (1, 'Public Accountant, 1200.00,9000.00); INSERT INTO jobs(job_id, job_title, nin_salary, nax_salary) VALUES (2, 'Accounting Manager,8200.00, 16000.00); INSERT INTO jobs(job_id,job_title,nin_salary, nax_salary) VALUES (3, 'Administration Assistant', 3000.00, 6080.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary! VALUES (4, 'President',20000.00,40000.00); INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (5, 'Administration Vice President',15800.00,30000.00); INSERT INTO jobs(job_id,job_title,nin_salary, nax_salary) VALUES (6, 'Accountant', 4200.00, 9000.00); INSERT INTO jobs(job_id, job_title, nin_salary, nax_salary) VALUES (7, 'Finance Manager',8280.00,16000.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary! VALUES (8, 'Human Resources Representative',4800.00,9008.08); INSERT INTO jobs (job_id,job_title, nin_salary, nax_salary) VALUES (9, 'Programmer', 4000.00, 10000.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary) VALUES (10, Marketing Manager,9008.00, 15000.00); INSERT INTO jobs(job_id, job_title, nin_salary, nax_salary) VALUES (11, Marketing Representative',4088.88,9800.00); INSERT INTO jobs(job_id,job_title,nin_salary, nax_salary! VALUES (12, 'Public Relations Representative",4580.00,18500.00); INSERT INTO jobs (job_id,job_title, nin_salary, nax_salary! VALUES (13, 'Purchasing Clerk',2500.00,5500.00); INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (14, 'Purchasing Manager',8080.80,15008.08); INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (15, 'Sales Manager',10080.00,20000.00); INSERT INTO jobs(job_id,job_title,nin_salary, nax_salary) VALUES (16, 'Sales Representative",6008.08,12800.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary) VALUES (17, 'Shipping Clerk',2500.00,5500.00); INSERT INTO jobs (job_id, job_title, nin_salary, nax_salary) VALUES (18, 'Stock Clerk',2080.80,5000.00); INSERT INTO jobs(job_id,job_title, nin_salary, nax_salary) VALUES (19, 'Stock Manager',5508.00, 8500.00); /+Data for the table departments */ INSERT INTO departments (department_id, department_nane, location_id) VALUES (1, 'Administration',1700); INSERT INTO departments (department_id, department_name, location_id) VALUES (2, 'Marketing',1880); INSERT INTO departments (department_id, department_name, location_id) VALUES (3, 'Purchasing', 1700); INSERT INTO departments (department_id, department_name, location_id) VALUES (4, 'Human Resources',2488); INSERT INTO departments (department_id, department_name, location_id) VALUES (5, 'Shipping', 1500); INSERT INTO departments (department_id, department_name, location_id) VALUES (6, 'IT',1480); G INSERT INTO departments (department_id, department_nane, location_id) VALUES (7, 'Public Relations',2780); INSERT INTO departments (department_id, department_name, location_id) VALUES (8, 'Sales',2500); INSERT INTO departments (department_id, department_name, location_id) VALUES (9, 'Executive', 1780); INSERT INTO departments (department_id, department_name, location_id) VALUES (10, 'Finance', 1788); INSERT INTO departments (department_id, department_name, location_id) VALUES (11, 'Accounting', 1700); /*Data for the table employees */ INSERT INTO employees (employee_id, first name, last name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (100, 'Steven', 'King', steven.king@saltutorial.org', '515.123.4567', '1987-06-17,4,24880.80,NULL,9); INSERT INTO employees (employce_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (101, 'Neena', 'Kochhar', 'neena.kochhar@sqltutorial.org', '515. 123.4568', '1989-09-21,5,17800.00, 100, 9); INSERT INTO employees (employee_id, first name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (102, 'Lex', 'De Haan', 'lex.de haan@sqltutorial.org', '515.123.4569', '1993-81-13,5,17088.00,108,91; INSERT INTO employees (employnastane, email, phone number,hire_date, job_id, salary, manager_id, department_id) VALUES (103, 'Alexander', "Hunold', 'alexander.hunold@sqltutorial.org', '590.423.4567', '1998-01-03,9,9000.00,102,6); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id,department_id) VALUES (184, 'Bruce', 'Emst', 'bruce.ernst@sqltutorial.org', '590.423.4568', '1991-05-21',9,6088.00,183,61; INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (105, 'David', 'Austin', 'david. austin@sqltutorial.org', '598.423.4569', '1997-86-25,9,4800.00, 103,6); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (106, 'Valli', 'Pataballa', 'valli.pataballagsqltutorial.org', '598.423.4560', '1998-82-85,9,4800.80,103,6); INSERT INTO employees (employee_id, first_name, last_nane, email, phone number, hire_date, job_id, salary, manager_id,department_id) VALUES (187, 'Diana', 'Lorentz', 'diana. Lorentz@sqltutorial.org', '590.423.5567', '1999-02-07,9,4200.00,103,6); INSERT INTO employees (employee_id, first name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (188, 'Nancy', 'Greenberg', 'nancy.greenberggsqltutorial.org', '515.124.4569', '1994-88-17,7,12800.00, 101, 10); INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (109, 'Daniel', 'Faviet', 'daniel.faviet@sqltutorial.org', '515.124.4169', '1994-08-16,6,9000.00,108,10); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (110, 'John', 'Chen', 'john.chen@sqltutorial.org', '515.124.4269', '1997-09-28,6,8200.00,108,10); INSERT INTO employees (employee_id, first_name,last_nane, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (111, 'Ismael', 'Sciarra', 'ismael.sciarra@sqltutorial.org', '515.124.4369', '1997-09-30,6,7700.00, 108, 101; INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id,department_id) VALUES (112, 'Jose Manuel', 'Urman', "Jose nanuel.urmanesqltutorial.org', '515.124.4469', '1998-03-07,6,7808.00, 108, 10); INSERT INTO employees (employee_id, first_name, last_nane, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (113, 'Luis', 'Popp', 'luis.popp@sqltutorial.org', '515.124.4567', '1999-12-07,6,6900.00,108,10); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (114, 'Den', 'Raphaely', 'den. raphaely@sqltutorial.org', '515.127.4561', '1994-12-87,14,11080.00,100,3); INSERT INTO employees (employee_id, first_name, last_nane, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (115, 'Alexander', 'Khoo', 'alexander.khoo@sqltutorial.org', '515.127.4562', '1995-05-18,13,3100.00,114,31; INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department 10) VALUES (116, 'Shelli', 'Baida", 'shelli.baidaysqltutorial.org', '515.127.4563', '1997-12-24,13, 2908.00, 114,3); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (117, 'Sigal', 'Tobias', 'sigal. tobias@sqltutorial.org', '515.127.4564', '1997-87-24,13, 2800.00, 114,31; INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (118, 'Guy', 'Hinuro', "guy.hinuro@sqltutorial.org', '515.127.4565', '1998-11-15,13, 2600.00, 114,3); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (119, 'Karen', 'Colmenares', 'karen.colmenares@sqltutorial.org', '515.127.4566', '1999-08 -10,13,2500.88,114,3); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_10) VALUES (120, 'Matthew', 'Weiss', 'natthew.weissgsqltutorial.org', '650.123.1234', '1996-07-18,19,8800.00, 100,5); INSERT INTO employees (employee_id, first_name, last_nane, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (121, 'Adam', 'Fripp', "adan. fripp@sqltutorial.org',650.123.2234', '1997-84-18,19,8200.00,100,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (122, 'Payan', 'Kaufling','payam.kaufling@sqltutorial.org', '658.123.3234', '1995-05-01,19,7908.00,108,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (123, 'Shanta', 'vollman','shanta.vollman@sqltutorial.org', '658.123.4234', '1997 10 10,19,6508.00,188,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, manager_10, department_id) VALUES (126, 'Irene', 'Mikkilineni', 'irene.nikkilineni@sqltutorial.org', '650.124.1224, 1998-89-28, 18, 2700.00, 120,5); INSERT INTO employees (employee_id, first_name, Last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (145, 'John', 'Russell', 'john.russell@sqltutorial.org',NULL, "1996-10-01',15,14000.00,180,8); INSERT INTO employees (employee_id, first_name, Last_name, email, phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (146, 'Karen', 'Partners', 'karen.partners@sqltutorial.org',NULL, '1997-01-05,15, 13500. 80, 100,8); INSERT INTO employees (employee_id, first_name, last_nane, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (176, 'Jonathan', 'Taylor', 'jonathon. taylor@sqltutorial.org',NULL, '1998-83-24",16,8600.00,100,8); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (177, 'Jack', 'Livingston', 'jack.livingstongsqltutorial.org',NULL, '1998-84-23, 15, 8400.00, 100,8); INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES G '1999-85-24, 16,7000.00, 100,8); (178, 'Kimberely', 'Grant', 'kimberely.grant@sqltutorial.org',NULL, INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (179, 'Charles', 'Johnson', 'charles.johnsongsqltutorial.org',NULL, '2000-81-84", 16,6200.00, 100,8); INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (192, 'Sarah', 'Bell', 'sarah.bell@sqltutorial.org', 650.501.1876', '1996-82-84,17,4000.00,123,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (193, 'Britney', 'Everett', 'britney.everett@sqitutorial.org', '650.501.2876', '1997-83-83,17,3900.00, 123,5); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (200, 'Jennifer', 'Whalen', 'jennifer.whalengsqltutorial.org', '515. 123.4444', '1987-89-17,3,4400.00,101,1); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (201, 'Michael', 'Hartstein', 'michael.hartstein@sqltutorial.org', '515.123.5555', '1996-82-17, 10, 13008.08,188,2); INSERT INTO employees (employee_id, first_name, last_nane, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (202, 'Pat', 'Fay', 'pat. fay@sqltutorial.org", '603.123.6666', '1997-08-17,11,6008.00,201,21; INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (203, 'Susan', 'Mavris', 'susan.mavris@sqltutorial.org', '515.123.7777', '1994-86-87,8,6500.00, 101,4); INSERT INTO employees (employee_id, first_name, last_name, email,phone_number, hire_date, job_id, salary, manager_id, department_id) VALUES (204, 'Hermann', 'Baer', 'hermann.baer@sqltutorial.org', '515.123.8888', '1994-86-87,12,10000.00,101,7); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (205, 'Shelley', 'Higgins', 'shelley.higgins@sqltutorial.org', '515.123.8880', '1994-86-87,2,12800.00, 101, 11); INSERT INTO employees (employee_id, first_name, last_name, email, phone number, hire_date, job_id, salary, manager_id, department_id) VALUES (206, 'William', 'Gietz', 'willian.gietz@sqltutorial.org', '515.123.8181', '1994-06-07',1,8380.00,205,11); /*Data for the table dependents */ INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (1, 'Penelope', 'Gietz', 'Child',206); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (2, 'Nick', 'Higgins', 'Child",205); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (3, 'Ed', 'Whalen', 'Child", 2001; INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (4, 'Jennifer', 'King', 'Child", 100); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (5, Johnny', 'Kochhar', 'Child',101); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee id) VALUES (6, 'Bette', 'De Haan', 'Child", 102); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (7, 'Grace', 'Faviet', 'Child",109);" INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee id) VALUES (8, 'Matthew', 'Chen', 'Child',110); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (9,'Joe', 'Sciarra', 'Child',111); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (10, 'Christian', "Urman', 'Child",112); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (11, 'Zero', 'Popp", 'Child',113);" INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (12, 'Karl', 'Greenberg', 'Child',108); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (13, 'Una', 'Mavris', 'Child',283); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (14, 'Vivien', 'Hunold', 'Child',103); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (15, 'Cuba', 'Ernst', 'Child',184); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (16, 'Fred', 'Austin', 'Child",105); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (17, 'Helen', 'Pataballa', 'Child',106); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (18, 'Dan', 'Lorentz', 'Child",187); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (19, 'Bob', 'Hartstein', 'Child',201); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (20, 'Lucille', 'Fay', 'Child',2021; INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (21, 'Kirsten', 'Baer', 'Child',204); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (22, 'Elvis', 'Khoo', 'Child',115); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee id) VALUES (23, 'Sandra', 'Baida', 'Child", 116); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (24, 'Cameron', 'Tobias', 'Child',117); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (25, 'Kevin', 'Himuro', 'Child",118); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (26, 'Rip', 'Colmenares', 'Child',119); INSERT INTO dependents (dependent_id, first name, last_name, relationship, employee id) VALUES (27, 'Julia', 'Raphaely', 'Child',114); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee_id) VALUES (28, 'Woody', 'Russell', 'Child',145); INSERT INTO dependents (dependent_id, first_nane, last_name, relationship, employee id) VALUES (29, 'Alec','Partners', 'Child',146); INSERT INTO dependents (dependent_id, first_name, last_name, relationship, employee_id) VALUES (30, 'Sandra', 'Taylor', 'Child',176); G