Previous | Table of Contents | Next

Page 325

  1. Create a stored procedure, Suitable_Locations, that has a single argument—seating capacity. Suitable_Locations should print out the first three buildings and rooms whose seating capacity exceeds the specified seating capacity.
  2. Write a before-delete trigger on the Instructor table that will raise an exception if an instructor is scheduled to teach a class.

Page 326

Previous | Table of Contents | Next

Используются технологии uCoz