Michiana Car Rentals Database System
Michiana Car Rentals, Inc., headquartered in South Bend, IN, wants to build a database system which would track information on car rentals, and customer billing. Usually, a customer picks up a car and then returns it after a period of time. When the car is returned, the customer receives an invoice and pays the specified amount.
Customers can rent out four types of cars from this rental company: compact, midsize, minivan, and SUV. The information that needs to be stored about any car includes (but not limited to): vehicle-id, make, model, price and availability. You may also want to note other features including but not limited to: DVD Entertainment system, XM Radio, or Navigation system.
At the time of checkout, the customer specifies a car type, the return date, and a credit card number, and the agent informs the customer of the appropriate rental rate. The rental rate consists of two parts – a daily rate, which is the charge per day a car is rented, and a mileage rate, which is the charge per mile a car is driven during the rental period. Both these parts may vary from one type of car to another or from car to car. The mileage on the car is noted at pickup, as well as on return. When the car is returned, an invoice is printed, which includes the invoice number, invoice date, and invoice amount. The customer must pay the full invoice amount on site.
Minimum Requirements for the final application
The final application must have –
Data: The database has been designed and ready for your use (K321OnlineProject.ACCDB). You need to understand this database and then start entering at least 10 records in each table.
• A form to enter new cars
• Multi-table form for check-in and check-out: A multi-table form to enter customer data as well as car rental data into the system. This single form can be opened by asking for the customer’s phone number for example and eventually help in entering data including customer information, car rental information (car ID, checkout mileage, check-in mileage, checkout date, and check-in date). This form can be opened during checkout and check-in and corresponding information could be entered. This form, conceptually, is similar to the one that you may have developed using a parameter query in the first case (AskNumber query based multi-table form).
• Current car information (A report that retrieves current car information including ids, make, model and availability). Remember to use parameter query so that you retrieve the specific type of car.
• Rental Invoice: An invoice report for individual transaction. Remember to use parameter query so that you retrieve the specific invoice.
• Revenue (Quarterly, Yearly, or any time period) : Revenue report to provide aggregated revenue for a specific time period. Remember to use parameter query so that you retrieve for the specific time period.
• Any additional reports that you may think appropriate for running this business.
• Remember in order to generate revenue report, current car information, and rental invoice; you will have to create quite a few queries. You will use these queries to generate a form or reports. Moreover, you will be creating various parameter queries so that you can retrieve specific information for various forms and reports.
• Any additional queries that are necessary to generate reports that you think are required to run this business.
Latest completed orders:
|#||Title||Academic Level||Subject Area||# of Pages||Paper Urgency|