A.I.S.S,C.E PRACTIC C.B.S.E TERMe|__ SESSION: £724 -23 COMPUTER SCIENCE PRACTICAL FILE NAME: Krish Raj Gupta CLASS: 12TH SCIENCE BOARD ROLL NO.: 12691228 SUBJECT: COMPUTER SCIENCE (083)opportunity to do this wonderful project on the topic vhi also helped me in doing a lot of Research and | came about so many new things | are really thankful to teacher. Secondly, | would also like to thank my parents and friend who helped me a lot in finalizing the project within the limited time frameBarrackpore has — this project under my Cc and guidance with utmost sincerity per the guidance of Central Board Of Secondary Education Internal Signature External Signature ]ABSTRACT g ‘The railway reservation system facilitates the passengers to enquiry about the trains available on the basis of source and destination, booking and cancellation of tickets, enquiry about the status of the booked ticket, etc. The aim of case study is to design and develop a data base maintaining records of different trains, train status and passengers. This project contains introduction to the railways reservation system. It is the computerized system of reserving the seats of train seats in advance. It is mainly used for a long route. Online reservation has made the process for the reservation of seats very much easier than ever before. Tnour country India, there are number of counters for the reservation. of the seats and one can easily make reservations and get tickets. Railway reservation system, has described above, can lead to error free, secure, reliable and fast management system. It can assist the user to concentrate on their other activities rather to concentrate on the record keeping. Thus, it will help organization its better utilization of resources. Administrator of the project, with the help of a password, can enter new train record, display all train records, modify train records and delete train records. The record of train includes its number, name, source, destination, and days on which it is available, whereas record of train status includes dates for which tickets can be booked, total number of seats available, and number of seats already booked.Contents 1. Introduction. Purpose Advantage of this Project: Data Dictionary... 7. System Design a, Weleome Page b. Booking of Ticket c. E-Ticket d. Cancellation of Ticket... e. Postponement of Ticket. 8. System Design Flow Diagram. 9. Conelusio 10. Bibliography1. Introduction Railway reservation system is developed for to automate the railways reservation system. It includes modules required to successfully operate railways reversion process smoothly. It has train master to add modified train information, train schedule to enter train journey details include all the station name, arrival time and departure time, It includes automatic fair calculation as per the distance between two stations. Reservation module consists of automatic seat number and coaches no allocation system. Daily schedule for updating of not conform seat and coach no. All master like train master, Train schedule, reservation fees, cancellation fees, charges can be modified individually from front end and changes reflect in all modules immediately. Therefore proposed "Railway reservation system" has been designed to automate the process of railway for ticket reservation and back-office activities. System can make the daily activities efficient and provide the fast response. The "Railway reservation system” has been developed to override the problems prevailing in the practicing manual system. This software is supported to eliminate and, in some cases, reduce the hardships faced by this existing system. Moreover, this system is designed for a particular need of a company to carry out operations in a smooth and effective manner. The application is reduced has much as possible to avoid errors while entering the data. It also provides error messages while entering invalid data. NG formal knowledge is needed for the user to use this system. Thus, by this all it proves it is user friendly. Railway reservation system, has described; can lead to error free, and secure, reliable and fast managing system. It can assist the user to concentrate on the other activities rather to concentrate on the record keeping. Thus, it will help organization in better utilization of resources.2. Purpose ‘The purpose of the source is to describe the railway reservation system which provides the train timing details, reservation, billing and cancellation on various types of reservation mainly, * Online reservation * Confirm reservation & e-Tickets + Cancellation of reservation or postponement of reservations Every organization, whether big or small, has challenges to overcome and managing the information of ticket, train, customer, seat, payment. Every Railway reservation system has different train needs, therefore we designed exclusive employee management systems that are adopted to your managerial requirements. 3. Advantage of this Project * Security of data. « Ensure data accuracy. + Proper control of the higher official Minimize manual data entry. Minimum time needed for the various processing. Greater efficiency. Better service. User friendliness and interactive.4. Data Dictionary No. | Variable Name ‘Type 1, | Departure * | Station char 46 2, | Destination Station char 45, 3. ‘Train Name String (chan) | 30. 4, |TrainNumber — | Int 23 5. | Time Int 2 No of seats © | booked im 1 7, | No-ofseats a 1 [Tostore number of | available seats are available | 8. | Scat type chen ‘To store type of S| seat Bart) | 9. Cost of per seat float 3 10. | Passenger's log in | Int, char 5 ‘Name of mS im |e String 12, | Age Int i 13. | gender Char 2 14,_| Date Int a 15.__| No. of seats Int ‘To store no of seats _| ‘To store extra cost: Extra cost for 3 [when 16. | postponement of | float postponement of ticket ticket is done Page | 5Windows 10 Professional IDLE (Python 3.9 64-bit) MySQL. . Hardware Device name Processor Primary Memory (RAM) System type6. Function table sh. e Bowe [cnc Name) 39 Deseriptiont Destination list ‘To store destination list rain name string ‘To store train names Train No. Int g_ | Tostore train number Grnust be unique) Time float ‘To Departure and arrival time No. of seats Int ‘To count the no. of seats available & booked Seat type and ‘To store seat type with y Seren 'o store seat type wit cost oy their respective cost Phone number _ | Input(ind) “Must be of 10 characters Email id Input(ste) Should have and '.com’ ‘Should have alphabet, Password Input(stx) number, and special character Should be around Passengername | Input(sts) Shon Age Tnput(int) Must be =4 No. of seats Input(ind)7. System Design Inthe aystem design process, the primary objective is to identify user requirements and to build a system that satisfies these requirements. a, Welcome Page In this the customer will get options for what they wan 0 do like? i, To Book Ticket ii, For cancelation of tickets iii, To postponement of Ticket When they will select option, they need our program will proceed according to selected option ‘Welcome to: Railway Reservation System 1. 800k Ticket 2. Cancel Ticket 3, Postpone Ticket / Change Reservation Date ENTER YOUR CHOICE b. Booking of Ticket CASE-I - To Book Ticket First customers will be provided the destinayion list, (The customer needs to select the destinaty in) eg. From. To Howrah Delhi Delhi Mumbai Guwahati | KolkataLet the selected destination be To Delhi ‘Train name ae number Howrah Rajdhani Express | 012901 Duranto Express 234698 Purva Express 817250 Superfast Express 102986 eg. (Let selected train be) SL ; ‘Train No. AoE number 1._| Howrah Rajdhani Express_| 012501 | Howrah Rajdhani Express _ Class No. of Seat | No. of Seat ‘Available | Booked | Avaliable | | Clos Seek MI) Cay Upper Class | = 10(10x) | Lower Berth | 25,000/- ‘AIC 2 Tire Lower Berth | 10,000/- e 58 (60x) Upper Berth 8,000/- | NCoTie LoworBerth | 00 90 (100-x) | Middle Berth 4,000/- Upper Berth 4,000/- e.g. (Lat selected seat be) 7 Howrah Rajdhani Express Class ‘No. of Seat | No. of Seat | Choose Seat | Cost (2) Available | Booked _| Available 58 (60-x) | Lower Berth | 10,000/- AIG 2 TireCustomer Io in (Customer need to ticket.) log in to te account for booking Phone Number Your Email Set Password Ticket booking form (Customer need to enter the following personal details in this page) Welcome to Railway Reservation System Name of Passenger ‘Age Gender Date of Journey Nos. of Seat(z) (y>=2) Per Seat Cost 10,000.00 | (r) Total Ticket Cost i)c. Page | 11 E-Ticket (The e-Ticket will get ge and mentioned details) ‘ated from the above selected @> Indian Rai Aan Ral KRISH RAJ 12301/RAIDHANIEXP. Ho Ba HOWRAH (HWH) we 16 te NEWDELHI(NDLS) om 1650 ome 25 0CT2022 sma 10:95 —_—_————————————_— ‘Then the Ticket booking form page will open where the customer can only be able to change the date or personal details. Welcome to Railway Reservation System Name of Passenger | KRISH RAJ GUPTA Age 16 Gender | MALE Date of Journey | —_J_/20_ Nos. of Seatz) =n Per Seat Cost 10,000.00 (9) Date Change Surcharge o Total Ticket Cost| —_[al+(0) ‘Amount Payable ®‘Then the o-ticke ‘will get will be generated after payment of extra charges @ Indian Rait KRISH RAJ um T230URAIDHANEXP coor 4 ‘ou HOWRAH (HW 16 we NEWDELHI NOLS) ex 250cT2022 bons 1650 sume 1005 e_—————____ d. Cancellation of Ticket CASE-II For cancellation of ticket In this page customer need to provide the following details to cancel their confirm ticket Welcome to Railway Reservation System RESERVATION CANCELATION Enter Ticket No Phone Number Your Email Enter Password Then %/s part of the amount of ticket will get refunded in the account through which the payment was made.©. Postponement of Ticket CASE-IIT To Postponement of Ticket In this page age “hn customer need to provide the following to change the date of confirm Ticket, Welcome to Roilway Reservation System. POSTPONE TICKET / DATE CHANGE Enter Ticket No "New Date of Travel Your Email Enter PasswordCancelation | L Welcome Screen Page | 149, Conclusion ‘The main of developing reservation oe information that is required by the users. User f that is the user must gel the details without complicate procedures Other important requirements of software : Data security Extensibility Maintainability Flexibility User Friendly10. Bibliography + https'/github.com/krishraj: + httpsi/ivww.googlecom + https‘/en.wikipediaorg * Sumita Arora Computer Page | 16BOOKED SUCCESSFULLY IF CHOICE IS 1 (TICKET BOO! enter ur choice enter your name:vinu kanth enter your phone number:978 enter your age:16 M=MALE FEMALE. N=NOT TO MENTION enter your gender:m . enter ur starting point:chennai enter your destination:madurai enter date(dd) :23 enter month (mm) :04 enter year (yyyy) :2020 1.TICKET BOOKING 2.TICKET CHECKING 3.TICKET CANCELLING 4.ACCOUNT DETAILS 5.LOG OUT enter ur choice:2. SIGN UP 3. DELETE ACCounT EXIT : R YOUR CHOICE: . TICKET CHECKING TICKET CANCELLING ACCOUNT DETAILS LoG OUToutput CHOICE ae CHOICE WiInDow A 2.NO pO YOU WANT TO CONTINUE oR NOT:1 ere ONLINE RAILWAY RESERVATION SYSTEM .SIGN UP -DELETE ACCOUNT -EXIT ENTER YOUR CHOICE: Bown IF CHOICE IS 1(LOGIN WINDOW) 1.YES 2.NO DO YOU WANT TO CONTINUE OR NOT:1 WELECOME TO ONLINE RAILWAY RESERVATION SYSTEM 1.SIGN IN 2.SIGN UP 3.DELETE ACCOUNT 4. EXIT ENTER YOUR CHOICE:1 USER NAME:vinu kanth y PASS WORD: vinu1234 or HII vinu kanth WELCOME l.yes 2.no do you want to continue or not:IF CHOICE IS 2 (SIGN UP WINDO! 4 File_Edit_Shell_Oebug Options Winienneen ENTER YOUR CHOICE :> FIRST NAME :vinu LAST NAME :kanth USER NAME:vinu kanth PASS WORD :vinu1234 RE-ENTER YOUR PASS WORD :vinui234 PHONE. NUMBER - 2787883628 M=MALE F=FEMALE N=NOT TO MENTION ENTER YOUR GENDER:m ENTER YOR DATE OF BIRTH DD:23 MM:04 Y¥YY:2004 YOUR AGE:16 WELCOME vinu kanth 1.yes 2.no do you want to continue or not:41 1.TICKET BOOKING 2-TICKET CHECKING 3.TICKET CANCELLING 4.ACCOUNT DETAILS 5.LOG OUT enter ur choice:IF CHOICE IS 2(TICKET CHECKING) enter ur choice:2 1.yes 2.no do you want to continue or not:1 enter your phnone number: 9787883628 NAME :::: VINU KANTH PHONE NUMBER :::: 9787883628 iNGS 3889 46 GENDER :::: MALE STARTING POINT :::: CHENNAT DESTINATION :::: MADURAT DATE :::: 23/047202g 1.TICKET BOOKING 2.TICKET CHECKING 3.TICKET CANCELLING 4.ACCOUNT DETAILS 5.LOG OUT enter ur choice:IF CHOICE 1S 3(TICKET CANCELLING) enter ur choice:3 1.yes 2.no do you want to continue or not:1 enter your phone number: 9787883628 TICKET CANCELLED 1.TICKET BOOKING 2.TICKET CHECKING 3.TICKET CANCELLING 4.ACCOUNT DETAILS 5.LOG OUT enter ur choice: IF CHOICE IS 4(ACCOUNT DETAILS) enter ur Cchoice:4 USER NAME: vinu kanth PASS WORD:vinul234 GENDER =: =: DATE OF BIRTH AGE >= = -— Le 4.AC 5.LoG OUT enter ur cho ice:IF CHOICE Is 4(EXIT) 4.ExXx.iT ENTER YOUR CHOICE:4 THANK You >>> | _._.,/F CHOICE IsS5 OR MORE ENTER YOUR CHOICE: 56 ERROR 404:PAGE NOT FOUND >>> __SECOND CHOICE LIST AFTER LOGIN WELCOME l.yes 2.no do you want to continue or not:1 1.TICKET BOOKING 2. TLCKRE CHECKING SeTTChiIng CANCELLING 4.ACCOUNT DETAILS 5.LOG OUT enter ur choice :|print (YOUR | INCORRECT? ) | continue elif chi==4 print (“THANK you) break else: Print (‘ERROR 484: PAGE NOT FOUI break def main () : print (‘1.yes’) print (*2.no”) ceint (input (“ do you want to contin while (c==1) print (© 1 TICKET BOOKING” , CHECKING? ,”\n”, ‘3-TICKET, CANCELLING? ‘\n” , 4 . ACCO DETAILS’ , “\n”, ‘5- ch=int (input (‘enter if che=1: elif ch==3:ca=((M : MALE?, ep vea[Gender] q si “insert into railway values (4070202 OO, 42, apne, v,fr, to, date) cursor.execute (51) print (“Bookep SUCCESSFULLY?) def ticket_checking (): import mysql.connector nycon-mysql.connector.connect (host= ‘localhost’, u: root” ,passwd=’manager’, database= “railway’) cursor=mycon. cursor () mycon. autocommit=True print(‘1.yes”) print(‘2.no?) ch=int (input (“do you want to continue or not if che: phno=int(input(‘enter your phone number try: cursor.execute (s1) data=cursor.fetchall() [2 Data =list (data)gop mens ( ? print (1. Yes?) print (‘2.NO") cheint (input (‘D0 you want 9 | while che=1 : print (‘WELCOME TO ONLINE. SYSTEM?) print (1. SIGW IN’) print (‘2. SIGN up?) print (°3. DELETE accounT?) print (4. EXIT?) ch1=int (input (“ENTER YOUR CHOICE: © if chi==1: a=checking() if a==True: print ¢‘wevcone’) main() else: continue elif. chi==2: a=checking_1 () if az=True: main () else: print (“PASS continue elif chi==3: c=checking.2 () if ce=True? Biase . ~ ~ saad+ TABLES sort ‘mysql. connector ycoreaysal sconnecton. connect (hosts? 1o, Moot? , passwd=’; cunsoremycon. cursor () gycon-autoconmit=True gierereate database railway” ‘cursor-execute(s1) varchar (50), from _f varcha varchar (10@), date d varci cursor. Execute (s1) six’? create table user_accounts (fname varchar (10), 1name varcharsis “select user ni yrore password= “{} “Format (yy l= “select fname, yser_accounts where passwords <{)» « cursor .execute(c1) datat=cursor.fetchai1 () datat=1ist (data) 7 datat=datai[e] 4 «, cursor.execute (s1) data=cursor. fetcha11() data=list (data) if data[o]=-a: X=[ ‘FIRST NAME? , ‘LAST NUMBER’, ‘GENDER’, ‘DATE OF BIRTH, © AGE?) si= “select where password= “{}? “.format (b) cursor.execute (s1) data-cursor.fetchal1 () data=list (data) print (x[@], print (x[a], ‘#5275 print (x(2], © print (x[3], print (x[4],Et CHOTceere : ry WANT TO CONTINUE oR e TO ONLINE RATLWay : ae n RESERVATION sist sIGN UP BypeLeTe ACCOUNT 4, EXE < gurer YOUR CHOICE: 3 SER NAME: vinu kanth WORD: vinul234 5s THIS YOUR ACCOUNT pirsT NAME vinu iast NAME ::: kanth pHONE NUMBER ::: 9787883628 GENDER ::: MALE pATE OF BIRTH ::: 23/04/2004 2 enter your choice : 1 ACCOUNT DELETED WELCOME TO ONLINE RAILWAY RESERVATION SYSTEM 1, SIGN IN i 2. SIGN UP 3, DELETE ACCOUNT 4, EXIT ENTER YOUR CHOICE: