database

PART B: SQL DML/DDL (20 points) The following relational schema forms part of an Employees database. The primary keys are underlined and foreign keys are in italics. Job (jobID, job Title, minSalary, maxSalary) Dependent dependentID, firstName, lastName, relationship, employeeld) Department (departmentID, departmentName, locationID) Location location ID, street, postcode, city, state) Employee (employeeID, firstName, lastName, phoneNumber, salary, jobID, departmentID) Employee employeeID works as jobID at a department departmentID located at locationID. The employee has dependent(s) dependentID. 1. List employee names and dependent names. Also, include employees without any dependents. (2 points)