the following figure $1$ shows some portion of the database of a company on medical claimsQuestion $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.

$($a$)$ Write the SQL queries to create each of the tables shown above

$[12$ Marks$]$

$($b$)$ Write the SQL queries to insert the data into the tables as shown above.

$[5$ Marks$]$

$($c$)$ Based on the tables of the above given schema, write SQL integrity

enhancement features for the following constraints:

$($i$)$ claimCode must be the one that exist as code in ClaimType $.$

$($ii$)$ amount must be an integer value between $0$ and $100.$

$[8$ Marks$]$

$($d$)$ 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$).$