MCS-274 Chapter 8 Homework

When turning in a homework problem, mark it with the exercise number shown in bold here. These will be the reference numbers I use in reporting back your standing on the homework.

• 8.1.1 on page 344

• 8.2.1 on page 349

• 8.3.1 on page 352

• 8.4.1 on page 359

• 8.5.1 on page 365. You may limit your attention to the two specific updates listed here. Each of your responses should consist of the SQL commands needed to correspondingly modify MovieProd.

  1. UPDATE Movies
     SET title = 'New Title'
     WHERE title = 'Old Title' AND year = 2001;
     

  2. UPDATE MovieExec
     SET cert# = 314
     WHERE cert# = 271;
     

Instructor: Max Hailperin