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

Databases

Code SQL statements for the following:

CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone)

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

LINEITEM(RentalID, CostumeID, Rate, Deposit)

COSTUMETYPE(TypeID, Description, Photo, DailyRentalRate, DepositRate, ReplacementCost)

COSTUME(CostumeID, Size, Availability, DatePurchased, CostumeType)

Using the tables, write the SQL code to represent each of the following transactions. Use Start Transaction and Commit to group the SQL statements into logical transactions.

A. Show the complete transaction for adding two new star wars: Ewok costumes on October 30, 2017 to your database, one size large, and one size small. Both of these costumes are now available for rental. Be sure to add the costumetype as part of this transaction.

B. Show the complete transaction for one of your customers placing a rental on October 31, 2017 for the two new costumes added in A.

C. Create a simple transaction log to represent the actions of the two previous transactions

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!

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,...

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,...

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,...

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

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

Create a table for reservations. Store the customer ID, reservation start date, reservation end date, and a costume ID. Create and test a stored procedure to create a reservation. Assume that the...

It is surprisingly easy to create a market-basket report using table data in Access. To do so, however, you will need to enter SQL expressions into the Access query builder. Here, you can just copy...

JF Outz, MD, has been a cardiologist for three years. During April 2018, Outz completed the following transactions in his cardiology practice: Apr. 1. He paid rent for the office in April, $800. 3....

List the empnames that do not end with s. EMPNO ENAME 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN 7698 BLAKE 7782 CLARK 7788 SCOTT 7839 KING 7844 TURNER 7876 ADAMS 7900 JAMES 7902 FORD...

Which of the following has been referred to as being as much a form of aid as of finance? Foreign direct investment Sovereign lending Concessional finance Portfolio investment

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

2 What do you think are the main logistics challenges in running the Tesco operation? Tesco is the UKs largest food retailer, with a sales turnover of more than 67.5 billion. While it has some 638...

What is digital literacy? Why is it necessary?

Explain allyship training? How can allyship training contribute to companies efforts toward diversity, equity, and inclusion?