online reservation system case study

Gravity Flow

Automate your business processes with Gravity Forms.

Case Study: An Online Reservation System

In this case study, Greg Cole of Esper Media , a full-service graphic design and creative marketing firm in Arizona, describes a client project which integrated Gravity Flow, GravityView and Gravity Forms to provide an end-to-end online reservation system for a travel company.

For a recent project we used Gravity Flow to facilitate a process for taking online reservations for a tour company that needed the ability to accept credit card bookings at the initial form submission, but not process billing until the tour had been provided (sometimes months after receiving the reservation).

We integrated a third-party credit card processing script that creates user billing profiles within the merchant account upon initial submission. This provides a means of authorizing the credit card without posting a payment. By then using some calculation fields linked to the tour date we were able to schedule automatic workflow triggers in Gravity Flow to re-authorize credit cards 7 days prior to the tour date (to ensure we still had valid card details on file and to account for any changes in the amount to be billed in the event the customer had made changes to their tour itineraries) and also to prompt the reservation agents to process the final billing the day after the tour has been provided.

We also implemented an advanced front-end entry management system using  GravityView . While Gravity Flow handles the workflow process, GravityView is used to present the entries to the agents in a way that helps them perform their tasks quickly and easily (using data tables ). Agents can then filter the reservations and show specific columns depending upon the workflow. For example, we created pages for “Today’s Tours” used to create their driver sheets/schedule each day, “Tour Authorizations” with links to Gravity Flow where they enter the credit card authorization code to ensure a good card is on file just prior to providing the tours, and “Tour Billing” which lists tours that have been provided but have not been billed and links to Gravity Flow where they enter the final billed amount and credit card transaction ID.

The unique challenge for this project was that the client has to manually process their credit cards because they take a reservation at some point prior to providing the actual service (often times weeks or months in advance). To avoid PCI Compliance issues with storing the data on their own systems, this task was offloaded to the merchant using billing profiles which solved the security issue. The  Gravity Forms / GravityView /Gravity Flow combo allowed us to create data entry and management workflows around this constraint to streamline the client’s manual process . The reservation agents can make edits to the reservation (increasing or decreasing the billing total of the final service being rendered for instance when the number of participants changes) and all of the changes are tracked in the system. They then have a simple process for finalizing the process and capturing all of the details that previously were all handled on paper in a completely manual set-up.

By utilizing the User Input step type, we were able to streamline data entry for the reservation agents. They receive notification emails telling them when tours need to be re-authorized or billed and then log-in to the virtual terminal of the merchant account as well as the reservation system to complete the necessary tasks. Having the ability to only show the fields relevant to the task at hand, we reduced data entry errors and increased productivity .

We intend to extend the system further in the near future with Approval workflows that tie in to a scheduling component and with Web Hooks that trigger external report generation. Gravity Flow has allowed us to create an end-to-end application for taking online reservations that would have been difficult to achieve using any other WordPress-based tools.

Greg Cole, Owner, Esper Media, Phoenix, AZ – United States.

————

Read more case studies.

Read more customer testimonials.

If you’d like to find out more about how Gravity Flow can help make your business more efficient, please get in touch .

Share this:

Get started with gravity flow today and make your workflows seamless.

Copyright © 2015-2024 Rocketgenius Inc.

• Screenshots
• Documentation
• Developer Docs
• Cookie & Privacy Policy
• Terms & Conditions
• Legal Notice

Discover more from Gravity Flow

Subscribe now to keep reading and get access to the full archive.

Type your email…

Continue reading

Pervasive Computing and Social Networking pp 451–461 Cite as

Design of a Web-Based Platform: Event-Venues Booking and Management System

• P. S. JosephNg 12 ,
• S. M. Al-Sofi 13 ,
• K. Y. Phan 14 ,
• J. T. Lim 14 &
• S. C. Lai 14  
• Conference paper
• First Online: 02 September 2022

465 Accesses

1 Citations

Part of the book series: Lecture Notes in Networks and Systems ((LNNS,volume 475))

