Practice exercises

Exercise:

Go to the Main screen $$ Click on the "Select DB$"$ on the top left corner of the board

$->$ Click on the "Employee $($Franklin University$)"$ Database and solve the following

questions by using RelaX. List the names of all employees.

Figure $1.$ Employee $($Franklin University$)$ Schema

List the names of all female employees.

List the names of all employees along with their department names.

List the names of all departments along with their manager's social security number.

Find the average salary of employees in each department.

List the names of employees who don't work on any projects.

List the names of all employees and their dependents.

List the names of employees who are also managers of departments.

Find the names of all employees who work on every project.

Find the names of employees with the same supervisor as the employee with social

security number $\text{'}123456789\text{'}.$