Question: University Schema diagram . Write the SQL statements using the university schema to perform the following operations: a ) Create a new course, CS -

University Schema diagram .Write the SQL statements using the university schema to perform the following operations: a) Create a new course, CS-001, titled Weekly Seminar, with 0 credits. b) Create a section of this course in Fall 2017, with sec_id of 1, and with the location of this section not yet specified. c) Enroll every student in the Comp. Sci. department in the above section. d) Delete enrollments in the above section where the students ID is 12345. e) Delete the course CS-001. What will happen if you run this delete statement without first deleting offerings (sections) of this course? f) Delete all takes tuples corresponding to any section of any course with the word advanced as a part of the title; ignore the case when matching the word with the title.
University Schema diagram . Write the SQL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!