4.14 No Scaffolding Lab 4

/*
Q1: Write the SQL to create a stored procedure to UPDATE the BeginDate column in the
-- STUDENT_DORMROOM table. USE THROW error-handling if variable is NULL.
*/




/*
Q2: Write the SQL to create a stored procedure to DELETE a row in the STUDENT_DORMROOM table.
-- USE RAISERROR error-handling if any variable is NULL.
*/




/*
Q3: Write the SQL to create a stored procedure to INSERT a row in the DEPARTMENT table.
USE THROW error-handling if variable is NULL.
*/




/*
Q4: Write the SQL to create a stored procedure to UPDATE the EndDate column in the DEPARTMENT table.
Use RAISERROR method of error-handling if variable is NULL
*/



/*
Q5: Write the SQL to create a stored procedure to DELETE a row in the DEPARTMENT table.
*/




/*
Q6: Write the SQL query to determine which classes meet all of the following conditions:
1) have associate professors that taught a philosophy class in the last 7 years
2) are part of department that have more than 3 students living in a double dorm room type.
*/