Question

Group Project Note: All documents should be prepared and presented in a professional manner, with a cover page showing the group number and the names of group members. Nothing should be hand written hand drawn Michiana Car Rentals Database System Michiana Car Rentals, Inc., headquartered in South Bend, IN, wants to build a database system which would track information customer billing. Usually, a customer picks up a car and then returns 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, 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 s 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. There may be other information needs of the car rental company. You are highly encouraged to come up with other possible uses for the database and incorporate them to your design. Note: You may start by thinking on the following issues that your final design may need to address. This is not an exhaustive list, of course. Which business functions will the database serve? What categories of data are to be stored in this database advantage? In what ways should the project give the company a competitive Minimum Requirements on the final application The final application must have data types and field properties Design: Database should be designed with the appropriate tables, Data: At least 15 records in each table should be entered.

Solve it in access

Answer 1