class_list stores who takes which course, and the course's title, instructor and office. Its primary key is (student_id, course_id).
- How many rows store the title of course DB-1?
- DB-1 is renamed to
'Database Systems'. Update the table so that no row keeps the old title. - A new course, AI-4
'Machine Learning', taught by Dr. Hale in OT-210, has no students yet. Try to store it with the INSERT below. Which column stops the insert?
sql
INSERT INTO class_list (course_id, course_title, instructor, office)
VALUES ('AI-4', 'Machine Learning', 'Dr. Hale', 'OT-210');- Student S3 leaves the university. Delete all of S3's rows.
- Which instructor's office is no longer stored anywhere?