Develop a data model using Chen EERD that meets the requirements for a simplified car rental

application

Data Requirements for the iRent My Vehicle Application

Overview: This application will allow owners of vehicles to rent their vehicle out to earn revenue when

their car is not needed or used frequently. By creating a pool of vehicles available for rent, the

application will have the potential to provide more affordable rental alternatives compared to

commercial companies. Requirements have been greatly simplified to reduce the complexity for this

portion of the assignment.

Requirements Checklist

User

o Users of the system can register a single account which allows them to act as a renter $($the person who offers a vehicle for rent$)$ or a lessee $($the

person who rents the vehicle$).$ Each user has a username, first, last, and email address. Records for renters include an insurance policy number

and insurance company name while lessees must provide a driver$$s license number and license expiry date.

Vehicle

o Each vehicle is described by the following attributes: A vehicle number $($unique$,$ assigned by the system$),$ a plate number, the make $($e$.$g$.,$ Honda$),$

and model $($e$.$g$.,$ Civic$).$

o The system supports different types of vehicles including motorcycles, regular passenger cars, trucks, and recreational vehicles $($e$.$g$.,$ motor

homes$).$ Unique attributes are kept for motorcycles, trucks, and recreational vehicles as follows:

o For motorcycles we record the recommended minimum height of the rider.

o For trucks, we record the towing capacity $($how much weight can be pulled$).$

o For RVs we record how many people can sleep in it$.$

Rental Agreement

o A rental agreement is identified by a unique agreement number and includes the start date and end date of the rental and the fee charged.

o Only one vehicle can be rented for each agreement. A vehicle may be rented several times over the course of time.

o Each rental agreement must identify one renter and one lessee. Over time, renters and lessees can participate in many agreements.

Payments$/$Refunds

o Our application recognizes different types of payments. A reservation deposit $($to reserve a vehicle$),$ a damage deposit, a refund, and a normal

rental payment. Each payment or refund is identified by a unique transaction ID$.$ We also record the date of the transaction and the method of

payment used.

o Each transaction must relate to a single rental agreement. A rental agreement may incur many transactions