Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Instructions In this assignment you are required to create a database from scratch in MS Access for ACME car rental company using your own phantom data

Instructions In this assignment you are required to create a database from scratch in MS Access for ACME car rental company using your own phantom data

MS Access

Instructions

In this assignment you are required to create a database from scratch in MS Access for ACME car rental company using your own phantom data. It can be as elaborate and imaginative as you like but the simpler the better for you.

Customers rent vehicles from ACME for at least one day. For each day the customer keeps a vehicle, they are charged a rental fee in accordance with the type of vehicle they rent. There are four types of vehicles: compact ($50/day), midsize ($75/day), premium ($100/day) and, SUV ($100/day). Each vehicle has a year make, model, and VIN#. There are a total of 20 cars in the inventory (5 of each type). Upon return the customer is charged an amount for their rental – that money then becomes paid revenue. Assume that once a car is returned, it can be rented out immediately without delay.

ACME has two employees who serve as rental reps. Each rental rep creates a rental contract for each car they rent out and is paid a 20% bonus if they sell a damage waiver in each contract. Damage waiver is $10 a day for compact and midsize cars and $20 a day for premium and SUV cars. 

Your task is to create a database for ACME car rental company. Your database should allow ACME to keep track of its vehicles and the revenue generated from rental contracts.

You will use your own simulated data to show a week’s worth of rental activity. Sunday to Saturday inclusive. Everyone’s data will be different of course.

At minimum, your answer should have/allow you to do the following:

  • A relational schema
  • A data dictionary
  • At least four distinct realistic entity classes e.g. a vehicle entity class should have details such as make model year color seating capacity. Customer should have last name, first name, DL#  etc.
  • Allow rental reps to generate new contracts 10 points
  • Print and store rental contracts
  • Generate a receipt at the end of each rental contract.
  • Keep track of your inventory i.e. know how many cars you have on hand to rent
  • Determine how much the rental rep gets for a weekly bonus.
  • Generate a weekly manager’s report to show how much revenue has been accrued from rentals (including damage waiver). The average rental percentage rate for each vehicle i.e. what percent of the week has the car been rented. You should show the amount actually paid and amount that is accumulating (outstanding – cars that are currently out on rent). You report should also show pertinent aggregate amounts think should be of interest
    • Note that ACME keeps 80% of the money from damage waiver - the rental rep gets 20%

Some key assumptions you must make.

  • Rental Rep 1 – sells damage waiver ~ 30% of the time  
  • Rental Rep 2 – sells damage waiver ~ 50% of the time 
  • SUVS are rented 100% of the time. – 2 are rented out for the whole week, 2 are rented out for 3 days and then 4 days to different customers. You can choose any configuration of days that satisfies this condition.
  • Premium cars are rented out 95% of the time – At least one premium car must be rented out for more than the week. At least one must be rented out for four days and at least 2 must be rented out for a 2 day period. (These can be rented out gain – your choice)
  • Compact and midsize cars are rented out ~ 80% of the time. Vary the number of days the cars are rented out. There is no requirement as to how you may choose to do this. Everyone will have a different answer for this.

Tip for simulating data:

You should create your own phantom data in excel and import it into Access. Hint: You can use a random number generator in Excel to simulate data. However, this not a requirement. You can create the data however you wish.

 

WHATS NEEDED-

  1. A complete data dictionary (created in Excel) See chapter 11 or 12 slides for an example 50 points
  2. A relational schema from Access (with cardinalities) 30 points
  3. A screenshot of each table in your Access database 20 points
  4. A data form for entering the rental contracts created in Access 40 points
  5. An example rental contract generated from Access 30 points
  6. The manager’s weekly revenue report from Access 30 points

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE