Can you please give the SQL code for these question

1. Attempt to update a current employee's department to an invalid one.
2. Attempt to delete a record from the department table.
3. Attempt to drop the department table.
4. Attempt to truncate the department table.
5. Attempt to create a check constraint on the salary field in the employee table that makes sure the salary > 8.00 (show me the code). Verify that it works by attempting to insert an employee with a salary of 7.00
6. Attempt to change (update) the salary of an existing employee to $11.