Pl/sql database homework questions | Computer Science homework help
ÿÿ
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?ÿ
ÿÿ
