Department(department_id,name)

Q1:write an sql to create a staff table having(staff_id,department_id,first_name,last_name,salary)using the integrity enhancement features of SQL with the following constraints:

salary must be between$1000 and $5000

staff must work in an existing department

no two employees wit the same last name may work for the company

Q2 If a department is removed from the department table, what type of integrity constraint could be violated

Q3 what if we delete a department from department table, how would the staff table contents be affected. What is the side effect as a whole database?