Database

More than one correct answer

Class Consider the following relations for a database that keeps track of student enrollment in courses. STUDENT Name Student number Major Smith 17 1 CS Brown 8 2 CS GRADE REPORT Student number Section identifier 17 112 COURSE 17 119 Course_name Course_number Credit_hours Department 8 85 Intro to Computer Science CS1310 4 CS 8 92 Data Structures CS3320 4 CS 8 102 Discrete Mathematics MATH2410 3 MATH 8 135 Database CS3380 3 CS Grade B A B A Year PREREQUISITE Course number CS3380 CS3380 CS3320 Prerequisite_number CS3320 MATH2410 CS1310 07 07 SECTION Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Semester Fall Fall Spring Fall Fall Fall 08 Instructor King Anderson Knuth Chang Anderson Stone 08 08 08 From the list below, choose which situations would cause INSERT, DELETE, or UPDATE (Modification) violations in these relations. Do not consider that the violation might be handled or prevented, just choose those situations that would cause the violations. Insert into STUDENT Insert into STUDENT Insert into GRADE_REPORT Insert into GRADE_REPORT Insert into SECTION Delete the COURSE tuple with Course_Number = 'CS3380 UPDATE the Major of the STUDENT tuple with Student_number = 17 to 'MATH" O UPDATE the Course_number of the SECTION with Section_Identifier = 102 to 'CS4477