1. Write a CREATE TABLE statements for the all tables with the following specifications: Cascade updates and deletions from Class to Student Cascade only updates from Class to Teacher. Cascade only deletions from Teacher to Laboratory. Don't Cascade updates and deletions from Student to Course. The default value of NumberOfStudent in Class is 0. 2. Write an UPDATE statement to modify the teacher of certain Laboratory given the Laboratory name and teacher name. 3. Write an ALTER statement to add the column, PhoneNumber to Teacher. Assume that is, Phone Number required. 4. Create a trigger named GPA that updates table "Student with the new Average, after each insert in the table Course. 5. State whether the above database has deletions anomalies. if yes solve it. 6. Is the above data in the BCNF, justify your answers? 7. The student must pay beforehand the tuition for the school, Write SQL statements to alter existing tables and create new tables, and insert records such that the above feature could be implemented. Given The Implementation of the School database study it carefully and answer the following Tasks: Student (StudentID. StudentName, ClassID, Age, TotalAverage) Class ClassID, ClassName, NumberOfStudent) Teacher (TeacherID, TeacherName, ClassID, Salary, Major) Laboratory (LaboratoryID. LaboratoryName, Laboratory TeacherID, Type) Course CourseID. StudentID, CourseName, grade) The School database has the following referential integrity constraints: ClassID in Student must exist in ClassID in Class. ClassID in Teacher must exist in ClassID in Class. Laboratory TeacherID in Laboratory must exist in TeacherID in Teacher. StudentID in Course must exist in StudentID in Student. The School database has the following unique constraints: StudentName in Student ClassName in Class Teacher Name in Teacher LaboratoryName in Laboratory. CourseID, StudentID in Course