Question

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)

          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)

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)

Added by Maria T.

Question

Please give Ace some feedback