Question: Part 3 Question: Using the KCT design shown below, code SQL statements for the following. KCT _CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone) KCT

Part 3 Question: Using the KCT design shown below, code SQL statements for the following.

KCT _CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone)

KCT _RENTAL(RentalID, RentalDate,NumberOfDays, RentalAmount, Deposit, Tax, TotalAmount, CustomerID, ReturnDate, AmountReturned)

KCT _LINEITEM(RentalID, CostumeID, Rate, Deposit)

KCT _COSTUMETYPE(TypeID, Description, Photo, DailyRentalRate, DepositRate, ReplacementCost)

KCT _COSTUME(CostumeID, Size, Availability, DatePurchased, CostumeType)

Question:

A. List the costumeID, size, and description (from COSTUMETYPE) for all costumes.

B. List the costumeID ,size and description for all costumes that have star wars in the description.

C. The same as above, but only include costumes that have been rented at least one time on a line item.

D. The same as above, but only include costumes that have been rented in the last 30 days.

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:

Part 2 Question: Using the KCT design shown below, code SQL statements for the following. KCT _CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone) KCT _RENTAL(RentalID,...

Q:

Using the KCT design shown below, code SQL statements for the following. KCT _CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone) KCT _RENTAL(RentalID, RentalDate,NumberOfDays,...

Q:

Databases CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone) RENTAL(RentalID, RentalDate,NumberOfDays, RentalAmount, Deposit, Tax, TotalAmount, CustomerID, ReturnDate,...

Q:

Databases Code SQL statements for the following: CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone) RENTAL(RentalID, RentalDate,NumberOfDays, RentalAmount, Deposit, Tax,...

Q:

PLEASE ONLY ANSWER IF YOU WILL ANSWER ALL QUESTIONS. ALL QUESTIONS ARE TOGETHER AND CANNOT BE SPLIT. [Q.3] Design and create a MusicStore" database for developing application for selling music files...

Q:

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

Q:

This question is from The Queen Anne Curiosity Case questions from Database Processing: Fundamentals, Design, and Implementation, 16th edition textbook. We have executed the following SQL CREATE...

Q:

HERE IS THE TINY VIDEO SCHEMA FOR MYSQL WORKBENCH /* Database Systems, 9th Ed., Coronel/MOrris/Rob */ /* Type of SQL : MySQL */ CREATE SCHEMA IF NOT EXISTS TINY_VIDEO; USE TINY_VIDEO; DROP TABLE IF...

Q:

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Q:

Required information Skip to question [The following information applies to the questions displayed below.] John and Sandy Ferguson got married eight years ago and have a seven-year-old daughter,...

Q:

Temperature indicators are sometimes produced from a coiled metal strip that uncoils a specific amount when the temperature increases. How does this work; from what kind of material would the...

Q:

Calculate E cell for the following half reaction: AgI(s) + e - Ag(s) + I 2 Reference the Ksp value for AgI and the standard reduction potential for Ag+.

Q:

Your estate tax burden can be reduced by giving gifts to your heirs prior to your death. This has the effect of reducing the value of your estate and thus lowering your tax obligation. As of 2 0 2 0...

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:

7. Determine what feedback is provided to employees.

Q:

3. Develop standards to evaluate positions (e.g., competencies, desired experiences, desired knowledge, developmental value).

Q:

5. Discuss what a trainer needs to do to ensure that school-to-work and hard-coreunemployed training programs are effective.