Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following relations for a database that keeps track of student enrollment in courses. STUDENT Name Student number Class Major Smith 17 1 cs
Consider the following relations for a database that keeps track of student enrollment in courses. STUDENT Name Student number Class Major Smith 17 1 cs Brown B 2 CS GRADE REPORT Student number Section identifier 17 112 COURSE 17 110 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 Grado B B A Year 07 07 PREREQUISITE Course_number CS3380 CS3380 CS3320 Prerequisito number CS3320 MATH2410 CS1310 SECTION Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 Somostor Fall Fall Spring Fall Fall Fall OB OB Instructor King Anderson Knuth Chang Anderson Stone OB 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. L'Insert Into STUDENT Insert into STUDENT Insert into GRADE REPORT Insert into GRADE REPORT CInsert inta SECTION L'Delete the COURSE tuple with Course_Number='CS3380 L' UPDATE the Major of the STUDENT tuple with Student number = 17 to 'MATH LIPDATE The Courcomber of the SECTION with corrion identifier = 102to2477
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started