$3\mathrm{.}12$ 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 student's 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 case when matching the word with the title.