ITEC 630 - Individual Project

docx

School

University of Maryland Global Campus (UMGC) *

*We aren’t endorsed by this school

Course

630

Subject

Information Systems

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by BailiffWombat3944

Ticket Purchase System Phase 1: Requirement analysis Problem Definition has been in business for the past 20 years, but for the past 5 years, they have struggled to compete with other airlines ticket sales, and their business is in decline. The Chief Information Officer, James Bond, has identified their online and face-to-face ticket and call-in ticket sales are at an all-time low and their online sales are dwindling annually. An organizational overhaul of their website, customer help services, and data purchasing methods need to be conducted to meet, or exceed, the capabilities of other airlines. Issues ebsite is outdated and has not been updated due to a lack of allocated funds to support hardware and software modernization, as well as information technology (IT) support. The shift in use from face-to-face purchases or calling the airlines to reserve tickets to a the more modern phone application or internet sales has been found to be the root cause in the decline of sales. Customer

John Hardegree UMGC, ITEC 630 feedback and surveys have found that overall support for is positive, but the lack of technological simplicity to purchase tickets supports the decline in sales as well. Objectives Design a modernized IT architecture that supports customer ticket sales and support while synchronizing with for customer service and ticket issuance. The customer needs to input personal data, flight request information and payment information. The airline needs to have a data repository for return users and their accounts, flight ticket tracking system providing updates to the customer, flight information on seat availability and flight schedules, and the customer service needs to have access to all the user’s information in case assistance is requested. D. Requirements Hardware Upgrades: Outsourced cloud-based solutions for hardware and data storage to handle customer surges of activity. Data Storage and Security: Scalable, large-scale cloud-based data storage plan with data breach prevention, notifications, and reaction services. Recommend finding a service with insurance and warranty. Customer Database: Customer personal identification information (PII), payment methods, username and password, and flight information. Software Upgrades: Upgraded website tied to hardware and data storage. Creation of phone application for Android and Apple users. 1

John Hardegree UMGC, ITEC 630 IT Support Services: Part of the outsourced cloud-based solutions that have authorized access to customer purchases and flight information in real time. Needs to have human in the loop ability as well as automated assistance for after-hours customer support. E. Constraints Time: The amount of time needed to fully upgrade the airlines to the standard of competitive airlines will take some time. Further evaluation will be needed to identify how long the upgrade will take to fulling implement and how to implement changes without disrupting sales. Cost: The costs of using the recommended cloud-based solutions will vary depending on the requested requirements. The amount of available funds needs to be identified so the organization can set a budget. After implementation of the upgrades, added costs for formal training and training aids need to be taken into consideration. Additionally, in order to help get the new system fully implemented with current and new customers, advertisement and legal costs should be examined to find the most suitable and safest method of the new system rollout. Training: Training at all levels needs to be completed so the airline can run its new system efficiently. From the CEO down to the customer service reps needs to understand how the system works as well as the capabilities and limitations. The cloud service IT department will also need training on meeting the expectations of their customer (), how they will implement change, and how feedback will be given back to the company. F. Description of the Proposed System The ideal system would provide customers the ability to create a secure account, log in using a web browser or a phone application, search for flights, pay for flights, receive digital confirmations, and flight information, and have an airline customer service representative around 2

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

John Hardegree UMGC, ITEC 630 the clock to help the customer. The airline app and web browser should provide reliable security features that allow customers to safely store their PII and payment information within them. They should also be easy to navigate for the customer to increase the likelihood of return users. After payment is completed on any transaction, the customer should receive confirmation, updates, and change email notifications for their flights. Both a human and an automated customer service representative should be available at any given time of the day to help customers resolve issues. Also, customer service representatives need to have access to the customer’s profile to assist them with their duties. The Airlines database needs to be able to pull the Federal Aviation Administration (FAA) flight information through the use of secure Application Programming Interfaces (API). G. Logical Model Design Data Flow Diagrams This context diagram shows the external entities to and how their information feeds into the Airline cloud-based system solution. The FAA provides updates to the airline database. The customer can log in, search the FAA provided flights, select a flight, and make payments using their web browser or application. The payment information stored in the airline database is used for payment processing. If the customer has issues with their flight, they can contact customer service who have elevated rights to access the customer’s account and flight information. 3

John Hardegree UMGC, ITEC 630 2. Descriptions of outputs/inputs/performance/security or controls Customer: Customer will input username and password to access the Airline Cloud Based Database System Solution. If the customer forgets their username/password, they will input their registered email address and will receive a link in their email to reset the password. The customer will input search criteria for flights and will receive results for available flights. The customer would select their flight and proceed to the online cart to checkout. The customer will input their credit card information for payment processing and will receive either a visual confirmation, as well as email confirmation, the payment went through, or the payment was declined. The customer will receive notifications either manually from customer service or automatically from the Airline Database. 4

John Hardegree UMGC, ITEC 630 FAA: The FAA will send out flight information to the Airline Database on upcoming flights, flight times, departures, arrivals, prices, and seats available. The FAA will receive information back from the Airline Database on flights and seats purchased to update their records. Payment Processing: The Payment Processing will process requests for purchase and will invoice the banking organization. If denied, an unauthorized remark will be relayed back to the customer on the Airline webpage. Additionally, confirmation will be sent back to the Airline Database to provide a receipt to the customer. Customer Service: Customer service will input requests for information on behalf of the employee and will be able to deliver certain information back to the customer depending on what the request is. They could be able to input a customer’s username or member ID to find out information on their flight, username, password, address, passport number, date of birth, SSN, submit password resets, and lookup upcoming flights for the customer. Security: The Airline Database is cloud-based, and the database is monitored by IT personnel external to. Firewalls and Secure API technology should be enabled to deny unauthorized transmissions or access to the database. personnel will be able to access the database records through an approval process dictated by the airlines for normal or special, elevated, access. Multi Factor 5

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

John Hardegree UMGC, ITEC 630 Authentication (MFA) solutions should be researched to see if an added layer of security would be required for employees to gain access. Performance: Since the Airline Database is controlled by a cloud-based contract, regular performance upgrades, patches, and Information Assurance Vulnerability Alerts (IAVA) updates will be controlled and executed by the external organization to alleviate the need for to keep their system up to date. One of the requirements in the contractual recommendations to the cloud-based provider should be to have scalability and guarantees in place to handle an identified maximum number of customers on the airline website at any given time. H. Specific requirements, if any (interface, operational, resource, performance, etc.) Some specific requirements for the cloud-based database should revolve around what’ requirements on hardware and software. Regular system maintenance using IAVAs, patches should be used. Data recording for historical records and data rollover using Redundant Array of Independent Disks (RAID) hardware need to be used to prevent data crashes. Data monitoring and prevention services should be used to prevent unauthorized access to the database. Phase 2: System and database design A. User interface Design an overall user interface consisting of screens, commands, controls, and features to enable users to use the system. How data will be input to the system? 6

John Hardegree UMGC, ITEC 630 The physical layout for each input The physical layout should be easy to understand, use and be in a logical order. An example would be to have physical address input fields laid out in order as street address, city, state, and zip code. The input design and procedures The input design should be set to alphanumeric for most fields and numeric only for date of birth, social security number, phone number, and passport number. It should be formatted in a logical sense dependent on the type of information required. Example: SSN should be text, but address should be alpha numeric. How data will be output from the system? The physical layout for each output The physical layout for the output of the system should be standard across all users and should bring the user’s attention to what is important based on the user’s input. If the user is wants to input their personal information into their account and selects their profile from the website, the result should be their account information screen. The output design and procedures Outputs should be shown as a direct result of the user inputs. If you are searching for flights, after inputting flight dates and city information into the flight search bar, you should get results for all flights flying on those specified days and from that specified location. Results should be able to be sorted using the user’s preference of things like cost, time of flight departure, time of flight arrival, and number of stops. 7

John Hardegree UMGC, ITEC 630 B. Data design Develop a plan for data organization, storage, updating, and retrieval. Database design Entity-relationship diagrams Data file storage and access 8

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

John Hardegree UMGC, ITEC 630 Data file storage consists of master, look-up, historical, audit, and transaction files. These files would either be the source or would supplement another. The master file is the source of the other files derive their information from. An example of this would be using the look-up to find customer mailing information to send out advertisements for members. Of course, access to certain files needs to be restricted to those who require access and have a need to know. Data for should be limited to commonly used software applications. In this case, it is recommended that the airline uses Microsoft Office products due to the likelihood employees have used their products and are familiar with the capabilities of each program in Office. C. System architecture Determine the architecture of the system as Web-based interface, client/server architecture, Internet/Intranet interface, network configuration, etc. In the recommended system architecture, I suggested using cloud-based solutions to supplement hardware, software, and security concerns. It is broken down into four sections: Customer, the cloud, the FAA, and Customer Service. The customer would access the airline database using a web browser or phone application. This is where the customer interfaces with airline application. The customer is limited to permissions and is limited to the functions they can perform. Basic access is a requirement and consists of inputting customer information, searching for, and purchasing seats on available flights. The cloud consists of database services controlling and managing servers, storage, data management, and security. 9

John Hardegree UMGC, ITEC 630 Phase 3: Project Plan 10

John Hardegree UMGC, ITEC 630 11

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ITEC 630 - Individual Project

Related Documents