Assignment: Advanced Database Systems
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.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.