[solved]-Given Tables Defined Statements Statements Locate Last First Name Employees Along First Na Q38997784

Given the tables defined by the statements below, which of the statements will locate the last and first name of all employees along with the first names of the dependents for the employees? (The employee name will still be listed even if the employee has no dependents. No NULL values will be GO displayed in the EMPLOYEES name columns.) CREATE TABLE employees empid INTEGER PRIMARY KEY S firstname CHAR (20) NOT NULL, lastname CHAR (20) NOT NULL) BUD CREATE TABLE dependents dependentid INTEGER PRIMARY KEY, dep_firstname CHAR (20) NOT NULL, dep_lastname CHAR (20) NOT NULL, dep_age INTEGER) CREATE TABLE emp_dependente empid INTEGER NOT NULL, dependentid INTEGER NOT NULL, PRIMARY KEY (dependentid, empid), FOREIGN KEY (empid) REFERENCES employees (empid), FOREIGN KEY (dependentid) REFERENCES dependents dependentid)) A SELECT employees. lastname, employees. firstname, dependents.dep_firstname FROM employees LEFT OUTER JOIN emp_dependents on employees.enpid – exp_dependents.enpid LEFT OUTER JOIN dependenta ON empdependenta.dependentid – dependents.dependentid E B . SELECT employees.lastname, employees. firstname, dependents.dep_firstname FROM employees LEFT OUTER JOIN emp, dependents on employees.empid – emp_dependents.espid INER JOIN dependents o emp_dependents.dependentid – dependenta dependentid C. SELECT employees. lastname, employees. Firstnane, dependents.dep_firstname FROM employees LEFT OUTER JOIN emp_dependents on employees.empid – emp_dependenta.enpid FULL OUTER JOIN dependents ONp_dependents dependentid – dependents. dependentid PG D. SELECT employees. lastname, employees. Firstnane, dependents.dep_firstname FROM employees FULL OUTER JOIN emp_dependents on employees. empid – exp_dependents.enpid RIGHT OUTER JOIN dependenta ON emp_dependenta dependentid – dependents. dependentid DE SELECT employees. lastname, employees.firstnane, dependents.dep_firstname FROM employees RIGHT OUTER JOIN emp, dependenta ON employees.enpid – emp_dependents.empid LEFT OUTER JOIN dependents ON emp_dependenta.dependentid – dependents.dependentid Show transcribed image text Given the tables defined by the statements below, which of the statements will locate the last and first name of all employees along with the first names of the dependents for the employees? (The employee name will still be listed even if the employee has no dependents. No NULL values will be GO displayed in the EMPLOYEES name columns.) CREATE TABLE employees empid INTEGER PRIMARY KEY S firstname CHAR (20) NOT NULL, lastname CHAR (20) NOT NULL) BUD CREATE TABLE dependents dependentid INTEGER PRIMARY KEY, dep_firstname CHAR (20) NOT NULL, dep_lastname CHAR (20) NOT NULL, dep_age INTEGER) CREATE TABLE emp_dependente empid INTEGER NOT NULL, dependentid INTEGER NOT NULL, PRIMARY KEY (dependentid, empid), FOREIGN KEY (empid) REFERENCES employees (empid), FOREIGN KEY (dependentid) REFERENCES dependents dependentid)) A SELECT employees. lastname, employees. firstname, dependents.dep_firstname FROM employees LEFT OUTER JOIN emp_dependents on employees.enpid – exp_dependents.enpid LEFT OUTER JOIN dependenta ON empdependenta.dependentid – dependents.dependentid E B . SELECT employees.lastname, employees. firstname, dependents.dep_firstname FROM employees LEFT OUTER JOIN emp, dependents on employees.empid – emp_dependents.espid INER JOIN dependents o emp_dependents.dependentid – dependenta dependentid C. SELECT employees. lastname, employees. Firstnane, dependents.dep_firstname FROM employees LEFT OUTER JOIN emp_dependents on employees.empid – emp_dependenta.enpid FULL OUTER JOIN dependents ONp_dependents dependentid – dependents. dependentid PG D. SELECT employees. lastname, employees. Firstnane, dependents.dep_firstname FROM employees FULL OUTER JOIN emp_dependents on employees. empid – exp_dependents.enpid RIGHT OUTER JOIN dependenta ON emp_dependenta dependentid – dependents. dependentid DE SELECT employees. lastname, employees.firstnane, dependents.dep_firstname FROM employees RIGHT OUTER JOIN emp, dependenta ON employees.enpid – emp_dependents.empid LEFT OUTER JOIN dependents ON emp_dependenta.dependentid – dependents.dependentid

Expert Answer

---

Answer to Given the tables defined by the statements below, which of the statements will locate the last and first name of all emp… . . .