Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please do it. I will definitely upvote. You are hired by a Railway Company, you are asked to design a system which provides information to
Please do it. I will definitely upvote.
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. - Each Train has Train number, train name, source, destination, fair of Premium Ticket, fair for general ticket and weekdays on which train is available. - Train status includes date information for which the ticket was booked, total number of seats available and number of seats already occupied. - Passenger has name, age, address of the passenger, status of reservation (if confirmed or waitlist), category of the ticket booked. 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. Task 1: Create an ER Diagram the RRS database: Construct a clean and concise ER diagram for the RRS database. List your assumptions and clearly indicate the cardinality mappings. Task 2: Create a GUI for the RRS database SQL Queries: Railway Reservation Application: [20 points] 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. You also need to print the count of rows returned. 1. User input the passenger's last name and first name and retrieve all trains they are booked on. [ 3 points] 2. User input the Day and list of passengers travelling on entered day with confirmed tickets displays on UI. [3 points] 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 . [3 points] 4. List all the train name along with count of passengers it is carrying. [3 points] 5. Enter a train name and retrieve all the passengers with confirmed status travelling in that train. [ 3 points] 6. User Cancel a ticket (delete a record) and show that passenger in waiting list get ticket confirmed. [5 points] Please make sure to write out team contributions at the end of the document! This will be 5 points of the overall grade. Train Name (Train Number, Premium Fair, General Fair, Source Station, Destination Station, Available on) 1. Orient Express (001, 800$,600$, Paris, Istanbul, Weekdays) 2. Flying Scotsman (002, 4000S, 3500S, Edinburgh, London, (Friday, Saturday, Sunday)) 3. Guwahati Express (003, 980\$, 860\$, Lokmanyatilak, Guwahati, (Monday, Tuesday, Wednesday)) 4. Golden Chariot (004,4300$,3800$, Bangalore, Goa, Weekend only) 5. Maharaja Express (005,5980 S, 4510\$, Delhi, Mumbai, (Wed, Thus, Friday)) Passenger Sample: \begin{tabular}{|l|l|l|l|l|l|l|} \hline Graciela & Ruta & 98 Connecticut Ave Nw & ChagrinFalls & Geauga & 4405797763 & 277292710 \\ \hline Cammy & Albares & 56 E Morehead St & Laredo & Webb & 9568417216 & 331160133 \\ \hline Mattie & Poquette & 73 State Road 434 E & Phoenix & Maricopa & 6029536360 & 331293204 \\ \hline Meaghan & Garufi & 69734 E Carrillo St & McMinnville & Warren & 9312357959 & 290123298 \\ \hline Gladys & Rim & 322 New Horizon Blvd & Milwaukee & Milwaukee & 4143772880 & 286411536 \\ \hline Yuki & Whobrey & 1 State Route 27 & Taylor & Wayne & 3133414470 & 294860856 \\ \hline Fletcher & Flosi & 394 Manchester Blvd & Rockford & Winnebago & 8154265657 & 317434088 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started