Write the following queries in SQL, using the university schema.
a. Create a new course “CS-001”, titled “Weekly Seminar”,with 0 credits.
b. Create a section of this course in Autumn 2009, with sec id of 1.
c. Enroll every student in the Comp. Sci. department in the above section.
d. Delete enrollments in the above section where the student’s name is
Chavez.
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 “database” as a part of the title; ignore case when matching
the word with the title.
