Michiana Car Rentals, Inc., headquartered in South Bend, IN, wants to build a database system which...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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? In what ways should the project give the company a competitive advantage? Minimum Requirements on the final application The final application must have - Design: Database should be designed with the appropriate tables, data types and field properties. Data: At least 15 records in each table should be entered. Forms: 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). Reports: • 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. Requirements for final report You are required to submit a four page (muximum), single line spacing, and 12" font size report. The report should include following things: 1. System manual: You should clearly mention how does your system work? This will be a user manual where as a database designer you explain a layman about how to work on this rental system. 2. Assumptions or business rules: You want to specify your assumptions or business rules that you have considered in your database design. Deliverables: Please check the syllabus to make sure that your project progress is on track. I will frequently check with the group about the progress of the project. Grading: Minimum requirements - The system should be capable enough to meet basic need including checking vehicles out and checking vehicles in. System should have all necessary forms, reports, and queries. Meeting minimum requirements will get you an average grade in this class. I will take peer evaluations and free riding is not acceptable. 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. 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? In what ways should the project give the company a competitive advantage? Minimum Requirements on the final application The final application must have - Design: Database should be designed with the appropriate tables, data types and field properties. Data: At least 15 records in each table should be entered. Forms: 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). Reports: • 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. Requirements for final report You are required to submit a four page (muximum), single line spacing, and 12" font size report. The report should include following things: 1. System manual: You should clearly mention how does your system work? This will be a user manual where as a database designer you explain a layman about how to work on this rental system. 2. Assumptions or business rules: You want to specify your assumptions or business rules that you have considered in your database design. Deliverables: Please check the syllabus to make sure that your project progress is on track. I will frequently check with the group about the progress of the project. Grading: Minimum requirements - The system should be capable enough to meet basic need including checking vehicles out and checking vehicles in. System should have all necessary forms, reports, and queries. Meeting minimum requirements will get you an average grade in this class. I will take peer evaluations and free riding is not acceptable.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
An athletic team wants to build a new sports arena in the middle of the downtown area. The team has bought enough land for the stadium, but needs more land to build an adjacent parking lot. The team...
-
An analyst wants to build a regression model to predict spending from the following four predictor variables: Past Spending, Income, Net Worth and Age. A correlation matrix of the four predictors...
-
The Federal Parcel Service wants to build a new distribution center in Charlotte, North Carolina. The center needs to be in the vicinity of uncongested Interstate-77 and Interstate-85 interchanges,...
-
In Rev. Rul. 81-301, which of the following is not a factor considered by the IRS in determining whether a partner receives payments in her capacity as a partner, or is instead acting as a third...
-
a. What is meant by the term tax haven? b. What are the desired characteristics for a country if it expects to be used as a tax haven? c. What are the advantages leading an MNE to use a tax haven...
-
Refer to Exercise 16.1. Assume that we collected additional data and had two more participants in the Younger group with scores of 13 and 15. a) Rerun the analysis of variance. b) Run an independent...
-
Mega Millions is a multistate lottery in which players try to guess the numbers that will turn up in a drawing of numbered balls. One of the balls drawn is the Mega Ball. Matching the number drawn on...
-
You were recently approached by one of your clients, Wendy Wonders, the Chief Financial Officer of Rock Group Limited ( RGL), a Canadian public company with a 31 December year- end. RGL manufactures...
-
Cowboy Recording Studio is considering the investment of $138,600 in a new recording equipment. It is estimated that the new equipment will generate additional cash flow of $20,500 per year for each...
-
At April 30, partners capital balances in YBG Company are: Younger $30,000, Beyer $16,000, and Giger $10,000. The income-sharing ratios are 5:3:2, respectively. On May 1, the YBGE Company is formed...
-
The table below gives the Lennard-Jones parameters for some different substances. He Ne H2 O2 N2 CH4 CO2 Cl2 [nm] 0.26 0.28 0.30 0.43 0.37 0.38 0.40 0.41 [1022 J] 1.41 4.93 4.60 15.6 12.6 18.9 26.2...
-
As shown in the figure, a ball with a mass of 1.020 g and positive charge of q=44.0 C is suspended on a string of negligible mass in a uniform electric field. 9 48 mg Uniform E-field We observe that...
-
Simplify. (-x) (3xy=)
-
With a real business, except the details I am providing are mostly thypothetical. Butter Chicken Roti, www.butterchickenroti.com has one of their early locations across the street from the main...
-
2- Randolph and Tammy own a second home. They spent 45 days there and rented it for 88 days at $150 per day during the year. The total costs relating to the home include the following: Mortgage...
-
x(t) Find z(t) where x(t)=2 sinc(2t) and y(t) = cos(27) X y(t) z(t)
-
Reflect on your own experiences working in a group, and set personal goals for the group project. What kinds of roles have you previously taken? Were these roles discussed and agreed upon, assigned,...
-
Why is the national security argument for tariffs questionable?
-
For the cash flows shown, determine the incremental cash flow between machines B and A (a) In year 0, (b) in year 3, (c) in year 6. Machine First cost, $ AOC, $ per year A -15,000 -25,000 -1,600...
-
Determine i* per year for the cash flows shown using factors and the IRR function. See Problem 7.55 for additional spreadsheet work with this series. 3 2 Year Cash Flow, $ 0 -80,000 9000 70,000 30,000
-
For the cash flows below determine the amount in year 1, if the annual worth in years 1 through 9 is $3500 and the interest rate is 10% per year. 1 2 4 5 6 7 3 Year Cost, A A+40A+80A+120 A+160 A+200...
-
Examine the flowchart for purchases and do the following: a. Identify the sections of the flowchart and for each section write an accompanying narrative of the document flows. b. Supply answers and...
-
Examine the flowchart for payroll shown and do the following: a. Identify the sections of the flowchart and for each section write an accompanying narrative of the document flows (use pages...
-
In 19X4 XY Company purchased more than \(\$ 10\) million of office equipment under its "special" ordering system, with individual orders ranging from \(\$ 5,000\) to \(\$ 30,000\). "Special" orders...
Study smarter with the SolutionInn App