Systems Analysis and Design: Online Yachts Reservation System Report

This report details the analysis and design of an online yachts reservation system for Yachts Australia (YA). The student begins with an executive summary, followed by a system request outlining the project's goals and benefits, including improved customer experience and business growth. A work plan, feasibility analysis (technical, organizational, and economic), and a comprehensive definition of functional and non-functional requirements are provided. The report then presents a use case diagram, context diagram, Level 0 diagram, and subsequent Data Flow Diagrams (DFDs) to illustrate the system's processes. Furthermore, an Entity Relationship Diagram (ERD) and a data dictionary are included to model the data structure. The report concludes with a bibliography of cited sources, showcasing a thorough understanding of systems analysis and design principles. The system aims to enable customers to book yachts online, streamlining the reservation process and enhancing YA's business operations.

Running head: ONLINE YACHTS RESERVATION SYSTEM
ONLINE YACHTS RESERVATION SYSTEM
Name of the Student
Name of the University
Author Note

1ONLINE YACHTS RESERVATION SYSTEM
Executive Summary
In this report, the online yachts reservation system was built. Before building a system
prototype is necessary. The manual system takes lots of time to book a yacht for the
customer. The new system is useful for the customer as well as YA authority. Use case
diagram is a beneficial technique for building a system. In this report, data flow diagrams
show the data flow between authors and ERD can specify all the entity for this system. By
using this system, YA authority can increase the growth of their business.

2ONLINE YACHTS RESERVATION SYSTEM
Table of Contents
System Request:.........................................................................................................................3
Work Plan:.................................................................................................................................3
Requirements Definition:...........................................................................................................3
Functional Requirements:......................................................................................................3
Nonfunctional requirement:...................................................................................................4
Use Case:....................................................................................................................................5
Process Models:.........................................................................................................................7
Context Diagram:...................................................................................................................7
Level 0 diagram:....................................................................................................................7
Further DFD Levels:..............................................................................................................9
Data Model:..............................................................................................................................11
Entity Relationship Diagram:...............................................................................................11
Data Dictionary:...................................................................................................................11

3ONLINE YACHTS RESERVATION SYSTEM
System Request:
The main aim of the YA online reservation system is, customer can book yachts
tickets online. This system is not only beneficial for a customer; it is also helpful for business.
By using this system, YA can improve their business. Passenger details can be efficiently
stored in the database. Authority can check the passenger detail any time. The old system was
manual based. It took a long time to reserve a yacht in the old order. New system can store all
Yachats details and their status. When a customer used to book a ticket online by using this
system, they will never buy ticket offline. By using this system, YA does not need to
maintain their all branches. A Customer can book a ticket online from anywhere.
Work Plan:
Rank Goal Resource needs solution Progress Made
1 To successfully
build a new system
Need experienced
developers to build
an entire website
Management needs to
find experience
website designers.
Completed
Feasibility Analysis:
Technical Feasibility: Developers needs to build the entire website and must deliver on time.
This is a web-based system. A database will store all details in this system.
Organizational Feasibility: YA Management must find good developers to build the
website. Without an experienced website designer, YA is not able to make their website.
Economic Feasibility: Online reservation system is more flexible than a manual system. The
customer always prefers online system. This website will affect in online reservation market.

4ONLINE YACHTS RESERVATION SYSTEM
Management should make a budget to build this website. This system is beneficial for the
organization.
Requirements Definition:
Functional Requirements:
This system will display a registration page when a customer visits the website. A
customer needs to provide all details like their full name, email, phone number and address.
After providing all details, the system will accept the registration request and redirect a
customer to log in page. Customer must log in to the system to book tickets. For login,
customer needs to provide password and email. System will verify and password and email.
When user’s email and password both are matched, customer can use the website. The
password contains uppercase and lower case letter. After a successful login attempt, the
customer can search for yachts. The system can display the list of the available yacht with its
booking price lists. The database contains all Yachats details. A customer can book tickets
by their credit card or debit card. Customer can cancel their tickets any time. This system has
a logout button. User can logout from the website after book tickets. When all tickets are
booked, the system will display a message like no tickets are available. Yachts have a
different ticket price. Customer will get a confirmation email after successfully booked ticket.
This system has a user profile page. In the profile page, the user can provide additional
information about them. In this system, a feedback page is available. After booking a ticket,
the user can rate their service and provide valuable feedback.
Nonfunctional requirement:
Availability:

5ONLINE YACHTS RESERVATION SYSTEM
An efficient database is mandatory for this system. Customer can book tickets any
time. This is a web-based system, so a website must be online 24/7.
Usability:
This website must be simple and attractive, so every customer can prefer this website.
The yachts image must be high quality and simple payment process. The goal of this system
is helping the user to book their tickets.
Adaptability:
From any operating system, the user is able to access this website. Many customers can use
this website at the same time, so this system must be adaptable. User load must be handled
efficiently.
Capacity:
This system is serviced based system. This website can be store many details like user
details and yacht details.
Extensibility:
System admin can add yachts when authority buys or hire a yacht, and they can delete
yachts from the website. This website must have extensibility attribute.

6ONLINE YACHTS RESERVATION SYSTEM
Use Case:
Figure 1: use case diagram for online yachts reservation system
(Source: created by author)
Use case descriptions:
Name Book Ticket
ID UC01
Description User can book yachts tickets by using this system
Actors Customer
Organizational
Benefits
By using this system, an organization can increase their profit.
Frequency of Use Every time when a customer book tickets.

7ONLINE YACHTS RESERVATION SYSTEM
Triggers Customer book a tickets
Preconditions Customer details must be recorded in the system
Post-conditions By using registration, page organization can store all customer
information
Main Course 1. Customer register on the website
2. YA store all customer details
Process Models:
Context Diagram:
Figure 2: Context diagram of the online yachts reservation system

8ONLINE YACHTS RESERVATION SYSTEM
(Source: created by author)
Level 0 diagram:
Figure 3: level 0 diagram of the online yachts reservation system
(Source: created by author)

9ONLINE YACHTS RESERVATION SYSTEM
Further DFD Levels:
Figure 4: level 1 DFD of the online yachts reservation system
(Source: created by author)

10ONLINE YACHTS RESERVATION SYSTEM
Figure 5: level 2 DFD of the online yachts reservation system
(Source: created by author)

11ONLINE YACHTS RESERVATION SYSTEM
Data Model:
Entity Relationship Diagram:
Figure 6: ERD of online yachts reservation system
(Source: created by author)
Data Dictionary:
Yacht
Attribute Descriptio
n
Data Type
and Size
Domai
n
Defaul
t
Value
Require
d
Uniqu
e
Key
YachtID The
Identificati
on of each
Yacht
Number (0 to
infinite
)
Yes Yes Primar
y Key
YachtNa
me
Provides
the name of
VARCHAR(5
0)
(a..z)
(A..Z)
Yes

12ONLINE YACHTS RESERVATION SYSTEM
each yacht
Booking_i
d
Provides
the ID of
each
booking
Number (a..z)
(A..Z)
Yes Yes Foreig
n key
Staff:
Attribute Descriptio
n
Data Type
and Size
Domai
n
Defaul
t
Value
Require
d
Uniqu
e
Key
StaffID The
Identificatio
n of each
Staff
Number (0 to
infinite
)
Yes Yes Primar
y Key
StaffNam
e
Provides
the name of
each staff
VARCHAR(5
0)
(a..z)
(A..Z)
Yes
Contact_n
o
Provides
contact
number of
each staff
Number (0 to
infinite
)
Yes
Customer:
Attribute Descriptio Data Type Domai Defau Require Uniqu Key

13ONLINE YACHTS RESERVATION SYSTEM
n and Size n lt
Value
d e
CustomerID The
Identificati
on of each
Customer
Number (0 to
infinite
)
Yes Yes Primar
y Key
CustomerNa
me
Provides
the name
of each
customer
VARCHAR(
50)
(a..z)
(A..Z)
Yes
Contact_no Provides
number of
each
customer
Number (0 to
infinite
)
Yes
Booking:
Attribute Description Data
Type
and
Size
Domai
n
Defaul
t Value
Require
d
Uniqu
e
Key
BookingID The
Identificatio
n of each
Customer
Numbe
r
(0 to
infinite)
Yes Yes Primar
y Key

14ONLINE YACHTS RESERVATION SYSTEM
Booking_dat
e
Provides
date of
booking
date date Yes
Customer_id Provides the
customer id
of each
customer
Numbe
r
(0 to
infinite)
Yes yes Foreign
key
Payment_id Provides the
payment id
of each
payment
Numbe
r
(0 to
infinite)
Yes yes Foreign
key

15ONLINE YACHTS RESERVATION SYSTEM
Bibliography
Al-Btoush, A.A.S., 2015. Extracting Entity Relationship Diagram (ERD) from English
Sentences. International Journal of Database Theory and Application, 8(2), pp.235-244.
Al-Masree, H.K., 2015. Extracting Entity Relationship Diagram (ERD) from relational
database schema. International Journal of Database Theory and Application, 8(3), pp.15-26.
Bagui, S. and Earp, R., 2011. Database design using entity-relationship diagrams. Auerbach
Publications.
Chourey, V. and Sharma, M., 2016, September. Functional flow diagram (FFD): semantics
for evolving software. In 2016 International Conference on Advances in Computing,
Communications and Informatics (ICACCI) (pp. 2193-2199). IEEE.
Irhamn, F. and Siahaan, D., 2019, August. Object-Oriented Data Flow Diagram Similarity
Measurement Using Greedy Algorithm. In 2019 1st International Conference on Cybernetics
and Intelligent System (ICORIS) (Vol. 1, pp. 274-278). IEEE.
Rahman, N.A. and Zin, N.A.M., 2018. Visualizing Requirements using Use Case Diagram
and Diagram 0 for Compound Information System. Journal of Mathematics & Computing
Science, 3(1), pp.34-38.
Sugiarto, E., Kom, S. and Kom, M., 2015. Contex Diagram dan Data Flow Diagram.
Xiong, H., Zhang, H., Dong, X., Meng, L. and Zhao, W., 2017, September. DFDVis: A
Visual Analytics System for Understanding the Semantics of Data Flow Diagram.
In International Conference of Pioneering Computer Scientists, Engineers and
Educators (pp. 660-673). Springer, Singapore.