Question: please can anyone help me with assignment?? I really need a help.. Thx Case Study VFR Renting is a nationwide vehicle rent company that provides
please can anyone help me with assignment?? I really need a help.. Thx
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 rent point is a place where a customer collects and returns their rent vehicle. One rent .Employees of VFR Renting work at either a depot or at a rent point. Depot employees are a depot unless they are on rent to customers point has access to several depots and each depot may supply vehicles to many rent points 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 Note: You need to justify any additional assumption that you introduce 1)Develop an E/R diagram using Crow Foot notation that you learn in the course for the case study described above. Make sure to indicate all cardinality constraints specified above. The E/R diagram should not contain redundant entity sets, relationships, or attributes. Also, use relationships whenever appropri advanced modeling techniques (EER diagram) ate. You will be expected to use 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 rent point is a place where a customer collects and returns their rent vehicle. One rent .Employees of VFR Renting work at either a depot or at a rent point. Depot employees are a depot unless they are on rent to customers point has access to several depots and each depot may supply vehicles to many rent points 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 Note: You need to justify any additional assumption that you introduce 1)Develop an E/R diagram using Crow Foot notation that you learn in the course for the case study described above. Make sure to indicate all cardinality constraints specified above. The E/R diagram should not contain redundant entity sets, relationships, or attributes. Also, use relationships whenever appropri advanced modeling techniques (EER diagram) ate. You will be expected to use
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
