Fall $2024-$ Introduction to Databases

Part $3-$ Relational Algebra Expressions $(20$ pts$)$

Create relational algebra expressions using the tool at RelaX $-$ relational algebra calculator

$($

dbis$-$uibk.qithub.io$)$ We will use the Franklin University Employee Dataset.

Create the relational algebra expressions for the following.

Question $3\mathrm{.}1(3$ pts$)$

Provide a list of DEPARTMENT where Dname $=$ 'Research'

Question $3\mathrm{.}2(3$ pts$)$

Provide a list of EMPLOYEE where Dno $=5$

Question $3\mathrm{.}3(4$ pts$)$

Provide a list of employees in the Research Department. You must use an inner join operator

between EMPLOYEES and DEPARTMENT. You should include ONLY the EMPLOYEE columns.

Question $3\mathrm{.}4(4$ pts$)$

Provide a list of EMPLOYEEs and their DEPENDENTs. You should include the following data

elements ONLY:

FNAME

Minit

Lname

Ssn$,$

Bdate

Dependent$\_$name

Dependent Relationship

Dependent Bdate

Dependent Sex

HINT: You will need to use the cross apply and then a natural join operator.

Question $3\mathrm{.}5(6$ pts$)$

Provide a list of EMPLOYEEs and their Managers. You should include the following data

elements ONLY:

EmployeeLastName

EmployeeFirstName,

ManagerLastName

ManagertFirstName

HINT: you will need to reference the EMPLOYEE table once as an EMPLOYEE and once as a

MANAGER.