Advanced Database Systems

DEVELOP RAILWAY SYSTEM DATABASE PROJECT

We need to use MySQL and for GUI Interface for input an

d output we can you any

platform.

A railway system, which needs to model the following:

1. Stations

2. Tracks, connecting stations. You can assume for simplicity that only one track

exists between any two stations. All the tracks put together to form a graph.

3. Trains, with an ID and a name

4. Train schedules recording what time a train passes through each station on its

route.

You can assume for simplicity that ea

ch train reaches its destination on the same day and that

every train runs every day. Also for simplicity, assume that for each train,

for each station on its

route,

you store

•

Time in,

•

Timeout (same as time in if it does not stop)

•

A sequence num

ber so the stations in the route of a train can be ordered by

sequence number.

5. Passenger booking consisting of train, date, from

-

station, to station, coach, seat

and passenger name.

Deliverables:

•

Copy of code

•

Report:

o

Title page (project name, semester, course, instructor name)

o

Project description (include information regarding the software, programming

languages, tools, etc. used and its version)

o

ER/EER diagrams

o

Print screens of interfaces/forms (empty and full s

creenshots of the GUI used to

input information)

o

Print screens of tables from MySQL

o

Print screens of reports (screenshots of the GUI used to display / output

information to the user)

o

List of queries (for example, list all data, list passenger informa

tion ,etc.)

o

Conclusion. Reflect on your experience completing this project as an individual.

The good and the bad. Time spent. Difficulties faced. New tools or programming

languages, etc. you had to learn on your own.

•

Upload code and report to this drop box.

DEVELOP RAILWAY SYSTEM DATABASE PROJECT

We need to use MySQL and for GUI Interface for input and output we can you any

platform.

A railway system, which needs to model the following:

1. Stations

2. Tracks, connecting stations. You can assume for simplicity that only one track

exists between any two stations. All the tracks put together to form a graph.

3. Trains, with an ID and a name

4. Train schedules recording what time a train passes through each station on its

route.

You can assume for simplicity that each train reaches its destination on the same day and that

every train runs every day. Also for simplicity, assume that for each train, for each station on its

route, you store

• Time in,

• Timeout (same as time in if it does not stop)

• A sequence number so the stations in the route of a train can be ordered by

sequence number.

5. Passenger booking consisting of train, date, from-station, to station, coach, seat

and passenger name.

Deliverables:

• Copy of code

• Report:

o Title page (project name, semester, course, instructor name)

o Project description (include information regarding the software, programming

languages, tools, etc. used and its version)

o ER/EER diagrams

o Print screens of interfaces/forms (empty and full screenshots of the GUI used to

input information)

o Print screens of tables from MySQL

o Print screens of reports (screenshots of the GUI used to display / output

information to the user)

o List of queries (for example, list all data, list passenger information ,etc.)

o Conclusion. Reflect on your experience completing this project as an individual.

The good and the bad. Time spent. Difficulties faced. New tools or programming

languages, etc. you had to learn on your own.

• Upload code and report to this drop box.