You are not required to complete any reports or forms for this test. Just create tables and normalize the database.
Your customer is a boat rental store on Lake Tomahawk that has decided to rent canoes, rafts, and kayaks and 16 ft fishing boats. You are to design a system that will keep track of customers and items to rent, and generate a transaction each time an item is rented.
As rental items are purchased, information must be entered into an inventory file that contains the following information: ID number, item description, item type (canoe, raft, kayak or boat), make, model, date purchased, the purchase price, number of times it has been rented, income from those rentals, the last time it was rented, and the customer who has the item.
A customer must sign up for rentals before they can rent their first item. Information we will store about each customer includes: customer number, last name, first name, phone number, address, city, state, zip code, the date we started them on the system, the last date they rented an item, the total income from their rentals, and the total number of items they have rented
When the customer makes a rental, you will produce an invoice for the transaction, save records that provide an audit trail of the transaction, and update necessary fields in the customer and inventory master files. We have several different prices for rentals, depending on the boat type, and the popularity of the item. Boats are rented for the current day only. It must be picked up and returned the same day. Each item is marked with a sticker so we know the price category at rental time. The prices for each category are stored in a table.
The following is an example of the invoice we may produce later. Allow only one item per invoice for now.
| Quality Boat Rentals | |||
|---|---|---|---|
| Invoice Number: 127 | Date Rented: 07/15/2007 | ||
| Customer Name: David Jones | Return Date: 07/15/2007 | ||
| Item Rented | Type | Rental Cost | Late Fee |
| Blue kayak03 | kayak | $35.95 | |
| Total Due: | $35.95 | ||