(11) Give an example of three entity types and accompanying attributes that might be associated with a database for a car rental agency?

QUESTION:

Give an example of three entity types and accompanying attributes that might be associated with a database for a car rental agency?

 

[signinlocker]

SOLUTION

VEHICLE (VehicleID, LicensePlate#, Make, Model, Year, Mileage, …)

RENTER (License#, Name, Address, City, State, Zipcode, Insurance, etc.)

VEHICLE_RENTAL (VehicleID, License#, Dateout, Datein, Mileageout, Mileagein)

[/signinlocker]

Leave a Reply

Your email address will not be published. Required fields are marked *