based on the table provided provide the relevant relational algebra operations that is been described in the following section.

a.) list all employees in HR department who are having remaining Medical greater than 1000.00. ********3 marks

b.) produce a list of approved claims, showing only the claim No, empID and amount. **********3 marks.

c.) find the highest approved claim for each claim code. ************ 4 marks.

d.) list all ID of employees who work in sales department without having any claims. (may use rename operator where necessary). **********4 marks.

e.) produce a list of claims for employees in sales department, showing only the claimNo, empID, claimCode and amount. (may use assignment operator where necessary). **********10 marks

Claim claimNo dateFrom dateTo empID claimCode amount status 001 13 Mar 13 Mar E0968 MO1 45.00 Pending 002 16 Mar 20 Mar E4928 134 369.75 Approved 003 08 Apr 09 Apr E2728 P11 55.50 Pending Employee id department bank account E0968 production maybank 887799002637481 E4928 sales CIMB 546372819037 E2728 sales maybank 882435536772804 remainingMedical 1760.00 1587.00 765.90 ClaimType code type account approvalFrom M01 D21 087 T34 medical dentist overtime travel parking & toll health care heath care departmental travel travel HR HR department HR HR P11