Advance database

a. Write two stored procedures (must have at least 6-10 parameters of different datatype) to insert and update the data. 

b. Stored procedure should insert the records in multiple tables (meaning inserting or updating data in parent and child tables). In this scenario you insert data first in parent table get the key column ID value and use it as reference key value to insert in the second table)

c. Write a cursor to loop the set of records and perform the data update

d. Write a select statement using Common Table Expressions (CTE)