Conducting an event require planning multiple tasks and managing finance for the event. Nevertheless, event management and event organization are more of a manual-based works and require a more automated system to produce more efficient and reliable reservations. This research aims to improve the event organization and management by promoting people to find, book a venue, and track the budget expenses through a web-based platform, Event-Venues Booking and Management System, by implementing cloud computing. After the data from a survey and an interview have been obtained and presented, the suggested system features are created based on the gathered results that would meet the needs of the future user. The findings suggest that the online platform assists individuals in arranging and managing their events in a more manageable and timely manner, while lowering the cost and time associated with it. Furthermore, the established system helps both users and suppliers to foster a positive connection between them, as determined by the research questions and objectives.

This is a preview of subscription content, log in via an institution .

Buying options

• Available as PDF
• Read on any device
• Instant download
• Own it forever
• Available as EPUB and PDF
• Compact, lightweight edition
• Dispatched in 3 to 5 business days
• Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Mehrotra and J. Lobo, ‘Technology Driving Event Management Industry to the Next Level’, in 2020 8th International Conference on Reliability, Infocom Technologies and Optimization (Trends and Future Directions) (ICRITO) , Noida, India, 2020, 1(1),436–441.

Google Scholar  

Bilgihan and M. Bujisic, ‘The effect of website features in online relationship marketing: A case of online hotel booking’, Electron. Commer. Res. Appl. , vol. 14, no. 4, pp. 222–232, Jul. 2015.

N. Serhiy, K. Yaroslav, and B. Kateryna, ‘Online Reservation System Project’, in Proceedings of the 4 the International Conference Computational Linguistics And Intelligent Systems , Lviv, Ukraine, 2020, 2(1), 347–348.

F. Rodzi, E. Nasir, A. Azmi, D. Abdullah, A. Azmi, and S. Kamal, ‘The Role of Compatibility, Information Quality and e-Service Quality in Predicting Mobile Hotel Booking Adoption: A Conceptual Framework’, Int. Acad. Res. J. Bus. Technol. , 2( 2), 123–128, 2016.

J. S. Madray, ‘THE IMPACT OF COVID-19 ON EVENT MANAGEMENT INDUSTRY’, Int. J. Eng. Appl. Sci. Technol. , 5(3), 533–535, 2020.

M Loke, PS JosephNg, AS Shibghatullah & HC Eaw (2020), Jomdrone: Data mining financial sense in the property agency, IEEE Symposium on Industrial Electronics and Application, Malaysia, 1-5

J. S. Zhang and Q. Lv, ‘Understanding Event Organization at Scale in Event-Based Social Networks’, ACM Trans. Intell. Syst. Technol. , 10(2), 16:1–16:23, 2019 .

Emir, H. Halim, A. Hedre, D. Abdullah, A. Azmi, and S. Kamal, ‘Factors Influencing Online Hotel Booking Intention: A Conceptual Framework from Stimulus-Organism-Response Perspective’, Int. Acad. Res. J. Bus. Technol. , 2(2), 129–134, 2016.

M. Ahmed, S. H. Ahmed, and O. H. Ahmed, ‘Dijkstra algorithm applied: Design and implementation of a framework to find nearest hotels and booking systems in Iraqi’, in 2017 International Conference on Current Research in Computer Science and Information Technology (ICCIT) , Slemani - Iraq, Apr. 2017, 4(1), 126–132.

N. A. H. Zolkopli, S. S. Ramli, A. Azmi, and S. B. M. Kamal, ‘Online Travel Shopping Intention’, Int. Acad. Res. J. Bus. Technol. , 2(2), 140–144, 2016.

S. Kamal, D. Abdullah, N. Md Nor, A. Ngelambong, and K. Bahari, ‘Hotel Booking Websites and their Impact on E-Satisfaction and E-Loyalty: Analysis on Utilitarian and Hedonic Features’, Int. Acad. Res. J. Bus. Technol. , 8(15), 160–177, 2018.

KM Liow, PS JosephNg, YF Loh, JomDesignLab: Bringing Artwork Design Nearer, IEEE International Conference on Control Systems, Computing and Engineering, Malaysia, 1–6

