$14$ a$)$ Write SQL DDL statements based on the following database schema $($Assume

$8$

suitable domain types$)$:

Employee $($eid$,$ name, designation, salary, comp$\_$id$)$

Company $($comp id$,$ cname, address, turnover$)$

b$)$ Create the above mentioned tables assuming each company has many employees. Mention the primary key, foreign key and not null constraints.

ii$)$ Insert values into both the tables. Mention in which order insertions will be carried out.

ii$)$ Modify the table Employee to include a new column "years$\_$of$\_$exp"

iv$)$ Increment the salary of employees whose salary is less than Rs $25000$ by $5\%$

b$)$ Illustrate any three ways of using INSERT statement in SQL$.$