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

(a) List all employees in HR department who are having remainingMedical greater than 1000.00.[3 Marks] (b) Produce a list of approved claims, showing only the claimNo, 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. (You 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. (You may use assignment operator where necessary) [10 Marks]

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