Front End

Trip Booking System

BACK END

Customer Table

CustomerIDNamePhone

TripOption Table

TripOptionIDRouteDuration

Driver Table

DriverIDNamePhone

Trip Table

TripID CustomerID TripOptionID DriverID Date