Based on the table provided in question $(3)$ provide the relevant relational

algebra operations that is been described in the following section.

$($i$)$ List all employees in HR department who are having remaining Medical

greater than $1000\mathrm{.}00.$

$[3$ Marks$]$

$($ii$)$ Produce a list of approved claims, showing only the claimNo, empID and

amount.

$[3$ Marks$]$

$($iii$)$ Find the highest approved claim for each claim code.

$[4$ Marks$]$

$($iv$)$ List all ID of employees who work in sales department without having any

claims. $($You may use rename operator where necessary$).$

$[4$ Marks$]$

$($v$)$ Produce a list of claims for employees in sales department, showing only

the claimNo, empID, claimCode and amount. $($You may use assignment

operator where necessary$).$