1. Based on the EMPLOYEE, JOB, and ASSIGNMENT relations presented in write a sequence of relational operations to obtain a list of all job titles within the personnel department. 2. Based on the...

1.
Based on the EMPLOYEE, JOB, and ASSIGNMENT relations presented in write a sequence of relational operations to obtain a list of all job titles within the personnel department.

2.
Based on the EMPLOYEE, JOB, and ASSIGNMENT relations presented in, write a sequence of relational operations to obtain a list of employee names along with the employees’ departments.

3.
Convert your answers to questions 2 and 3 into SQL.

4.
How does the relational model provide for data independence?