Using the COMPANY database state, express the following queries in

relational algebra:

$3\mathrm{.}1$ Select all female employees. $(0\mathrm{.}5$ point$)$

$3\mathrm{.}2$ Select all the employees supervised by the employee

whose Social Security Number $($SSN$)$ is $333445555.$

$(0\mathrm{.}5$ point$)$

$3\mathrm{.}3$ Select all female employees that work in department $5.$

$(0\mathrm{.}5$ point$)$

$3\mathrm{.}4$ Select all projects controlled by department $5.(0\mathrm{.}5$

point$)$

$3\mathrm{.}5$ Select the dependent name and birth date of all

dependents that belong to the employee whose SSN is

$(1$ point$)$

$3\mathrm{.}6$ Produce a relation showing the employee first name,

last name, name of his$/$her dependent, dependent's

birth date, and relationship to the employee. $(1$ point$)$

$3\mathrm{.}7$ Find the first and last name of all non$-$managers. $(1\mathrm{.}5$

point$)$

$3\mathrm{.}8$ Use the natural join operation to find the social security

number of the employee, the project number he$/$she

works on$,$ and the project name she$/$she works on$.(1\mathrm{.}5$

point$)$