Car Pooling System ER Diagram

Subscribe our YouTube channel for latest project videos and tutorials Click Here

Posted By freeproject on July 17, 2017

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

Car Pooling System entities and their attributes :

  • Cars Entity : Attributes of Cars are car_id, car_customer_id, car_number, car_company car_type, car_description
  • Pooling Entity : Attributes of Pooling are pooling_id, pooling_customer_id, pooling_driver_id, pooling_amount, pooling_payment, pooling_type, pooling_description
  • Passengar Entity : Attributes of Passengar 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
  • Bill Entity : Attributes of Bill are bill_id, bill_customer_id, bill_number, bill_type, bill_receipt, bill_description
  • Drivers Entity : Attributes of Drivers are driver_id, driver_name, driver_mobile, driver_email, driver_username, driver_password, driver_address, driver_licence

Description of Car Pooling System Database :

  • The details of Cars is store into the Cars tables respective with all tables
  • Each entity (Drivers, Passengar, Bill, Pooling, Cars) contains primary key and unique keys.
  • The entity Passengar, Bill has binded with Cars, Pooling entities with foreign key
  • There is one-to-one and one-to-many relationships available between Bill, Car Routes, Drivers, Cars
  • All the entities Cars, Bill, Passengar, Drivers are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Car Pooling System tables for fast query execution.
Car Pooling System ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

Training and Placement Management System ER Diagram

Training and Placement Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Training and Placement Management System Entity. The entity-relationship diagram of Training and Placement Management System shows all the visual instrument of database tables and the relations between Placement, Jobskeer, Trainning,...
Student Feeback System ER Diagram

Student Feeback System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Feeback System Entity. The entity-relationship diagram of Student Feeback System shows all the visual instrument of database tables and the relations between Feedback, Faculty, Student, Subject etc. It used structure data and to...
Internet Chat System ER Diagram

Internet Chat System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Internet Chat System Entity. The entity-relationship diagram of Internet Chat System shows all the visual instrument of database tables and the relations between Groups, Records, Individuals, Status etc. It used structure data and to...
Railway Enquiry System ER Diagram

Railway Enquiry System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Railway Enquiry System Entity. The entity-relationship diagram of Railway Enquiry System shows all the visual instrument of database tables and the relations between Timetable, Stations, Trains, Routes etc. It used structure data and to...
Financial Management System ER Diagram

Financial Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Financial Management System Entity. The entity-relationship diagram of Financial Management System shows all the visual instrument of database tables and the relations between Ledgers, Expenses, Accounts, Stock etc. It used structure...
Medical Diagnostic System ER Diagram

Medical Diagnostic System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Medical Diagnostic System Entity. The entity-relationship diagram of Medical Diagnostic System shows all the visual instrument of database tables and the relations between Tests, Doctors, Medical Reports, Employees etc. It used structure...
Golf Scoring System ER Diagram

Golf Scoring System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Golf Scoring System Entity. The entity-relationship diagram of Golf Scoring System shows all the visual instrument of database tables and the relations between Players, Sorts, Golf, Length etc. It used structure data and to define the...
Coach Management System ER Diagram

Coach Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Coach Management System Entity. The entity-relationship diagram of Coach Management System shows all the visual instrument of database tables and the relations between Coach Number, Train, Coach, Report etc. It used structure data and to...
Art Gallery Management System ER Diagram

Art Gallery Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Art Gallery Management System Entity. The entity-relationship diagram of Art Gallery Management System shows all the visual instrument of database tables and the relations between Customer, Order Update, Arts, Arts Stock etc. It used...
Placement Office Automation ER Diagram

Placement Office Automation ER Diagram

This ER (Entity Relationship) Diagram represents the model of Placement Office Automation Entity. The entity-relationship diagram of Placement Office Automation shows all the visual instrument of database tables and the relations between Users, Resumes, Placements, Registration etc. It used...
Call FreeProjectz WhatsApp FreeProjectz