#### In-Class Exercises

# In-Class Exercise #5: Getting Information Out of a Database (SQL Out)

Here is the exercise. And here is the movie rental schema you’ll need to do the exercise.

Here is the solution.

# In-Class Exercise #4: Pen and Paper Query Exercise

Here is the exercise.

And here is the answer key.

# In-Class Exercise #3: Creating Schemas

Here is the exercise.

And here is the solution.

# In-Class Exercise #2: ER Modeling

Here is the exercise.

And here is the solution.

# In-Class Exercise #1: Identifying Entities

Here is the exercise.

And here is the answer key.