ITM 111: Introduction to Databases

Activity: Movie Database Design and CRUD

This activity will help you design a database to store movie data. You will also create and populate the database.

Movie Database Design

  1. Study the movie data:

    Title Studio Media Type Year Released Genre Actors Special Features Rating Price
    Toy Story Pixar DVD 1995 Family, Animated Tom Hanks, Tim Allen, Annie Potts, John Ratzenberger bloopers G $19.95
    Toy Story 2 Pixar DVD 1999 Family, Animated Tim Allen, Tom Hanks, John Ratzenberger, Annie Potts actor interviews G $24.95
    Brigadoone MGM DVD 1954 Musical, Romance Gene Kelly, Cyd Charisse, Van Johnson G $19.95
    The Empire Strikes Back 20th Century Fox blu-ray 1977 Sci Fi Harrison Ford, Carrie Fisher, Mark Hamill cut scenes, bloopers PG $35.00
    Sample Movie Data

  2. Watch Movie Activity Part 1:

    The video mentions this as being a team activity. For our class it will be an individual activity. However, you are always encouraged to work with your team!
    .

    (1:28 mins, “Movie Activity Part 1” Transcript)

  3. Design an Entity Relationship Diagram to represent the data.

  4. Once you have completed an ERD, watch Movie Activity Part 2:

    .

    (10:19 mins, “Movie Activity Part 2” Transcript)

  5. You will need this information for Saturday's assignment.

Movie CRUD (Create Read Update Delete)

  1. Use the movie database you designed to practice creating a new database and tables, entering data into the tables, editing existing data, and then deleting the tables and database.

  2. Watch the Create, Update, Delete Practice video and follow along with your own code.

    (32:32 mins, “Create, Update, Delete Practice” Transcript)

  3. This practice with the C.U.D. part of CRUD commands will prepare you for the end-of-the-week assignment.

Submission

There is no submission for this activity.

Useful Links: