Instructions: Examine Figure 1.2 1. Identify 2 queries and 3 update operations that you would expect to apply to the database shown in Figure 1.2. 2. Give 2 additional views that may be needed by other user groups for the database shown in Figure 1.2. 3. Consider Figure 1.2, If the name of theCS(ComputerScience)Department changes toCSSE (Computer Science and Software Engineering) Department and the corresponding prefix for the course number also changes, identify the columns in the database that would need to be updated.

STUDENT Name Student_number Smith 17 Brown 8 Class 1 2 Major CS CS COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database Course_number Credit_hours Department CS1310 4. CS CS3320 4 CS MATH2410 3 MATH CS3380 3 CS 3 Fall SECTION Section_identifier Course_number Semester 85 MATH2410 Fall 92 CS1310 102 CS3320 Spring 112 MATH2410 Fall 119 CS1310 Fall 135 CS3380 Fall Year 07 07 08 08 08 08 Instructor King Anderson Knuth Chang Anderson Stone 92 07 Anderson 102 Spring Fall 112 CS3320 MATH2410 CS1310 CS3380 08 08 08 08 Knuth Chang Anderson Stone 119 Fall 135 Fall 112 GRADE REPORT Student_number Section_identifier 17 17 119 85 92 102 135 Grade B A A B 8 8 8 8 A Figure 1.2 A database that stores student and course information PREREQUISITE Course_number Prerequisite_number CS3380 CS3320 CS3380 MATH2410 CS3320 CS1310 2