Purchase Solution

Movie Rental Database: Oracle

Not what you're looking for?

Ask Custom Question

The purpose of this assignment is to review SQL language and to create a database for a fictional company called More Movie Rentals.

For this assignment, you will install Oracle Express and then create a database for More Movie Rentals.

Submit a single text or Microsoft Word document containing all of the commands you used and the answers you received when following the specifications from assignment requirements assign 1

please see attachments
Please follow the specifications below carefully:

1. List names of the tables that you have created whose name starts with MM. (Hint: use data dictionary view USER_TABLES). Use DESCRIBE (in short: DESC) command for each of these tables to show columns and their datatypes. Use SELECT * command to display all data from each of these tables. Make sure that the LINESIZE and PAGESIZE have large enough values and that you format columns so that the report looks good. If you are using a word-processing software to prepare your lab, make sure that you use a font with constant character width, such as Courier New, to ensure that data is displayed in neat columns.
2. List all movie categories together with the count of movies in each category.
3. List titles and checkout dates for all movies that were signed out by Wild Coyotee (MEMBER_ID=13).
4. List all movie ids and titles that have never been rented.
5. List all members (member id, first name and last name) that have rented at least one movie.
6. What was the largest number of movies rented by one member?
7. Display member id, last name, first name, and the number of movies rented for each member.
8. Prepare a report that shows who rented which movie. Use member names (first and last) and movie title rather than the corresponding ids. Order the report by member names, and for a single member by the movie titles.

Purchase this Solution

Solution Summary

This solution deals with the Movie Rental Database and answers a set of SQL queries using Oracle.

Purchase this Solution


Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Javscript Basics

Quiz on basics of javascript programming language.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.