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, jobTitle, minSalary, maxSalary)
Dependent (dependentID, firstName, lastName, relationship, employeeID)
Department (departmentID, departmentName, locationID)
Location (locationID, 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)