CPSC340A
Database Systems

Activity 11

Constraints

  1. List tables that would be used in a movie database like IMDB.

  2. For the Movie table and Genre table, list some of the columns.

  3. For the Movie table with the columns Title, Release Date, and Genre, and Genre table with the column Genre Name, write SQL commands to create the tables. Be sure to include appropriate constraints.