Question

In: Computer Science

Prestige Automobile Rental (PAR) is a vehicle rental company that rents old vehicles to the public....

Prestige Automobile Rental (PAR) is a vehicle rental company that rents old vehicles to the public. PAR has been using manual methods for keeping track of their customers and their rentals. However, the company would now like to go online and allow customers to search the available vehicles and see their rental history. For the first time, when the customer rents a vehicle from PAR their details (name, address, phone number, driving license number and credit card number) are recorded. The date they become a customer is also stored. There are certain types of vehicles which are classified as heavy vehicles. It is a policy of PAR that these vehicles are only rented to customers who have no demerit points on their driving license. The information about the vehicle (type, registration number, year/make/model, vin number, distance travelled and current condition) are also stored. Each vehicle has a unique ID. The customer can search for their desired vehicle and can see if it is available. All rentals are for 7 days. Rental charges are based on the type of vehicle (Car (C) or Heavy Duty (HD)). Rental must be paid for on collection. Customers can rent up to 2 vehicles at a time. Each rentalID is for a single vehicle for one customer. (The rentalID is an auto number). When the rental is taken out the date of checkout is recorded along with calculated due date (7 days from checkout date). When the rental is returned, the date is recorded in the returned date. PAR would like to store ‘demerit’ points for the renter in order to identify bad renters. These demerit points are accumulated at a rate of one point per day a rental is overdue. PAR will cancel the membership of the customers who have too many demerit points.

• Develop an Entity Relationship Diagram • Make a Relational Schema (including Primary, Foreign Keys and all attributes). • Provide Supplementary Design requirements (data attribute information)

Solutions

Expert Solution

According to the suggestion provided in the question,here is the Entity Relationship Diagram(ERD) of Prestige Automobile Rental(PAR):

Here is the all relational schemas:

Prestige Automobile Rental (PAR) is a vehicle rental company that rents old vehicles to the public. PAR has been using manual methods for keeping track of their customers and their rentals.It is a online system and allow users to search any kind and type of vehicle for rents.If any customer rent any vehicle for the first time then they have to submit their details according to the PAR policy and conditions and their data must be recorded in their database.There are different types of vehicle(Cars and Heavy duty) available for rents in this system and it is available for only 7 days and rental charges are based on vehicle type either it will bw Car(C) or Heavy Duty(HD).

Thank you!....


Related Solutions

The company rents vehicle and has contracts with customers that run from Sep to June. Customers...
The company rents vehicle and has contracts with customers that run from Sep to June. Customers pay the yearly fee in advance for the rentals. In September 2001, the company received $70,000 cash and recorded it as rental income. What is Dec 31,2001 year-end adjusting entries for this transaction under IFRS.
Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace...
Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace records its unique vehicle identification number (VIN), its “make” (manufacturer), model, year of manufacture, and the manufacturer’s factory in which it was made. Each factory is identified by the combination of its company name (i.e. manufacturer name) and the city in which it is located. We also know its size and the year it was built. Each manufacturer is identified by its unique name,...
Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace...
Consider Ace Rent-A-Car, a nationwide automobile rental company. For each car that the company owns, Ace records its unique vehicle identification number (VIN), its “make” (manufacturer), model, year of manufacture, and the manufacturer’s factory in which it was made. Each factory is identified by the combination of its company name (i.e. manufacturer name) and the city in which it is located. We also know its size and the year it was built. Each manufacturer is identified by its unique name,...
A small car rental company has a fleet of 94 vehicles distributed among its 10 agencies....
A small car rental company has a fleet of 94 vehicles distributed among its 10 agencies. The location of every agency is given by its geographical coordinates X and Y in a grid based on kilometers. We assume that the road distance between agencies is approximately 1.3 times the Euclidean distance (as the crow flies). The following table indicates the coordinates of all agencies, the number of cars required the next morning, and the stock of cars in the evening...
A small car rental company has a fleet of 94 vehicles distributed among its 10 agencies....
A small car rental company has a fleet of 94 vehicles distributed among its 10 agencies. The location of every agency is given by its geographical coordinates X and Y in a grid based on kilometers. We assume that the road distance between agencies is approximately 1.3 times the Euclidean distance (as the crow flies). The following table indicates the coordinates of all agencies, the number of cars required the next morning, and the stock of cars in the evening...
*****Show step-by-step in Excel****** An automobile rental company wants to predict the yearly maintenance expense (Y)...
*****Show step-by-step in Excel****** An automobile rental company wants to predict the yearly maintenance expense (Y) for an automobile using the number of miles driven during the year ( X1 ) and the age of the car ( X2 , in years) at the beginning of the year. The company has gathered the data on 10 automobiles and the regression information from Excel is presented below. Use this information to answer the following questions. Summary measures Multiple R 0.9689 R-Square...
Chris has decided to start a taxi company and has purchased seven passenger vehicles he is hired 15 drivers so that he can keep all the vehicles on the road at all times what are his options for the vehicle expense?
Chris has decided to start a taxi company and has purchased seven passenger vehicles he is hired 15 drivers so that he can keep all the vehicles on the road at all times what are his options for the vehicle expense?Chris can use SM or for up to four of the vehicles but he will have to use actual expense for the other three.Christmas use actual expense for all of the vehiclesChris can make a different decision for each vehicleChris...
Marvin Combs is 43 years old and is employed by a Canadian public company. His annual...
Marvin Combs is 43 years old and is employed by a Canadian public company. His annual salary is $82,468, none of which is commissions. Because of his outstanding work during 2017, he has been awarded a $20,000 bonus in 2017 that was paid on December 15, 2017. For 2017, his employer withheld the following: EI premiums                                        $836 CPP contributions                               $2,564 Federal Income Tax                           $26,000 Professional association dues           $3,400 Registered pension plan (RPP)        $6,800 Other Information:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT