Accounting Information Systems 8th Edition by James Hall

Exercise 77

STRUCTURED QUERY LANGUAGE
A vehicle rental company has a database that includes the following tables and attributes within those tables:
Customer Table
Customer number (PK), customer name, customer address, customer phone number, customer credit card number
Inventory Table
Inventory number (PK), item description, item cost, item rental price, number of days for which an item can be rented
Rental Form Table
Rental Form number (PK), rental date, customer number (FK)
Rental Line Item Table
Rental Form number (PK), inventory number (PK), due date
Required
Using the SQL commands given in this chapter, write the code that would be necessary to generate a report of each customer with rented items that are past due. Customers can rent more than one item at a time, and items may have different rental periods, so this report should only include overdue items. (You may use the word today to signify the current date.)