Chapter 3, Problem 12E

Explanation of Solution

a.

Query:

Insert into course(course_id, title, dept_name, credits)values (‘CS-001’, ‘Weekly Seminar’, ‘Comp...

Explanation of Solution

b.

Query:

insert into section(course_id, sec_id, semester, year) values (‘CS-001’, 1, ‘Autumn’, 2017)

Explanation:

The above quer...

Explanation of Solution

c.

Query:

insert into takes(ID, course_id, sec_id, semester, year)select ID, ‘CS-001’, 1, ‘Autumn’, 2017 from student where dept_name=’Comp...

Explanation of Solution

d.

Query:

delete from takes where (course_id=’CS-001’) and (sec_id=1) and (semester=’Autumn’) and (year=2017) and (ID in (select ID, name fro...

Explanation of Solution

e.

Query:

delete from courses where course_id=’CS-001’;

Explanation:

Explanation of Solution

f

Query:

delete from takes where course_id in (select course_id from course where lower(title)like ‘advanced’);