- 0of 0 votes
1) Bus route Database -- dpka February 25, 2010
I want to design a database about bus route of a city like bangalore. Where u know all bus stop name and need a DB such that it will be easy to add new bus stop in our list. We would like to handle two kind of queries a) user will give route number ......we have to retrieve whole route i.e we have to print all the bus stop where this bus will stop and b) user will give source(S) and destination(D) name .....we have to find all possible route number that a person can take to reach D from S considering one case where we dont have direct connectivity from S to D so it should show via routes as well like the results of makemytrip.com or yatra.com when u want to travel from bangalore to guwahati ..though no direct flight is there we will get some via list. Also DB should be easily expandable (ie their should be some easy way of adding new routes and stops).
| Report Duplicate | Flag | PURGE