CSC$430/530$ Database Management Systems

Assignment #$3$ Relational Algebra

Using relational algebra operations, construct queries that satisfy provided descriptions. Provide resulting

relation $($table with tuples$)$ for each query. Database schema and state are provided for your reference.

a$.$ Retrieve last name, and SSN of all male employees with salary more than $20000.$

b$.$ Retrieve project numbers and project locations of all projects that belong to the Administration department.

c$.$ Retrieve first name, last name, date of birth of all employees who work more than $18$ hours on project $1.$

d$.$ Retrieve name, date of birth, and relationship of all male dependents of employees who work for department $4.$

e$.$ Retrieve first name, last name, and salary of employees who manage departments with projects located in Houston.