Write the SQL queries to insert the data into the tables as shown above.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.

$($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$]$