![]() Then develop a database system to mimic its operations. You are required to study and analyze the booking service of Online Railway Reservation System. ![]() All ticket information will be kept in the database. etc A customer can book up to a maximum of 6 tickets for the same trip. To name a scat uniquely, we need to give both the train name to which this seat belongs to and the seat number To book a trip, the customer needs to enter his personal information ex: SSN, customer's name (first, last name), date of birth, phone. The seat has status, class (first, economy) and price depend on the seat class. There are different numbers of trains, cach one has a unique name and number of seats at least 20 seats. The station has at least one trip per a day. The trip has different source, destination, date and time of departure and arrival. Each station has different trips, the trip has two types one way or round trip. There are different stations, and cach station has a unique name, set of phones, and location (city, street). In this project, you are asked to build a database for an Online Railway Reservation System, that is used to assist in booking tickets of trains. ![]() The tickets that have been booked by the customers need to be stored in the database and the other information of customers, trains, available seats, trips, stations. Transcribed image text: PROJECT DESCRIPTION Online Railway Reservation System Online Railway Reservation System is aimed to provide the customers facility to book tickets for a train online in convenient way to travel from a particular source to the destination. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |