
12. Members of a consulting firm rent cars from two rental agencies: 60 % of the...
Design an E/R diagram to model the following information about cars, rental agencies, and drivers. Drivers reserve cars from rental agencies. A car is uniquely distinguished by its VIN number, and has a model name and color. A rental agency is uniquely distinguished by its name, and has an address. A driver is uniquely distinguished by his/her SSN, and has a name, address, license registration number, and age. A driver can reserve any number of cars, and each of these...
Rent-A-Jalopy rents cars in N, NY, and PA. Some times cars are picked up and returned in the same state. Other times the cars are picked up in one state and returned in another. · Of the cars rented in NJ, 50% are returned to NJ, 15% are returned to NY, and 35% are returned to locations in PA. · Of the cars rented in NY, 20% are returned to NJ, 60% are returned to NY, and 20% are returned...
12. Maximum Revenue) A car-rental agency can rent 100 cars per day at a rate of $40 per day For each price increase of $1 per day, 2 less cars are rented. What rate should be charged to maximize the revenue of the agency?
A car rental agency has 13 midsized and 12 compact cars on its lot, from which 6 will be selected. Assuming that each car is equally likely to be selected and the cars are selected at random, determine the probability that the cars selected consist of all midsized cars.
Sundown Rent-a-Car, a large automobile rental agency operating in the Midwest, is preparing a leasing strategy for the next six months. Sundown leases cars from an automobile manufacturer and then rents them to the public on a daily basis. A forecast of the demand for Sundown’s cars in the next six months follows:MONTH MARCH APRIL MAY JUNE JULY AUGUSTDemand 420 400 430 460 470 440Cars may be leased from the manufacturer for either three, four, or five months. These are...
Peter applied for a job at an accounting firm and a consulting firm. He knows that 50% of similarly qualified applicants receive job offers from the accounting firm; only 40% of similarly qualified applicants receive job offers from the consulting firm Peter also knows that 60% of similarly qualified applicants receive an offer from one firm or the other. Hints: A=accounting firm offer, B=consulting firm offer What is the probability of an offer from the accounting firm if the consulting...
ntro You currently don't have a car, but rent a car that's parked just outside your house whenever you need one. Your annual expenditure on rental cars is $2,300. You've now considering purchasing a car that would give you the same level of convenience as your current life style. The car costs $25,000 and can be sold for $5,000 after 10 years. You'd purchase the car with money from your savings account which always earns an interest rate of 6%...
Zipcar: “It’s Not About Cars—It’s About Urban Life” Imagine a world in which no one owns a car. Cars would still exist, but rather than owning cars, people would just share them. Sounds crazy, right? But Scott Griffith, CEO of Zipcar, the world’s largest car-share company, paints a picture of just such an imaginary world. And he has nearly 800,000 passionate customers—or Zipsters, as they are called—who will back him up. Zipcar specializes in renting out cars by the hour...
Answer using SQL statements
1)All information about rental with longest rental period.
Rental period in days must appear.
2)How much money earned from rental by car manufacturer’s
country every year.
3)Show 20% of our best customers by total income.
4)Show customers who used our rental 2 or more times and
customer’s average money spending less than average rental
price;
5)Show customer count by each state (for state show 2 letters
abbreviation). Results sort by customer count descending order then
by...
Hi I need help creating a program in JAVA. This is material from chapter 9 Objects and Classes from the Intro to JAVA textbook. Mrs. Quackenbush's Rent-A-Wreck car rental ..... Mrs. Q asked you to create a program that can help her track her growing fleet of junkers. Of course she expects you to use your best programming skills, including: 1. Plan and design what attributes/actions an automobile in a rental fleet should have (example. Track number of Trucks, SUVs,...