- Our goal is to develop a fully functional backend with decent frontend for a cab booking application.
- Customer and driver both can use the application.
- Customers can book journeys consisting (pick-up location, pick-up time, car, number of people, destination, sharing). The nearest driver will be informed about the journey and can accept the journey.
- The fair will be calculated based on following variables; traffic, car-type, journey-duration, etc.
- MySQL
- Python
- Google maps API
- Customer
- Driver
- Booking
- Transaction
- Car
- Customer & Booking have a one to many relationship.
- Driver & Car have a one to one relationship.
- Driver & Booking also have a one to many relationship.
- Booking & Car also have a one to many relationship.
- Booking and Transaction have a one to one relationship.
- Customer (customer_id, name, password, history, current_booking, phone_number)
- Driver (driver_id, name, password, history, car_id, phone_number, current_location, working)
- Booking (booking_id, pickup_location, destination, pickup_time, car_id, number_of_people, sharing, status, customer_id, driver_id, transaction_id)
- Car (car_id, brand, model, capacity, price_per_km, registration_number)
- Change password.
- Change phone-number.
- Check history(past bookings/transactions).
- Cancel booking.
- Make booking.
- Change password.
- Change phone-number.
- Change car.
- Change currently working status.
- Check history(past transactions).
- Cancel booking.
- Accept booking.
- Change driver current-location.
- Change booking status.
- Handle transaction.
Customer will book the journey. The booking will be push to the database and nearest driver will be informed about the journey. A tentative fair will be provided to the Costumer for reference.
Customer can pay with UPI, Cash, Net banking, Credit card & Debit card.
Customer can select pick-up location and destination using maps. Customer can see the Driver’s current-location in the map. Driver can also navigate to pick-up-location through maps.
During transaction atomicity will be handled. And all the constraints will be handled with care.