N. Bikakis, V. Kalogeraki, and D. Gunopulos, ‘Social Event Scheduling’, ArXiv180109973 Cs , 4(2), 1272–1275, 2018 .

P. Berners, The Practical Guide to Organising Events , 1st ed., 1(1). New York: Taylor & Francis, 2017.

H. Ujang, A. R. Omar, I. A. Rani, A. Azmi, S. B. M. Kamal, and D. Abdullah, ‘Factors Influencing Consumers Intention to use Self Service Technology in Tourism and Hospitality Industry’, Int. Acad. Res. J. Bus. Technol. ,2(2), 118–122, 2016.

M. Tiwari, T. Tiwari, S. Chaudhary, A. Marwah, and D. S. Bawa, ‘Need for sustainable event management in the Indian context’, J. Inf. Optim. Sci. , 41(5), 1291–1297, 2020.

T. C. Greenwell, L. A. Danzey-Bussell, and D. J. Shonk, Managing Sport Events , 1st ed., 1(1). USA: Human Kinetics, 2019.

M. A. Adu, ‘VENUE MANAGERS AND MEETING PLANNERS: A COMBINED PERSPECTIVE OF THEIR ROLES, RELATIONSHIPS, AND ATTRIBUTES NECESSARY FOR HOSTING A SUCCESSFUL MEETING’, J. UKnowledge , 15(4), 123–128, 2018.

MathSciNet   Google Scholar  

Koh and H. Greene, ‘Green Event Marketing: The Sustainable Community Event Portfolio’, J. Interdisciplinary Bus. Stud. , 2(8), 1–14, 2013.

L. Brooks, E. I. Brooks, and D. Jonathan, Interactivity and Game Creation: 9th EAI International Conference, ArtsIT 2020, Aalborg, Denmark, December 10–11, 2020, Proceedings , 1st ed., 1(1), Hung Kong SAR: Springer Nature, 2021.

J. Ugoani, ‘Budget Management and Organizational Effectiveness in Nigeria’, Bus. Manag. Econ. Res. , 5(2), 33–39, 2019.

Article   Google Scholar  

J. Ugoani, ‘Imperatives of Career Management and its Effect on Employee Performance’, Int. J. Soc. Sci. Perspect. , 5(2), 47–56, 2019.

Capriello, L. Altinay, and A. Monti, ‘Exploring resource procurement for community-based event organization in social enterprises: evidence from Piedmont, Italy’, Curr. Issues Tour. , 22(19), 2319–2322, 2019 .

H. Singh and R. R. Shah, ‘BOOKiiIT - Designing a Venue Booking System (Technical Demo)’, in 2020 IEEE Sixth International Conference on Multimedia Big Data (BigMM) , New Delhi, India, Sep. 2020, 1(1), 287–291.

W. H. Guilford and R. H. Schmedlen, ‘Perspectives on Successfully Implementing BME Design Courses Online: Notes from an ASEE Workshop’, Biomed. Eng. Educ. , 1(1), 145–148, 2021.

K. Meshram, D. Mate, A. Tighare, D. Wangal, and A. Lanjewar, ‘Celebrations - Online Venue Booking Management System’, Int. J. Res. Eng. Sci. Manag. , 2(3), 319–321, 2019.

JosephNg, P. S., & Eaw, H. (2021). Making Financial Sense from EaaS for MSE during Economic Uncertainty. Future of Information and Communication Conference (pp. 976–989). Vancouver, Canada: Springer Advances in Intelligent Systems and Computing.

JosephNg, P. S. (2021). Economic Turbulence and EaaS Grid Computing. Int. J. of Business Forecasting and Marketing Intelligence, 7(1), 33–52

JosephNg, P. S., & Eaw, H. C. (2022). Still Technology Acceptance Model? Reborn with Exostructure as a Service. International Journal of Business Information Systems, forthcoming .

JosephNg, P. S. (2019). EaaS Infrastructure Disruptor for MSE. International Journal of Business Information System, 30 (3), 373-385.

JosephNg, P. S. (2018). EaaS Optimization: Available yet hidden information technology infrastructure inside the medium-size enterprise. Technological Forecasting and Social Change, 132 (July), 165 - 173.

JosephNg, P. S., & Kang, C. M. (2016). Beyond Barebones Cloud Infrastructure Services: Stumbling Competitiveness During Economic Turbulence. Journal of Science & Technology, 24 (1), 101-121.

JosephNg Poh Soon, Kang Chon Moy, Ahmad Kamil Mahmood, Wong See Wan, Phan Koo Yuen, Saw Seow Hui, Lim Jit Theam (2016), EaaS: Available yet Hidden Infrastructure inside MSE, 5th International Conference on Network, Communication, and Computing, Kyoto, Japan, ACM International Conference Proceeding Series, 17–20.

PS, J. N., Kang, C. M., Choo, P. Y., Wong, S. W., Phan, K. Y., & Lim, E. (2016). Exostructure Services for Infrastructure Resources Optimization. Journal of Telecommunication, Electronic and Computer Engineering, 8 (4), 65-69.

JNP Soon, WS Wan, PK Yuean, LE Heng & LJ Theam (2015). Barebone Cloud IaaS: Revitalisation Disruptive Technology, International Journal of Business Information Systems, 18(1), 107-126

Joseph, N. P.S., Mahmood, A. K., Choo, P. Y., Wong, S. W., Phan, K. Y., & Lim, E. H. (2014). IaaS cloud optimisation during economic turbulence for Malaysia small and medium enterprises. International Journal of Business Information Systems, 16 (2), 196-208

Joseph, N. P.S., Mahmood, A. K., Choo, P. Y., Wong, S. W. Phan, K. Y., & Lim, E. H. (2013). Battles in volatile information and communication technology landscape: The Malaysia small and medium-size enterprise case, International Journal of Business Information Systems, 16 (2), 196-208

C. Li, J. Li, H. Cao, and Z. Meng, ‘Design and Implementation of Online Booking System of University Sports Venues’, MATEC Web Conf. , 100(1), 20–24, 2017.

D. Alkhaldi, D. Alkhaldi, H. Aldossary, U. A. Badawi, M. Alshabanah, and D. Alrajhi, ‘Developing and Implementing Web-based Online University Facilities Reservation System’, Int. J. Appl. Eng. Res. , 13(9), 6700–6708, 2018.

I. T. on S. D. Innovation (ITSDI) and D. I. U. R. MM M. T. I., Cloud Computing and its role in Information Technology , 2nd ed., 1(1). Madinah Saudi Arabia: IAIC Transactions on Sustainable Digital Innovation (ITSDI), 2021.

Download references

Author information

Authors and affiliations.

Faculty of Data Science and Information Technology, INTI International University Persiaran Perdana BBN, Putra Nilai, 71800, Nilai, Negeri Sembilan, Malaysia

P. S. JosephNg

Institution of Computer Science and Digital Innovation, UCSI University UCSI Heights, 56000, Cheras, Kuala Lumpur, Malaysia

S. M. Al-Sofi

Faculty of Information and Communication Technology, Universiti Tunku Abdul Rahman, 31900, Kampar, Perak, Malaysia

K. Y. Phan, J. T. Lim & S. C. Lai

You can also search for this author in PubMed   Google Scholar

Corresponding author

Correspondence to P. S. JosephNg .

Editor information

Editors and affiliations.

Electronics and Communication Engineering, Gnanamani College of Technology, Namakkal, India

G. Ranganathan

Czech Technical University in Prague, Prague, Czech Republic

Robert Bestak

Ryerson Communications Lab, Toronto, ON, Canada

Xavier Fernando

Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.

About this paper

Cite this paper.

JosephNg, P.S., Al-Sofi, S.M., Phan, K.Y., Lim, J.T., Lai, S.C. (2023). Design of a Web-Based Platform: Event-Venues Booking and Management System. In: Ranganathan, G., Bestak, R., Fernando, X. (eds) Pervasive Computing and Social Networking. Lecture Notes in Networks and Systems, vol 475. Springer, Singapore. https://doi.org/10.1007/978-981-19-2840-6_35

