Programming Exercise IV: My Bus Itinerary: Part IV
Note that this interface is only an example, and it may NOT meet the requirements of this exercise.
Implementing the database (given): 05% (given code)
Have to use the following database tables (schema):



Resetting the system (given): 05%
Before testing, the instructor needs to clear the data stored in your system.

               


Bus route and stop input (given): 05%

Number of routes:    

(Each route is a bi-directional sequence of bus stops, unique names, separated by commas.)

               


Listing all data (given): 05%

List all database table contents:  

         


Showing a route (given): 05%

Display the sequence of the bus stops of the route #

               


Finding the shortest itinerary: 70%

Start stop:     Final stop:

Route #: (Route # is for demo (instructor) only)

           


Plagiarism checking
If the web interfaces are used, include the following interface:

~/public_html/course/280/exercise/4/check.html
Password:       Interface:                    
The above interfaces are required for the exercise, and the extras below are the interfaces for checking some other SQL commands. You can hide them, so they will not distract your attention from solving the problem.

     


Listing the routes including the stop keywords

Show the routes whose stops contain any of the keywords:

               


Finding the routes and transfers for an itinerary

    Start bus stop:     Final bus stop:

           


Finding the number of bus stops between two stops inclusively in a route

    Route ID:     Stop 1 name:     Stop 2 name:

           


Listing the bus stops between two stops inclusively in a route

    Route ID:     Stop 1 name:     Stop 2 name: