Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are tasked with developing an ER diagram for a car rental company. Consider the following details: ( draw an ER diagram ) Entities and
You are tasked with developing an ER diagram for a car rental company. Consider the
following details: draw an ER diagram
Entities and Attributes:
Vehicle
ID
Type
Brand
Color
Year
Plates Number: one car can have one or more plate numbers
Customer
ID
Phone Number
Email: one customer can have multiple emails
Age
Rental History: Rental Date, Price, Accident Occurrence
Rental Branch
Branch ID
City
Capacity
Insurance
Insurance ID
Start Date
End Date
Coverages
Vehicle Review Report
Report ID
Accident Counts
Relationships:
A customer can rent zero or more vehicles, and one vehicle can be rented by
multiple customers.
A customer can buy zero or more insurances while renting a vehicle, and a vehicle
can be covered by multiple insurances while being rented.
A customer can rent one or more vehicle. For each rental, a customer can buy zero
or more insurances.
A vehicle can belong to only one rental branch, while a rental branch can have
many vehicles.
A vehicle can have zero or more review reports, while a review report can only
belong to one vehicle.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started