Required Reading: Chapter $8,11,14$

Write SQL statements for the following steps on the Sample database $($textbook example database$-$the

version which doesn$$t declare any constraints$)$:

a$.$ Create a stored procedure called insertRecord that takes three parameters as input$-$ start value,

increment amount, and no of records. it inserts no of records rows in the employee table. The value

of the emp$\_$no column should start with the start value, and for the rest of the rows emp$\_$no will be

increment by the increment amount. All values of the columns emp$\_$lname$,$ emp$\_$fname, and

dept$\_$no should be set to 'Jane', 'Smith', and $\text{'}$d$1\text{'},$ respectively.

b$.$ Create a view that comprises the first and last names of all employees who entered their projects in

the second half of the year $2017.$

c$.$ Create a view $($with the WITH CHECK OPTION clause$)$ that comprises the first and last names of all

employees whose employee number is less than $10,000.$ After that, use the view to insert data for a

new employee named Kohn with the employee number $22123,$ who works for the dement d$3.$

d$.$ With the help of triggers, define the referential integrity for the primary key of the project table, the

project$\_$no column, which is the foreign key of the works$\_$on table.

$100$ points$(4*25$points