Uber System Design Interview Question (2020)
Uber System Design Interview Questions
System Design competency.
Below is Uber Schema -
rider - rider id, name, age, gender, dob, phone, current payment type , current payment account;
rider_bookmarks - bookmark id, rider_id, bookmark_tag('home','office' etc), bookmark_locn id;
driver - driver id, name, joined date, curr cab id; check if running multiple vehicle so have curr cab id;
cab - vehicle type, per_km, base_fare, etc; cab id, cab type, brand, reg no, year of make;
map_grid = locn in a map grid of 1x1km; id, latitude,longitude;
locn - human readable landmark locn - india gate, school, rly station etc; id, map_grid_id, is_landmark, related_locn_id, zip_code;
trip - trip_id, cab id,rider id,start time, end time,request time, is surge applied, surge %, rider rating, driver rating, start locn id, end locn id;
payment - id, type, base fare, surge fare, total fare, payment timestamp, card no, transaction id
Question –
System Design to handle scenario wherein customers who used Uber app to take a ride but couldn’t subscribe to the ride.
That is ,they drop off at the final tunnel.