Database This has $tobeinan$ excel sheet

Create $5$ tabs and

name each accordingly $($i$.$e$.$ Q$3\_1,$ Q$3\_2,$ Q$3\_3,$ Q$3\_4,$ Q$3\_5.).$ Paste a screen shot of your

relational algebraic expression into cell A$1.$

$todo$:

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

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

Create the relational algebra expressions for the following

$1)$ Provide a list of DEPARTMENT where Dname $=$Research$$

$2)$Provide a list of EMPLOYEE where Dno $=5$

$3)$ 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

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

elements ONLY:

$$ FNAME

$$ Minit

$$ Lname

$$ Ssn$,$

$$ Bdate

$$ Dependent$\_$name

$$ Dependent Relatiionship

$$ Dependent Bdate

$$ Dependent Sex

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

$5)$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