Draw the Entity Relationship Diagram (ERD) with the labels. BUSINESS CASE STUDY 5- CAR RENTAL MANAGEMENT SYSTEM

Draw the Entity Relationship Diagram (ERD) with the labels.
 

Transcribed Image Text:

BUSINESS CASE STUDY 5- CAR RENTAL MANAGEMENT SYSTEM Diamond Car Rental wants to expand its business and venture into the car rental industry. To streamline operations and enhance the customer experience, the company plans to create a car rental management database. The database will store customer details, including customer ID, name, address, phone number, and email address. Each customer can rent multiple cars, and each rental is associated with one customer. In addition, Diamond Car Rental wants to keep track of the car inventory. The database will include information about each car, such as car ID, make, model, year, and rental price per day. Each car can be rented by multiple customers, and each rental is associated with one car. The company also needs to manage rental transactions. Rental details will be recorded, including rental ID, pickup/drop-off location, rental start and end date and time, and total rental cost. Each rental is associated with one transaction, and each transaction is associated with one rental. To ensure the smooth operation of the business, Diamond Car Rental will assign employees to handle car rentals. Employee details will be recorded, including employee ID, name, address, phone number, and email address. Rentals will be assigned to employees and recorded in rental assignments. Each rental assignment will include an assignment ID, assignment date and time, and status. Each employee can handle multiple rental assignments, and each rental assignment is assigned to one employee. Each rental is associated with one or more rental assignments, allowing Diamond Car Rental to track the staff responsible for each rental. By implementing this car rental management database, Diamond Car Rental can efficiently manage customer information, track car inventory, monitor rental transactions, and assign employees to rentals. Additionally, the database provides valuable insights into customer preferences, rental history, and staff performance, enabling the company to make informed decisions regarding pricing, car availability, employee scheduling, and business expansion. This database empowers Diamond Car Rental to provide a seamless and personalized car rental experience for its customers while optimizing its operations. BUSINESS CASE STUDY 5- CAR RENTAL MANAGEMENT SYSTEM Diamond Car Rental wants to expand its business and venture into the car rental industry. To streamline operations and enhance the customer experience, the company plans to create a car rental management database. The database will store customer details, including customer ID, name, address, phone number, and email address. Each customer can rent multiple cars, and each rental is associated with one customer. In addition, Diamond Car Rental wants to keep track of the car inventory. The database will include information about each car, such as car ID, make, model, year, and rental price per day. Each car can be rented by multiple customers, and each rental is associated with one car. The company also needs to manage rental transactions. Rental details will be recorded, including rental ID, pickup/drop-off location, rental start and end date and time, and total rental cost. Each rental is associated with one transaction, and each transaction is associated with one rental. To ensure the smooth operation of the business, Diamond Car Rental will assign employees to handle car rentals. Employee details will be recorded, including employee ID, name, address, phone number, and email address. Rentals will be assigned to employees and recorded in rental assignments. Each rental assignment will include an assignment ID, assignment date and time, and status. Each employee can handle multiple rental assignments, and each rental assignment is assigned to one employee. Each rental is associated with one or more rental assignments, allowing Diamond Car Rental to track the staff responsible for each rental. By implementing this car rental management database, Diamond Car Rental can efficiently manage customer information, track car inventory, monitor rental transactions, and assign employees to rentals. Additionally, the database provides valuable insights into customer preferences, rental history, and staff performance, enabling the company to make informed decisions regarding pricing, car availability, employee scheduling, and business expansion. This database empowers Diamond Car Rental to provide a seamless and personalized car rental experience for its customers while optimizing its operations.