Your team is recruited as consultant to design a database to manage data for San Marcos Car Rentals. Initial
meeting with the General Manager and employees provided following information:
San Marcos Car Rentals (SCR) needs to maintain data about cars, employees, customers, and rental transactions.
Information about each car that needs to be maintained include the car ID, model, year, size, odometer mileage,
base daily rental charge, and vehicle identification number (VIN). Each car may be associated with many rental
transactions, or it may not have been rented yet (a new car). A customer could have rented a car more than once
from SCR; however, to be considered a customer, s/he should have rented a car at least once. Customer
information to be maintained includes the customer ID, first name, last name, street address, city, state, zip code,
birth date, driver license number and state, email, and phone number. Each car rental transaction is associated
with a car and a customer. For each rental transaction, information regarding the rental transaction number, rental
date, return date, mileage out, mileage in, actual daily rental charge, refuel charge, and total rental charge needs
to be maintained. Each rental transaction payment is paid by a credit card, and each credit card can be used to
make payment for one or more car rental transactions. For each credit card used for car rental payment, it is
necessary to maintain credit card ID, credit card number, expiration date, name on the credit card, and issuing
bank information. Each credit card is issued by a bank; however, a bank can issue one or more credit cards. For
each bank, it is necessary to maintain bank ID, bank name, bank contact first name, bank contact last name, and
bank phone. Each employee can process zero or many rental transactions, and each rental transaction may be
processed by more than one employee. It is necessary to maintain comments inputted by each employee for
transactions processed. For each employee, it is necessary to maintain employee ID, first name, last name, middle
name, gender, home street address, city, state, zip code, email, phone number, birth date, and salary. The car ID,
employee ID, customer ID, credit card ID, bank ID, and rental transaction number uniquely identify each car,
employee, customer, credit card, bank, and rental transaction, respectively.
Based on this information, create an Entity Class Diagram model for this business scenario to manage data for
San Marcos Car Rentals. Clearly show the entity classes, attributes, relationships between entity classes,
primary and foreign keys, and multiplicities (minimum and maximum). You may define surrogate keys and
additional attributes that may be needed for entity classes in the entity class diagram. Clearly list any
assumptions your team has made for the Entity Class Diagram model.