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

Must be answered in writing not with an image of the query.

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: