Database, Excel, and Access Usage. . No Handwritten work, please. Guaranteed Upvote. Thank you.

Explanation Context: I am a chemistry major that had a free elective. So I am not too familiar with some terms.

Instructions

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 the 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 weeks worth of rental activity. Sunday to Saturday inclusive. Everyones data will be different of course.

Minimum task. Please feel free to keep your answer simmple to save you time.

- 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. The 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 managers 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 the amount that is accumulating (outstanding cars that are currently out on rent). Your 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%)

Assumptions to assist you.

- 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)

-ompact 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.

Simulation Tip. (But i dont think you experts need this). :)

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.

What I would like to learn from.

1) A data dictionary.

2. A relational schema from Access (with cardinalitie

3. A screenshot of each table in your Access database

4. A data form for entering the rental contracts created in Access

5. An example rental contract generated from Access

6. The managers weekly revenue report from Access