Uncategorized
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.
- List the ID, title, category ID, and category name for every movie in the database. What five categories are used for movies?
- List the member ID, last name, and suspension code for every member. Are any of the members suspended at this point?
- List the member last name, rental checkout date, and movie title for all rentals. What checkout data applies to all recorded rentals?