Download citation

DOI : https://doi.org/10.1007/978-981-19-2840-6_35

Published : 02 September 2022

Publisher Name : Springer, Singapore

Print ISBN : 978-981-19-2839-0

Online ISBN : 978-981-19-2840-6

eBook Packages : Engineering Engineering (R0)

Share this paper

Anyone you share the following link with will be able to read this content:

Sorry, a shareable link is not currently available for this article.

Provided by the Springer Nature SharedIt content-sharing initiative

• Publish with us

Policies and ethics

• Find a journal
• Track your research

Eat App for

How it works

Case Studies

Case Study: Increasing Online Bookings & Streamlining Restaurant Operations

Wapalapam is an Indian Ocean Eatery, located on the foothills of the beautiful Le Morne Brabant mountain in Mauritius. Known for its perfect setting and for turning a culinary experience into a memorable occasion, the unique and authentic restaurant was started by the famous Snowboarding World Cup champion, Rok Flander, and his wife, Gabriella in 2016.

Introduction

The power couple transformed an old Bank into a shabby chic-looking restaurant, offering guests the special opportunity to eat local Indian Ocean food off the more than 100 years old wooden tables and chairs - an ambiance that fits perfectly with the beautiful environment of the UNESCO, protected by the Le Morne Brabant mountain area. 

And to top it all off, the Wapalapam duo joined forces with founder and author, “Aquacasia, Culinary Jewels of the Indian Ocean,” Chef Willibald Reinbacher to create a new culinary concept, which offers an unforgettable mix of authentic and artisanal offerings, “capturing the heart and soul of each island’s love of food.” Each year, the magnificent restaurant grows from stretch to stretch, giving guests from around the world a unique, and unforgettable experience. Subsequently leading them to branch out with a second location in Port Louis in 2021. So, how do they do it? 

In February 2021, owners Rok and Gabriella started using Eat App to help them manage their online bookings and operations in general. Today, the restaurant has seen an increase in online bookings, which helped them get back into the swing of things, after the visible decrease in restaurant reservations during the dreadful Covid-19 pandemic. The restaurant received 241% more reservations during December and January 2022, compared to February 2020 which was the best month pre-pandemic. 

We spoke to Restaurant Manager Gloria Reinbacher to tell us a bit more about how they manage to increase their bookings and seat guests faster on a daily basis. “We started using Eat App to have better follow up and record on reservations,” she says. It was also important for Gloria and the staff at Wapalapam to give guests the opportunity to make reservations online, plan and have a clear record of reservations. 

When it comes to Eat App, Gloria mostly uses our software to assist her with ongoing reservations and seating of guests. “Planning the setup [of the restaurant], ensuring staff are on duty, monitoring all bookings for our different outlets, ensuring smooth operation in general” are a few other important tasks Gloria is responsible for at Wapalapam restaurant.  

1. Increasing online bookings 

Firstly, let’s review how Wapalapam restaurant managed to increase its online reservations and increase their turnover rate. Eat App, conveniently helps you set up your booking widget on your online platforms such as your website, Google, Facebook, and Instagram increasing your online bookings by 57%; and best of all, the covers generated through these widgets are completely free of charge. Restaurants like Wapalapam are also completely in charge of their own reservation channels, which means they have full control over accepting or declining incoming bookings they receive online. “Eat App is practical. I believe it [the software] did increase online bookings,” Gloria says. 

2. Building a guest database

The guest that made a reservation at Wapalapam through the booking widget is then automatically added to the guestbook along with their reservation history and contact details in case they visit again. For Gloria and the staff of Wapalapam, this has been a game-changer. They now spend less time of the day writing out details of every single guest making reservations. “We save paper, that’s for sure. We also spend less time with staff on the phone,” Gloria says. 

After you’ve automatically collected your guest database, restaurants are able to use the valuable information and send guest marketing emails and SMSs. “Creating data helps contact clients in advance for changes and future booking/marketing,” she says. “This information is important for feedback, no-shows, etc,” Gloria adds.

When it comes to improving the guest experience, Gloria mentions this is essential for restaurants. “Loyal customers are important for all businesses as they are going to give genuine feedback and recommendations,” Gloria says. The manager of Wapalapam also went on to say the feature she would recommend using to help increase guest loyalty is the “contact record and reservation system” built into Eat App. 

With this important guest information, restaurants can easily: 

• Offer guests special discounts during non-peak hours.
• Access powerful guest and reservation reports to better understand your business.
• Improve guest loyalty and engagement with automated guest segmentation and email marketing tools.
• Restaurants are also able to collect continuous customer feedback with automated online surveys.

3. Streamline reservations & set up your shifts

Once Wapalapam has received online bookings they use Eat App’s reservation software and table management system to confirm or cancel the reservation. They also have the option to add any notes about the reservation in the system for staff members to view when these guests arrive.

A few examples of how the Notes feature of Eat App can be used:

• To inform your staff of the daily specials
• To let your staff know that a big group is coming for a birthday party and to have the tables ready
• To communicate if a certain dish is out of stock

This feature not only helps the restaurant to create a better guest experience but also helps give staff full control over managing the reservations.

Share this article!

Elana Kroon used to work in restaurants before becoming a journalist and expert restaurant industry content creator at Eat App.

Case Study: Providing guests:...

Our latest case study takes a look at not one but...

Case Study: Managing Large:...

Our latest case study takes a look at La Cuadra...

Case Study: Putting Your:...

Our latest case study takes a look at Dubai's...

Join restaurants in 70+ countries using Eat App

Empowering restaurants, one table at a time Discover seamless dining with Eat App

• Reservation system
• Table management
• CRM and guest profiles
• Reports & trends
• Integrations
• Privacy policy
• Terms of service
• The 16 Best Reservation Systems
• Guide to Restaurant Marketing
• Guide to Customer Service
• Guide to Making a Restaurant Website
• All articles

"> "> Compare us

• Seven Rooms
• Compare All

© Eat App. All rights reserved.

• Software Engineering Tutorial
• Software Development Life Cycle
• Waterfall Model
• Software Requirements
• Software Measurement and Metrics
• Software Design Process
• System configuration management
• Software Maintenance
• Software Development Tutorial
• Software Testing Tutorial
• Product Management Tutorial
• Project Management Tutorial
• Agile Methodology
• Selenium Basics
• Levels in Data Flow Diagrams (DFD)
• Functional vs Non Functional Requirements
• System Design Strategy - Software Engineering
• Timetable Generating System UML diagram
• DFD for Library Management System
• Class diagram for Mall Management system
• Class diagram for Hotel management system
• SQA system and architecture
• Class diagram for Theatre Management System
• Architecture of Cloud Computing
• Class Diagram for Bus Stand Management System
• Differences between Sequence Diagram and Activity Diagram
• Software Engineering | Architectural Design
• Differences between Verification and Validation
• Non-functional Requirements in Software Engineering
• Class diagram for Airport management System
• Fundamentals of Software Architecture
• Class Diagram for College Management System
• Dynamic modelling in object oriented analysis and design

Online Railway Ticket Reservation System

Online Railway ticket reservation is very useful nowadays. This is very important to design a good-working system software for ticket booking and related transactions. To design it, full-track documentation of models(ER, DFD, Class, Use-case, Activity, Sequence) is required as per as software development is concerned. 

Features of the System:

The Reservation system should contain the following features: 

• If a passenger wants to reserve ticket(s), firstly, he/she has to log in to the Railway system with valid credentials. Then, the passenger has to provide his/her details with the date of the journey, names of the passengers and their details, origin station details, destination station details, and the class type of the required ticket(s).
• The Railway Reservation System will provide the available Train-list, and Seat-availability, via-details.
• To book a ticket passengers can pay through online/offline mode. After successful payment of the ticket fare the System will generate the ticket and PNR no. will be given to the passenger. The System also keeps the payment details and sends them to the system Admin.
• The Passenger can check PNR status (confirmed, RAC, waiting list) by entering the PNR no. into the Reservation system.
• The Reservation system should store all train details, fare details (by zone, class, and date wise), PNR no, date of trains, etc. This maintenance should be controlled by the Admin. 
• The System also has refund rules which have a date of reservation, ticket fare, and refundable percentage. The passenger can simply cancel the ticket(s) by entering the PNR no and a cancel ticket request. After cancelation, the Admin will pass the refundable amount to the System and the System will give the refundable amount to the passenger.

Required Diagrams:

Entity Relationship(ER) Diagram:   

ER diagram displays the relations between the various entities(classes and their attributes) stored in the database.  ER diagrams are very important for any database project. This diagram shows the communication between entities and their attributes.

The above ER diagram illustrates the key information about the railway reservation system, including entities like PAX_info, Login_credentials, Ticket_reservation, refund_rule, via_details, train_fare, Train, Seat_availability, Class, Zone, station, pay_info. This diagram also shows the relationships between entities.

Entities and their attributes are:

PAX_info: Attributes of PAX_info entity are  Passenger_id  (primarykey) ,SRL_no ,PAX_name ,PAX_age ,PAX_sex ,fare,seat_no.

• Login_credentials: Attributes of Login_credentials entity are login_id(PK) , password.
• Ticket_reservation: Attributes of Ticket_reservation entity are PNR_no(pk),to-date, from-date, to-km, from-km, to-station, from-station, Train_code.
•   Refund_rule: Attributes of  refund_rule entity are to-time, from-time, refundable-amt.
• via_details: Attributes of via_details entity are Details_id(PK), Train_code, via_station_code, km_from_origin, Reach_time.
• train_fare: Attributes of train_fare entity are to-date, from-date, to-km, from-km, Fare, Class_id.
• Train: Attributes of Train entity are Train_code(PK), Distance, Train_name, Start_time, End_time, Start_station_code, End_station_code, Frequency.
• Seat_availability: Attributes of Seat_availability entity are Train_code, Class_code, and Number of seats.
• Class: Attributes of Class entity are Class_id(PK), coach_prefix, class_code, Class_name, seat_per_coach.
• Zone: Attributes of Zone entity are zone_id(PK), Zone_name,Zone_code.
• Station: Attributes of station entity are Station_id(PK),Station_code,station_name, zone_id.
• Pay_info: Attributes of Pay_info entity are payment_id(PK), pay_mode, amount, pay_date, srl-no, PNR_no, inst_type, inst_amt.

Relationships between Entities:

• One-to-one relation: PAX_info to login_credentials , PAX_info to refund_rule, Train to Via_details, Class to train_fare, PAX_info to pay_info.
• Many-to-one relation: PAX_info to ticket_reservation, Zone to the station, Class to seat_availability.
• Many-to-many: Train to the station, Train to class. 

Data-Flow Diagram(DFD):  

This diagram represents various operations by dataflow movement.

• Level 0 DFD:

• Level 1 DFD:

Class Diagram:  

These diagrams describe the operation and attributes of a class with imposed constraints in the system. In this article the classes to be considered are ‘payment’, ‘train’, ‘passenger’, ‘ticket’, ‘railway reservation system’, ‘admin’. The description of the classes is given below.

Use-Case Diagram:  

By using use case diagrams, the interactions between a system and the users within that system will be represented.

Use-Case Descriptions:

The relationship between the actors and the use cases of the online Railway reservation system is given below–>

• Passenger Entity: Use cases of passengers are login, ticket availability, Filling the form, Book ticket, Canceling ticket, and Refund money.   
• Railway Reservation System: Use cases of the Railway Reservation System are login, ticket availability, Fill the form, Book ticket, Cancel ticket, and Refunding money.   
• Admin: use cases of Admin are Print ticket, refund money. Admin also controls the whole Railway Reservation System in different cases.

Activity Diagram:  

This diagram shows the flow of processes from one to another activity.

Sequence Diagram:  

This diagram shows how and in which order a group of objects works together in a system. This is an interactive diagram and this is mostly used by software developers.

Please Login to comment...

Similar reads.

• Software Engineering
• System Design

Improve your Coding Skills with Practice

What kind of Experience do you want to share?

Academia.edu no longer supports Internet Explorer.

To browse Academia.edu and the wider internet faster and more securely, please take a few seconds to  upgrade your browser .

Enter the email address you signed up with and we'll email you a reset link.

• We're Hiring!
• Help Center

DESIGN AND IMPLEMENTATION OF AN ONLINE AIRLINE RESERVATION INFORMATION SYSTEM

Airline Reservation Systems (ARS) used to be standalone systems. Each airline had its own system, disconnected from other airlines or ticket agents, and usable only by a designated number of airline employees. Travel agents in the 1970s pushed for access to the airlines' systems. Today, air travel information is linked, stored, and retrieved by a network of Computer Reservations Systems (CRS), accessible by multiple airlines and travel agents. This report is a summary of the study that was undertaken to design and implement an airline reservation system. The airline reservation system designed in this project was developed using php, java script and html as the programming languages and MySQL as the database Management system. The researcher reviewed the literature of reservation systems in chapter two and explored the advantages and limitations of reservation system in real life situations. The researcher used interviews and questionnaire methods during the data collection phase, these data collection methods helped the researcher to better understand the existing system in use. Case tools and data flow diagram were used during the development process to simulate the process of airline reservation and ticket booking. The outcome of the study was an online airline reservation system tested and implemented in the case study Rwenzori Airlines to book, schedule and reserve flights.

Related Papers

MARTIN WODULO

EG Technologies

The proposed project is a computerized reservation and ticketing system. Specifically, the project pertains only in the Flightiness operation of booking a passenger and reserving a seat in a flight and provides a payment process that will generate ticket in the ticketing system. The related sub-system Hotel, Tour, and Car Reservation has a direct connection in the ticketing system of the project since that the system only reserves a passenger who wants to include a hotel, tour, or car reservation in relation to their flight reservation. The developers provide a short report of their data gathered in the next paragraphs. This is an important part of this section that will give the reader an idea of what is the project theme all about.

akhi rudiyanto

Software Visualization

Ahmed Hassan

Devendra Patil

Hypertext pre-processor (PHP), a server side scripting language very often used to develop a web application. Web application has a big importance in communication over internet. Web applications got very fast growth in past some time. To pay bills, shopping, transactions, emails, social networking every days billions of users using these web application on in internet. Though web applications are very effective and time saving still security threats is also there. Now a day’s most of the application facing problem of security and data integrity. This study is to give different types possible attacks on web application which is developed by using php and how we anticipate such attack and prevent from them for future.

Sharief Zamshed

Online Doctor appointment System in hospital today necessitate a competent administration when handling patients, generating reports for cashier, patient details which serves as a key factor for the flow of business transactions in Farazy Hospital Ltd. Unfortunately the current Record Management System Leads to misplacement of during details, Patient details and doctor record of reports and insecurity to records. This research project is aimed at computerizing all the records about Patients, Hospital and Doctors. In order to achieve this goal, a through System Study and investigation was carried out and data was collected and analyzed about the current system using document and data flow diagrams. The concept of report production has been computerized hence, no more delay in report generation to the Hospital, Patient and Doctors. Errors made on hand held calculators and dealt out completely. The method used to develop the system include iterative water full model approach, dataflow, logical and entity relationship diagram where used to design the system and finally the language used SQL Server 2008, C# & ASP.Net.

Engenharia Energias

Vlasios Voudouris

RELATED TOPICS

•   We're Hiring!
•   Help Center
• Find new research papers in:
• Health Sciences
• Earth Sciences
• Cognitive Science
• Mathematics
• Computer Science
• Academia ©2024

Search code, repositories, users, issues, pull requests...

Provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications

Implemented Using Angular for UI, SpringBoot as Middleware & Database as MongoDB

Sanketgb/Online-Railway-Reservation-System-CaseStudy

Folders and files.

• JavaScript 50.0%
• TypeScript 12.7%