Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

Students also viewed these Databases questions