PL/SQL Database Homework questions

Case 2: Understand the More Movies database

Refer to the above ERD figure when answering the questions below for performing several queries on the data to become familiar with the “More Movies” database and to verify the content.

1. List the ID, title, category ID, and category name for      every movie in the database. What five categories are used for movies?
2. List the member ID, last name, and suspension code for      every member. Are any of the members suspended at this point?
3. List the member last name, rental checkout date, and      movie title for all rentals. What checkout data applies to all recorded      rentals?