Modifying the Database

1. Insert a row into the department table to record a new production department, department 50, to be based in Glasgow.
2. Change the new row to indicate that the production department is now to be based in Edinburgh.
3. Delete the production department.
4. To see the effect of updates on views:
   1. List the contents of Emp and Emp_View
   2. Delete employee Jones from Emp
   3. List the contents of Emp and Emp_View