Answered step by step

Verified Expert Solution

Link Copied!

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?

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Intermediate Accounting

Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella

3rd Edition

0136946690, 978-0136946694

More Books

Students also viewed these Accounting questions

Question

★★★★★

What is the difference between transactions and economic exposure? Which can be hedged more easily? Why?

Answered: 1 week ago

Question

★★★★★

=+Oct. 3. Issued a 30-day, 9% note for $42,000 to Oatley Co., on account. 23. Paid Houston Manufacturing Co. the amount due on the note of April 26. Nov. 2. Paid Oatley Co. the amount owed on the...

Answered: 1 week ago

Question

★★★★★

describe antecedents and consequences of quantitative job demands;

Answered: 1 week ago

Question

★★★★★

1. Why did the court conclude that the parties in this case were not bound by the settlement and release documents signed by Gyabaah? 2. Why did Aronsky fail to deliver the signed documents to Rivlab...

Answered: 1 week ago

Question

★★★★★

i need 2 5 7 .

Answered: 1 week ago

Question

★★★★★

As an auditor responsible for auditing the financial statements of a small manufacturing company, what are the key risks you have identified during the audit planning process? How would you address...

Answered: 1 week ago

Question

★★★★★

The post-closing trial balance at 30 June 2020 of Payneham Professional Services is shown below. Transactions completed during the year ended 30 June 2021 are summarised below: 1. Collections on...

Answered: 1 week ago

Question

★★★★★

A B C 1) An object moves along the line from point 1 to point 2 in time t. 2 a) Suppose that the object is speeding up. Which of the labeled points A, B, or C could correspond to the location of the...

Answered: 1 week ago

Question

★★★★★

Harry Hype has $5,000 to spend on advertising a new kind of dehydrated sushi. Market research shows that the people most likely to buy this new product are recent recipients of M.B.A. degrees and...

Answered: 1 week ago

Question

★★★★★

1. A source of yellow light ( = 570 nm) produces interference through two narrow slits separated by a distance of 0.01cm. A screen is placed 3m away. a. How far from the central max is the fifth...

Answered: 1 week ago

Question

★★★★★

You are revising your company's talent acquisition strategy to make it more competitive and appealing to potential candidates. Part of your strategy involves clearly presenting the compensation...

Answered: 1 week ago

Question

★★★★★

3. Explain in detail what you would do to improve the training process at Apex. Make sure to provide specific suggestions.

Answered: 1 week ago

Question

★★★★★

2. Choose a task with which you are familiarmowing the lawn, making a salad, or studying for a testand develop a job instruction sheet for it.

Answered: 1 week ago

Question

★★★★★

4. Find a provider of management development seminars. Obtain copies of its recent listings of seminar offerings. At what levels of managers are the offerings aimed? What seem to be the most popular...

Answered: 1 week ago

Previous Question Next Question