This ER (Entity Relationship) Diagram represents the model of Car Sharing System Entity. The entity-relationship diagram of Car Sharing System shows all the visual instrument of database tables and the relations between Customer, Car History,, Booking, Memebership etc. It used structure data and to define the relationships between structured data groups of Car Sharing System functionalities. The main entities of the Car Sharing System are Booking, Customer, Payment, Car History,, Insurance and Memebership.
Car Sharing System entities and their attributes :
- Booking Entity : Attributes of Booking are booking_id, booking_title, booking_type, booking_ticket, booking_date, booking_description
- Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
- Payment Entity : Attributes of Payment are payment_id, payment_customer_id, payment_date, payment_bill, payment_type, payment_description
- Car History, Entity : Attributes of Car History, are car_history_id, car_history_customer_id, car_number, car_history_company car_history_type, car_history_description
- Insurance Entity : Attributes of Insurance are insurance_id, insurance_bike_id, insurance_number, insurance_date, insurance_expiry, insurance_amount, insurance_type, insurance_description
- Memebership Entity : Attributes of Memebership are membership_id, membership_customer_id, membership_name, membership_type, membership_description
Description of Car Sharing System Database :
- The details of Booking is store into the Booking tables respective with all tables
- Each entity (Memebership, Payment, Insurance, Customer, Booking) contains primary key and unique keys.
- The entity Payment, Insurance has binded with Booking, Customer entities with foreign key
- There is one-to-one and one-to-many relationships available between Insurance, Car History,, Memebership, Booking
- All the entities Booking, Insurance, Payment, Memebership are normalized and reduce duplicacy of records
- We have implemented indexing on each tables of Car Sharing System tables for fast query execution.