TAXI MANAGEMENT SYSTEM

ROOPESH N(1RN20IS196)
VARDHAN S(1RN20IS179)
 Taxi management
•. system
.

ER Diagram
• .
Bill_date Disc_amt
Gender F_name L_name

Bill_no Bill_details
Driver_id
Driver Contact_no

N Total_amt
Rating 1
Age
Has
L_name
Drives
F_name
End_time
Taxi_id
N Cust_id 1 Trip_id
1
Model Taxi Ride N 1 N Trip_details
Customer Has
M Status
Address
Reg_no
1 Cont_no Start_time

Trip_date
Owned
Gives
1
Own_name
Owner F_name
N L_name
Feedbk_id
Div 1
SSN Tsc_id BASED 1
Feedback ON Customer_service

Name Individual Taxi service Tsc_name

Customer Cust_id Name Cont_no Address Taxi_id

Taxi Taxi_id Reg_no Model Status Driver_id

Driver Driver_id Name Gender Contact_no Age Rating

Trip_details Trip_id Trip_date Start_time End_time Cust_id Taxi_id Driver_id

Bill_details Bill_no Bill_date Total_amt Disc_amt Cust_id Trip_id

Feedback Feedbk_id Message Email Cust_id Bill_no Email_id

Customer_service Email_id F_name L_name

Owner taxi Owner_id Taxi_id

Owns Owner_id

Taxi service Tsc_id Tsc_name Owner_id

Individual SSN Name Owner_id