Show the result of each of the sample queries in Section $6\mathrm{.}5$ as it would apply to the database state in Figure $3\mathrm{.}6.$

Query written answer needed as well as outcome

Query $6.$ Retrieve the names of employees who have no dependents.

This is an example of the type of query that uses the MINUS $($SET DIFFERENCE$)$ operation.

ALL$\_$EMPS $\backslash$pi Ssn$($EMPLOYEE$)$

EMPS$\_$WITH$\_$DEPS$($Ssn$)\backslash$pi Essn$($DEPENDENT$)$ EMPS$\_$WITHOUT$\_$DEPS $($ALL$\_$EMPS $$ EMPS$\_$WITH$\_$DEPS$)$ RESULT $\backslash$pi Lname, Fname$($EMPS$\_$WITHOUT$\_$DEPS $*$ EMPLOYEE$)$

We first retrieve a relation with all employee Ssns in ALL$\_$EMPS. Then we create a table with the Ssns of employees who have at least one dependent in EMPS$\_$WITH$\_$DEPS. Then we apply the SET DIFFERENCE operation to retrieve employees Ssns with no dependents in EMPS$\_$WITHOUT$\_$DEPS, and finally join this with EMPLOYEE to retrieve the desired attributes. As a single in$-$line expression, this query becomes: