Question: The Student database has the following Relation Schema: PRICE (Code, Description, RentFee, DailyFee) MOVIE (MovieNo, Title, Year, Cost, Genre, Code ) VIDEO (VideoNo, InDate, MovieNo

  1. The Student database has the following Relation Schema:
  • PRICE (Code, Description, RentFee, DailyFee)
  • MOVIE (MovieNo, Title, Year, Cost, Genre, Code)\
  • VIDEO (VideoNo, InDate, MovieNo)
  • DETAILRENTAL (RentNo, VideoNo, Fee, DueDate, ReturnDate, DailyFee)
  • MEMBERSHIP (MemberID, Name, City, State, Balance)
  • RENTAL (RentNo, Date, MemberID)

Using the above schema, write SQL queries that will answer/process the following:

  1. Find the movies which cost more than the average movie cost. Show movie title, year and cost. Append the dollar sign ($) at the beginning of the movie cost. (2 marks)

  1. Find the price type which has the maximum number of movies. Show price code, price description and the number of movies of that type. (2 marks)

  1. View to show all the members and movies they rented. Show movie title, dates of rent, due and return. (4 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

The Student database has the following Relation Schema: PRICE (Code, Description, RentFee, DailyFee) MOVIE (MovieNo, Title, Year, Cost, Genre, Code )\ VIDEO (VideoNo, InDate, MovieNo ) DETAILRENTAL (...

Q:

Time Attem 48 M Question 7 10 pts ZAGI DB: Which line could be added to the SQL statement that follows such that it would return the number of products and average product price for each vendor?...

Q:

Please help with the following: Write the SQL code to create the table structures for the entities shown in Figure 1. The structures should contain the attributes specified in the ERD. Use data types...

Q:

I need a formal written description of the tables and relationships between the tables as well as a list of any additional assumptions. I need the relational schema for the various forms. Blockbuster...

Q:

The following tables provide a very small portion of the data that will be kept in the database. This data needs to be inserted into the database for testing purposes. Write the INSERT commands...

Q:

can anyone build a student data base file using python and the information on the photo below The main objective of this assignment is to design and implement A Student Assessment database software...

Q:

Please help by showing me how this program is done in c. The beginning of Student_records.h is shown. Your task is to create student database. The header file student_record.h should contain: all...

Q:

Question: Prepare a portfolio of flow diagrams for the business case based on the three current state "as is" processes and the two future state "to be" processes and what are the main difference...

Q:

Business Case Transition to College This case study will analyze the current business processes of Transition to College (TC), a pre-college preparatory program for new students at an Ontario...

Q:

This programming project involves writing a program to manage a student database. The interface to the program should be a GUI that looks similar to the following: A combo box should allow the user...

Q:

Jabu is a partner in a partnership. During the 2019 year of assessment, he received a salary of R860 000 from the partnership. His share of the partnership profit for the year was R500 000. During...

Q:

During the current year, merchandise is sold for $17,500 cash and $141,750 on account. The cost of the merchandise sold is $127,400. What is the amount of the gross profit?

Q:

A $ 5 0 0 , 0 0 0 bond lssue sold for $ 5 1 0 , 0 0 0 . Therefore, the bonds sold: Mitiple Choke at a dircount because the shated interest rate was higher than the market rate. for the $ 5 0 0 . 0 0...

Q:

Using the reagents below, list in order (by letter, no period) those necessary to transform toluene into. Youmay assume any undesired regioisomers can be separated. Note: Not all spaces provided may...

Q:

How are custom calculations developed that will refer back to columns in the Pivot Table on the same Excel worksheet?

Q:

What do the Length of Service and Length of Service Earnings Quotients indicate with reference to Female versus Male Wage and Job Progression in respect to Length of Service?

Q:

How do Excel Pivot Tables handle data from non OLAP databases?