TD 256 Fall 2016/Chapter 7 homework.pdf Pages-aTrouble Tck Exce The CM Tool on ITD 256 Chapter 7 Homework 1. Write a statement to insert a new row into a table named EMPLOYEE with a value of John Doe" in the Name column, a value of "Accounting" in the Department column, and a value of "jdoe 1234@example.comm in the Email column. (9 pts) 2. A student has changed her major, and therefore has a new advisor. Write a statement to update the Major column to 'History' and the Advisor value to Jane Doe' for the row in the STUDENT table with a StudentID of 98765'. (9 pts) 3. Write a statement to remove rows from a table named ANIMAL that have the 'Aves' value in the Class column. (8 pts) 4. Create a view named MANAGER VIEW that shows the Name, PhoneNumber, and Email columns from EMPLOYEE that have an IsManager value of 'yes'. (8 pts) 5. What is the difference between a trigger and a stored procedure? (4 pts) 6. Write statements to create tables according to the following database design. (20 pts)