K321 project

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, license plate number, make, model, price, and current mileage. 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. 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.

Habilidades: Microsoft Access

Veja mais: xm-radio, xm radio, which car rental, vehicle rentals, vehicle rental company, vehicle on rent, to rent cars, site rent a car, rent vehicle, rent to cars, rent the car, rent rental car, rent on car, rent of cars, rent of car, rent it car, rent car site, rent cars in, rent cars, rent car rentals, rent car in, rent car company, rent at car, rent as car, rent a rental car

Acerca do Empregador:
( 0 comentários ) South Bend, United States

ID do Projeto: #5125465

1 freelancer está oferecendo em média $190 para esse trabalho


Hired by the Employer

$190 USD in 100 dias
(13 Comentários)