Information Systems Analysis and Design Asgnmnt-2

https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4462760071454301
COIT 20248: Information Systems Analysis and Design(ISAD)
Term 3, 2019
Assessment 2 – Systems Development for Ryan Aviation

Lecturer:

Tutor:

Prepared by:

Student Number: 

Table of Contents

1.0        Introduction. 2

1.1        Ryan Aviation Company Description. 2

1.2        Objective and Methodology. 3

1.3        Report Outline. 3

2.0 Critical use case diagram.. 4

3 Context Level Diagram.. 5

4 Level-0 DFD Diagram.. 6

5 ERD Diagram.. 7

6. CRUD diagram.. 8

8.     Website Design and architecture. 10

8.1 Objective. 10

8.2  Aesthetic : Visual Design. 10

9. Conclusion. 14

1.0  Introduction

1.1      Ryan Aviation Company Description

Ryan is Aviation Company that accommodates the services through aircrafts. This company wants to fill up the gap in the market for chartered helicopter flights, service the mining sector and assist the different places during the bush fire seasons. It has won the various contracts from Queensland and New South Wales for assisting during the bush fire seasons. The main aim and objectives of Ryan Aviation is to develop an online system that can track the numbers of flight in a particular day, flight timetables, maintain the stock levels for spare parts, fire retardant materials, and water resources, generate the basic reports, online payment system, flight personnel and location, flight base, flying hours for each day. The desired new system should tie together all the elements of Ryan Aviation and solve the problems with the current system.

1.2    Objective and Methodology

The main objective of this report is to provide the modeling diagrams and website design that were developed for Ryan Aviation. In assignment 1, the initial planning and system analysis of Ryan Aviation has been done. This included the chosen approach for developing the new system, functional and non-functional requirements, cost-benefit analysis, Work Break Down structure and Gantt chart, and system information requirement investigation techniques.

1.3    Report Outline

At the beginning, this report will discuss the critical use cases for Ryan Aviation. Secondly, it will present the context level diagram and level-0 Data Flow Diagrams. Similarly, it will illustrate the data modeling approach through the use of ERD, CRUD diagram, and all the data elements needed for data entities for Ryan Aviation. And finally this report will explain the website design prototype and its architecture.

 

2.0  Critical use case diagram

It is the primary for of system/software requirements for underdeveloped new software program. It is an effective method of communicating system actions within the context of the user by defining all externally visible system behavior. A key concept for use case modeling is that it allows us to design a system from the viewpoint of the end user ( Al-Alshuhai, A., & Siewe, F. 2015).

 The use case diagram shown below describes the behavior of the Ryan Aviation and assists in the development of interactions with team member. There are 4 actors in this system. Customer is the system’s primary actor who initiates an interaction with the system to achieve the system’s goal.

Use Case Diagram

                                                Figure 1: Use case diagram

 

3 Context Level Diagram 

A context diagram is the highest level of data flow diagram that have only one process depicting the entire system and the process is denoted as zero (Kendall & Kendall 2011). A context diagram is a graphic design, which clarifies the project or process’s interfaces and boundaries. It not only shows the method or project in its context but also shows the connexons between the project and other structures and users. The diagram shows only the main outside organizations and their data flows to and from them.

Context Level Diagram

Figure above represents the context diagram of Ryan Aviation. The Ryan Aviation Information System has four entities (Customers, Administration, Staff, and Payment Method) that are arranged around the one process called Ryan Aviation. The Customers request flight booking and Ryan Aviation sends the booking confirmation to the Customers. The purpose of Admin is to track the fire retardant, Air attacks, and aircraft maintenance. Staff always do all the accounting jobs and Ryan manages the payroll and staff wages. Whether customers are paying their flight charges or not it is ensured by the payment method entities. All the external function is done by these four entities for Ryan Aviation.

4 Level-0 DFD Diagram

Level-0 DFD diagram (see Figure below) shows the information system’s main processes, data stores and data flows and is the expanded version of the context diagram which represents the entire information system (Shelly & Rosenblatt 2012). A level 0 data flow diagram (DFD), also known as a background diagram, shows a complete data system and illustrates how it communicates with external entities. This example from DFD level 0 demonstrates how a system like this might operate within a typical retail company.             

Level-0 DFD Diagram

                                                                     Fig: Level 0 DFD Diagram

The above diagram is shows the level 0 data flow diagram which is based on the context level diagram. All the four entities are taken and there are three stores which are billing generates, data store and aircraft tracking. There are five process customers booking, process payment, data store, scheduling, and aircraft maintenance to manage the four entities and three stores. The data flow steps are listed below.

1. Flight booking

2. Check flight details

3. Process for flight charge

4. Payments conforms

5. Receipt send to customers

6. Billing records store

7. Staff track flights

8. Scheduling info.

9. Access scheduling info.

              10. Request for aircraft check

              11. Message after aircraft maintenance

              12. Track fire retardant

              13. Accounting info

5 ERD Diagram

 An entity-relationship diagram is a model that displays the logical connections and interaction between the system entities. An ER diagram gives an overall view of the system and a design for creating the physical data structures (Shelly & Rosenblatt 2012). In ER diagram two words are used, namely primary key and international key. The primary key is the specific attributes of the entire system relation whose value will vary from the other attribute value. Foreign key is a primary attribute in one relationship and becomes a non-primary attribute in another relation. There are four types of relationship between the two entities.  Which are listed below: 

1. One to one relationship 

2. One to many relationship

 3. Many to many relationship

 4. Many to one relationship

                                                                         Fig: ERD Diagram

Above figure shows about the ERD diagram of Ryan Aviation Information System Design. The entities in our system are customer, staff, Administration, payment method, Scheduling, maintenance and data store. The attributes are defined below the entities. The PK represent Primary key and FK represents foreign Key. The cardinality is shown between the entities. Thus, designing the ER diagram of the system gives the base of the database and visualizes how the data will be stored in our design system.

https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4462760071454301

6. CRUD diagram

CRUD diagram sometimes called the CRUD matrix is a model of physical data flow describing four different system operations. The four acts include Formation, Writing, Updating and Deletion. Much objects not found in logical data flow chart may be covered by a physical or CRUD diagram. The CRUD matrix also lists data entry and verification process. It also has contract directories and data servers. The table of CRUD’s matrix based on a rational flow chart is described below.

Process                                                 EntityAvailabilityPassengerReservationFlight
Determine seating optionsR RR
Assign seatsU  U
Release seatU RU
Maintain passenger reservationRRCRUD 
Maintain seatingRU RRU
Schedule flightsCRUD  CRUD
Maintain passenger CRUD  
Determine route options    
Update reservationRURUCRUDRU
CRUD Diagram

                                                                    Fig: CRUD diagram

This table shows the CRUD diagram of Ryan Aviation. It has four entities and 9 processes. The row contains entities like availability, passenger, reservation, and flight whereas columns contain different options that a passenger can access.

Data elements:

  1. Customer
No.Column nameData typesizeconstraints
1Customer IDNumber20Primary key
2NameText20 
3MobileNumber10 
4AddressText30 
  • Staff
No.Column nameData typesizeconstraints
1Staff IDNumber20Primary key
2Staff NameText20 
3AddressText10 
4DesignationText30 
  • Data store
No.Column nameData typesizeconstraints
1Data base systemNumber20 
  • Administration
No.Column nameData typesizeconstraints
1ADMIN IDNumber20Primary key
2RecordsText20 
3PayrollNumber10 
4Manage systemText30 
  • Payment method
No.Column nameData typesizeconstraints
1TRANSACTION IDNumber20Primary key
2Customer IDText20Foreign key
3Transaction DateNumber10 
  • Maintenance
No.Column nameData typesizeconstraints
1Parts costNumber20 
2Part nameText20 
  • Scheduling
No.Column nameData typesizeconstraints
1Scheduling dateNumber20 
2DestinationText20 

8.    Website Design and architecture

8.1 Objective

  • It actually shows how the system looks like.
  • To provide clear vision of the interface of the website.
  • Identifying where the system fails to provide its functionality.

8.2 Aesthetic : Visual Design

The system aims to improve its system through maintaining its system through different branches. The system provides functionality on both desktop and mobile. The website is responsive.

8.3 The Key elements

The website is designed to save time for everyone. The key element of the website is it’s easy to use navigation where customer can search for flights and see the actual cost of the flight and see the discounts, giving wide range of options for the customers to choose aircrafts, pilot members,  and even the destination.

8.4 User Interface

 The user interface of Ryan Aviation is shown as below:

Signup Page

                                                                              Fig: Sign up Page

login page

                                                                                     Fig: Login Page

Home Page

                                                                                  Fig: Home Page

Flight Details

                                                                               Fig: Flight Details

About us Page

                                                                     Fig: About us Page

Inventory Maintanace

Fig: Inventory Maintenance

9. Conclusion

The report clearly explains modeling diagrams and the design of the website for Ryan Aviation. First, a use case diagram was illustrated to describe the high-level information system of Ryan Aviation. Then context level diagram and level-0 DFD diagram are developed to show the main entities, business process and data flows. Thirdly, the entity-relationship diagram was represented as a model to display the logical connections between system entities. Fourthly, data entry and verification processes were listed on the CRUD matrix. Finally, the website was designed and its architecture was shown.

The website is a very simple to use design where users can easily navigate through the website. This designed website gives an additional benefit for its employees as well as its customers for future enhancement of the desired system.

Reference

Al-Alshuhai, A., & Siewe, F. (2015). An extension of the use case diagram to model context-aware applications. 2015 SAI Intelligent Systems Conference (IntelliSys), 884-888.

Joshi, N. and Shukla, N. (2020). List Of Top 10 Best Online Flight Booking Sites To Get Cashback Offers. [online] Official OfferCounty Blog : Lifestyle & Deals Hack.