Find the ID and name of each student who has taken at least one Comp. Sci. course; make sure there are no duplicate names in the result.

$1$

b$.$

Create a new course $$CS$-001,$ titled $$Weekly Seminar$,$ with $0$ credits.

Note: Provide your comment if you are unable to insert those values.

$2$

c$.$

Create a section of this course in Fall $2017,$ with sec$\_$id of $1,$ and with the location of this section not yet specified.

Note: Provide your comments on this query $($if it does not affect any row$)$

$2$

d$.$

Enroll every student in the Comp. Sci. department in the above section.

$1$

e$.$

Delete enrollments in the above section where the student$$s ID is $12345.$

$1$

f$.$

Delete the course CS$-001.$ What will happen if you run this delete statement without first deleting offerings $($sections$)$ of this course?

Note: Provide your comment on deletion of primary key in this case.

$2$

g$.$

Delete all takes tuples corresponding to any section of any course with