+----------+-------------+-------------+
| route_no | Start_point | destination |
+----------+-------------+-------------+
|      123 | ABC         | BCD         |
|      234 | DEF         | EFG         |
|      345 | GHI         | HIJ         |
|      445 | JKL         | KLM         |
|      546 | MNO         | NOP         |
+----------+-------------+-------------+

+-----+--------+--------+------+
| pid | pname  | gender | age  |
+-----+--------+--------+------+
| 111 | David  | m      |   30 |
| 222 | Andy   | f      |   20 |
| 333 | kat    | f      |   27 |
| 444 | viki   | m      |   32 |
| 555 | rob    | m      |   52 |
+-----+--------+--------+------+

+-----+----------+------------+---------+
| pid | route_no | jrny_date  | seat_no |
+-----+----------+------------+---------+
| 111 |      123 | 2019-05-14 |      57 |
| 222 |      234 | 2019-06-11 |       3 |
| 333 |      345 | 2019-07-20 |      33 |
| 444 |      445 | 2018-08-22 |      14 |
| 555 |      546 | 2018-11-17 |      19 |
+-----+----------+------------+---------+`