Question: 3. Given your relational schema, provide the SQL to perform the following queries. If your schema cannot provide answers to these queries, revise your ER

3. Given your relational schema, provide the SQL to perform the following queries. If your schema cannot provide

answers to these queries, revise your ER Model and your relational schema to contain the appropriate

information for these queries. These queries should be provided in a plain text file named

WorksheetTwoSimpleQueries.txt:

a.

Find the titles of all tracks by ARTIST released before YEAR

b. Give all the movies and their date of their checkout from a single patron (you choose how to designate

the patron)

c.

List all the albums and their unique identifiers with less than 2 copies held by the library.

d. Give all the patrons who checked out a movie by ACTOR and the movies they checked out.

e. Find the total number of albums checked out by a single patron (you choose how to designate the

patron)

f.

Find the patron who has checked out the most videos and the total number of videos they have checked

out.

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:

Assignment Questions (Submission required, 50 points) Problem 1 (25 points) You have been hired to develop a database system for an online ordering system. In this database, you want to store...

Q:

Dp Implement the COMPANY database as defined in the schema given in Figure 6.1 on page 181 of the Elmarsi/Navathe text sixth edition. A. (15 points) You need to implement the database using MySQL...

Q:

Case Description: FAME (Forondo Artist Management Excellence) Inc. is an artist management company that represents classical music artists (only soloists) both nationally and internationally. FAME...

Q:

SQL Question: The question requires an ER design, a conversion from an ER schema to a relational schema, and the sql code to create a database from the information. EXERCISE # 1: E-R DESIGN - Design...

Q:

Note: You can work on the SQL Server to write the below questions SQL Query. 1. Suppose you have a database modeling a mobile riding platform somewhat similar to Uber, which is given by the following...

Q:

MYSQL 1. Suppose you have a database modeling a mobile riding platform somewhat similar to Uber, which is given by the following schema: PASSENGER (pid, pname, city, phone) DRIVER (did, dname, city,...

Q:

Project Specification: 1. Part A: Entity Relationship Diagram 1. Your first task is to study the Case study requirements and gather as much knowledge to list all the main Entities and attributes. 2....

Q:

Individual Final Project Assignment Funky Bizz: Funky Bizz is a rental business that rents musical instruments to bands. Create the ER diagram for the Funky Bizz Operations Database, based on the...

Q:

Snooty Fashions Snooty Fashions is an exclusive custom fashion designer business. Below are the Requirements of Snooty Fashions. The Snooty Fashions Operations Database will keep track of the...

Q:

7.Provide the SSN and the income of every author, as well as the name of the publisher that the author works for if he/she is also an editor. (15 pts) 8.Provide the title of the book that is the...

Q:

Consider the closed-loop system in Figure CP4.9, whose transfer function is (a) Obtain the closed-loop transfer function T(s) = Y(s)/R(s) and the unit step response; that is, let R(s) = l/s and...

Q:

a. If a riflemans gunsight is adjusted correctly but he has shaky arms, the bullets might be scattered widely around the bulls-eye target. Draw a sketch of the target with the bullet holes. Does this...

Q:

A corporation paid cash dividends totaling $ 7 5 , 0 0 0 during the most recent physical year. How should this information be reported on the statement of cash flow?

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

What are some of the characteristics of the past management practices and organizational climate that are thwarting creativity?

Q:

What tools might be helpful?

Q:

What are some measures that you can take to begin to foster creativity in the individuals you work with and in your unit as a whole?