Car Rental System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Rental System Entity. The entity-relationship diagram of Car Rental System shows all the visual instrument of database tables and the relations between Booking, Car Routes, Cars, ##keyword6## etc. It used structure data and to define the relationships between structured data groups of Car Rental System functionalities. The main entities of the Car Rental System are Cars, Booking, Passenger, Car Routes, Drivers and ##keyword6##.

Car Rental System entities and their attributes :

• Cars Entity : Attributes of Cars are car_id, car_driver_id, car_customer_id, car_number, car_company car_type, car_description
• Booking Entity : Attributes of Booking are booking_id, booking_title, booking_type, booking_ticket, booking_date, booking_description
• Passenger Entity : Attributes of Passenger are passenger_id, passenger_name, passenger_mobile, passenger_email, passenger_username, passenger_password, passenger_address
• Car Routes Entity : Attributes of Car Routes are car_route_id, car_route_name, car_route_type, car_route_description
• Drivers Entity : Attributes of Drivers are driver_id, driver_name, driver_mobile, driver_email, driver_username, driver_password, driver_address, driver_licence
• ##keyword6## Entity : Attributes of ##keyword6## are ##AttributeList6##

Description of Car Rental System Database :

• The details of Cars is store into the Cars tables respective with all tables
• Each entity (##keyword6##, Passenger, Drivers, Booking, Cars) contains primary key and unique keys.
• The entity Passenger, Drivers has binded with Cars, Booking entities with foreign key
• There is one-to-one and one-to-many relationships available between Drivers, Car Routes, ##keyword6##, Cars
• All the entities Cars, Drivers, Passenger, ##keyword6## are normalized and reduce duplicacy of records
• We have implemented indexing on each tables of Car Rental System tables for fast query execution.