Question: please i need ERD diagram for this case study: VFR Renting is a nationwide vehicle rent company that provides vehicles for customers to rent. A

please i need ERD diagram for this case study:

VFR Renting is a nationwide vehicle rent company that provides vehicles for customers to rent. A rent agreement between the company and the customer set out the terms of the rent such as the rent period, rent charges and the restrictions of use. Vehicles can be either cars or vans. Both have attributes make, model, year made, license plate no, cost, odometer, maximum speed and number of passengers. Information specific to car is car class (standard, luxury, executive) whereas for mini vans are no of seaters. Rental charge for car depends on the car model (Vios, MyVi, City and etc.) and rental period (daily, weekly, monthly) whereas rental charge for van depends on model (Hiace, Quest, Odyssey and etc.) and rental period same as car. VFR Renting has one depot and one rent point in every major city. Vehicles are stored at a depot unless they are on rent to customers. A rent point is a place where a customer collects and returns their rent vehicle. One rent point has access to several depots and each depot may supply vehicles to many rent points. Employees of VFR Renting work at either a depot or at a rent point. Depot employees are mainly employed preparing vehicles for rent which may involve repairing or maintaining vehicles. Rent point employees are mainly office staff involved with sales and marketing. Depot employees do not move but rent point employees frequently move from one rent point to another as demand for workers varies.

*please similar for this one if possible

please i need ERD diagram for this case study: VFR Renting is

VEHICLE MAKE MODEL VEHICLE TYPE MAKE PK vehicleMake vehicleType termines [PK vehicleMake VEHICLE MODEL CLASS VEHICLE TYPE MODEL PK ehcleMade ehicle Type ehcleOass det ehcleMakel hcleMadel VEHIKLE PK veficlePlate No year maxS peed naiPassenger #vetid eType ?ve hide:Model EMPLOYEE emplay eelD stars emplayeeName RENTAL AGREEMENT PK CITY OFFICE DEPOT ctyDepot ha agreementTerms ctRentPoint empl ayee ID works at vehiclePlateNa has rentChage RENT POINT CUSTOMER PcyRemPaint cust ornerlD hehcle Plate No cust Name custamerlD cust Address

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!