Programming Assignment #3 – Railway Reservation System

At Programming Homework Tutors, we believe in providing our students with practical, real-world examples of how to apply the concepts they learn in class. That’s why we’ve developed a variety of sample projects to help you see how our courses can be used to create impactful solutions in your field of study.

Scenario:

You are hired by a Railway Company, you are asked to design a system which provides information to passengers about the trains available on the bases of source and destination, other information like status of the train, status of passenger ticket, how many seats are available etc. Suppose you are given the following requirements for a simple database for the Railway Reservation System:

This system helps to maintain the records of different trains, the train’s status, and passengers. The database consists of 4 tables: 

• Train: Train Number, Train Name, Premium Fair, General Fair, Source Station, Destination Station
• Train_Status: TrainDate, TrainName, PremiumSeatsAvailable, GenSeatsAvailable, PremiumSeatsOccupied, GenSeatsOccupied
• Passenger: first_name, last_name, address, city, county, phone, SSN, bdate
• Booked: Passanger_ssn, Train_Number, Ticket_Type, Status

Note: As the system is very large and is not feasible to develop therefore there are some assumptions that need to be considered, for example:

• Only two categories of tickets are available: Premium and General Ticket
• The total number of tickets can be booked in each category (Premium and General) is 10
• Number of tickets in waiting list is 2
• Total Number of trains are 5
• Any stops made by a train before its destination and their bookings are not considered.

Create a GUI for the RRS database SQL Queries:

Railway Reservation Application:  

Create a simple and friendly GUI interface that would be able to perform the following tasks. You may use JAVA programming using JDBC, or C/C++/C# programming with ODBC/Oracle or Python programming or PHP/MySQL or other programming languages to develop a GUI interface. The user will have to type or select the query’s input parameters and post the question to your program. The program needs to return all result’s rows. 

Query/GUI TASK:

1. User input the passenger’s last name and first name and retrieve all trains they are booked on.
2. User input the Date and list of passengers travelling on entered day with confirmed tickets displays on UI.
3. User input the age of the passenger (50 to 60) and UI display the train information (Train Number, Train Name, Source and Destination) and passenger information (Name, Address, Category, ticket status) of passengers who are between the ages of 50 to 60.
4. List all the train name along with count of passengers it is carrying.
5. Enter a train name and retrieve all the passengers with confirmed status travelling in that train.
6. User Cancel a ticket (delete a record) and show that passenger in waiting list get ticket confirmed.

Please make sure to write out team contributions at the end of the document! This will be 5 points of the overall grade.

Dataset will be available in a zip folder with the assignment.

Canvas Submission:

Create a folder with your code, named “Code.py” Inside the “Code” folder, create a Readme.docx(pdf) file, this file should have the 6 query solutions listed and step-by-step instructions and screenshots on how to install and run your program from scratch. Also, place a database backup (self-contained file), named as rrs.sql inside your “Code” folder,  

Disclaimer

The sample projects provided on our website are intended to be used as a guide and reference for educational purposes only. While we have made every effort to ensure that the projects are accurate and up-to-date, we do not guarantee their accuracy or completeness. The projects should be used at your own discretion, and we are not responsible for any loss or damage that may result from their use.
At Programming Homework Tutors, we are dedicated to helping students and educators achieve their goals by providing them with the resources they need to succeed. Our website offers a variety of tools and resources that can help you with the project mentioned above.
Whether you need help with research, project management, or technical support, our team of experts is here to assist you every step of the way. We offer online courses, tutorials, and community forums where you can connect with other learners and get the support you need to succeed.
If you’re looking to take your skills to the next level and make an impact in your field, we invite you to explore our website and see how we can help you achieve your goals.