Question
Question 3 The following Figure 1 shows some portion of the database of a company on medical claims. Refer to the relations, Claim, Employee and
Question 3 The following Figure 1 shows some portion of the database of a company on medical claims. Refer to the relations, Claim, Employee and ClaimType shown in the diagram and answer the following questions.
Question 4 Based on the table provided in question (3) 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. (b) Produce a list of approved claims, showing only the claimNo, empID and amount. (c) Find the highest approved claim for each claim code. (d) List all ID of employees who work in sales department without having any claims. (You may use rename operator where necessary). (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).
Claim claimNo dateFrom dateTo emp ID claimCode amount status 001 13 Mar E0968 MO1 002 13 Mar 16 Mar 08 Apr 20 Mar E4928 T34 45.00 Pending 369.75 Approved 55.50 Pending 003 09 Apr E2728 P11 Employee remaining Medical 1760.00 id department bank account E0968 production maybank 887799002637481 E4928 sales CIMB 546372819037 E2728 sales maybank 882435536772804 1587.00 765.90 ClaimType code type account approval From MO1 medical health care HR D21 dentist heath care HR 087 overtime departmental department T34 travel travel HR P11 parking & toll travel HRStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started