CIT 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

    Movie database data
    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: