Create a table of entities and activities

Assignment Help Other Subject
Reference no: EM13858102

NARRATIVE
The Customer receives a Travel Guidebook from Bookit, then reads the book and chooses locations. The Customer also views locations on Google Maps using the Map Program as well as the Earth and Satellite Master files. After comparing information in the guidebook with information on Google Maps, the Customer makes Flight Selections on the Hotwire site using the Flight Program by retrieving information from the Flights Master file and entering information into the Flights Transaction file. The Customer also prints an Itinerary using the Flight Program and the Flights Master and Transaction files.

After Hotwire receives the Flight Selections from the Customer, they are processed using the Flight Program by retrieving data from the Flights Master file and updating the Flights Transaction file. The Flight Selections are then forwarded to Expedia, who then forwards them immediately to the Airline. The Airline also receives Air Traffic Reports from the Airports and Safety Alerts from the Governments. The Airline uses the Flight Selections received to search for current prices using the Flight Program and Flights Master file, then sends a Price Quote to Expedia. Finally, the Airline prints a Price Confirmation using the Flight Program and the Flights Master and Transaction files and files it in the Price Confirmations file cabinet by flight number then by date.

After receiving the Price Quote from the Airline, Expedia displays the current prices to the Customer using the Flight Program and the Flights Master and Transaction files. Expedia then processes the customer payment using the Accounts Payable Program which updates the Flights Transaction file and enters a new record into the Payments Transaction file. Finally, Expedia sends a Payment Confirmation to Hotwire.

Hotwire creates a confirmation email using the Email Program and the Flights Transaction file, then sends the email to the Customer. Hotwire also prints a Flight Confirmation using the Flight Program and the Flights Master and Transaction files and files it in the Confirmed Flights file cabinet by customer name then by date. After receiving the email, the Customer compares the information in the email with the previously printed Itinerary, then files the Itinerary in the Travel file cabinet by location.

INSTRUCTIONS:

Create one file in Excel with two worksheets (use a new, blank file).

Name the first worksheet "Table" and create a Table of Entities and Activities.

Name the second worksheet "Flowchart" and create a Document Flowchart.

Reference no: EM13858102

Questions Cloud

Question regarding the middle-class squeeze : 1. What is the "middle-class squeeze"? 2. How do low unemployment rates mask the economic challenges people face in maintaining middle-class status?
Statement of retained earnings and a balance sheet : Prepare an Adjusted Trial Balance and prepare an Income Statement, Statement of Retained Earnings and a Balance Sheet.
Dawes road and jeff hamilton road intersection redesign : Dawes Road and Jeff Hamilton Road Intersection Redesign. The Mobile County and Alabama Department of Transportation desire a redesign of the intersection of Jeff Hamilton Road and Dawes Road due to safety issues and poor level of service.
Quantity theory of money : QUESTION 1: According to the quantity theory of money, the quantity of money determines the
Create a table of entities and activities : Create one file in Excel with two worksheets - Name the first worksheet "Table" and create a Table of Entities and Activities.
Develop a context diagram and system level data flow diagram : Develop a Context Diagram and a System Level Data Flow Diagram , make sure you properly identify all the components. Develop an ERD as well making sure you properly label the Entity name.
Conduct audit of the jabin hopkins institute of technology : In Part A you are required to conduct an audit of the Jabin Hopkins Institute of Technology (JHIT) site. This audit requires you to collect a range of information about JHIT's organisational Workplace Health and Safety framework. You will also co..
Define successful implementation of an accounting standard : Briefly describe the current thinking with respect to convergence and IFRS - Briefly describe one of the observations made by the Staff that you believe is worth noting.
What risk is associated with the hazard : You will then research and analyse each hazard identifying the following: What is the hazard? What risk is associated with the hazard? Why are the current control(s) inadequate

Reviews

Write a Review

 

Other Subject Questions & Answers

  What psychological adjustments are made during early

What psychological adjustments are made during early and middle adulthood to adapt to aging and changes in life style? How does this affect development?

  Compare fundamental differences between arrest and searches

Compare and contrast the fundamental differences between arrest and searches and seizures conducted with and without warrants.

  Cognitive-behavioralists assert maladaptive behavior

Cognitive-behavioralists assert maladaptive behavior is the result of the way we ______________ and ___________________.

  Standardization is not always a viable option

Price elasticity is how demand changes when price changes. Markets can only be segmented in a set number of ways. Which of the following is a reason why standardization is not always a viable option?

  Compiling environmental news articles

The objective of Verdant World News is to offer a one-stop-shop resource for media from around the world as it pertains to the environment, energy, climate, and general well-being and future of the earth. We monitor environmental news daily and trust..

  What is the name of this psychological test

As part of the initial screening for possible employment, a nuclear power company administers a psychological test that yields scores on tendencies toward depression, schizophrenia, and psychasthenia. What is the name of this psychological test?

  What factors may have inhibited the growth of the hwc

What are the key factors that explain the growth to date of the HWC? What are the growth accelerators for the future? What factors may have inhibited the growth of the HWC? What factors might inhibit it in the future?

  Eliminate the spread of infection and disease

There are five key engineering methods developed to reduce or eliminate the spread of infection and disease. How effective do you think these methods have been?

  The purppose of training is multi-fold

"The purppose of training is multi-fold. Training may be required for several purposes". In the light of this statement discuss the various types of employee training.

  Protected populations

In social research, the term “protected populations” refers to _____.

  What is the policy consideration behind the relevant rule

The Police Commissioner is under pressure to solve a murder and offers $100,000 for information leading to an arrest and conviction of the culprit.

  Web resources designer babies

Web Resources Designer Babies

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd