Question: a. Create a Level Zero data flow diagram. Ensure that it is balanced with the context diagram. b. Create table specifications for the following tables:

a. Create a Level Zero data flow diagram. Ensure that it is balanced with the context diagram.

b. Create table specifications for the following tables: account holder, miles earned, miles used, miles used / account holder.

c. Suggest at least two queries that would be useful to the airline and / or the account holder based on the tables you created. For each query, indicate its purpose and the tables and fields you would access to create it.

Step by Step Solution

★★★★★

3.47 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b Account holder table Account holder ID account holder last name account holder first name accoun... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Information Systems Questions!

a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the internal control weaknesses in the system. Model your response according to...

Create a context-level data flow diagram for the Employee Benefit system in Problem 7. Make any assumptions about the data to and from the central process. Do you find this to be better or not as...

So the project involves more than simply performing maintenance work on the current programs, Chip says. Are we using a formal methodology for analyzing and designing the new system? Yes, replies...

IFSM 461: Systems Analysis and Design Precision Electronic Parts, Inc. Case Study Introduction This case study will be used for a series of staged assignments. It should be thoroughly read and...

ACCT360 Final Project Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and...

The documents show a narrative of the revenue and expenditure cycles. I need help completing the parts down below a.-c. The textbook picture shows COSO's internal control model. So how do I prepare...

Only Answer last five questions THERMO-CHEM, INC. Case

NASA/SP-2011-3422 Version 1.0 November 2011 NASA Risk Management Handbook NASA/SP-2011-3422 Version 1.0 NASA Risk Management Handbook National Aeronautics and Space Administration NASA Headquarters...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

I have attached the corresponding lessons for assignment 8, it usually includes practice problems at the bottom that look similar to the assignment. ASSIGNMENT 7 JOB ORDER COSTING Directions: After...

a) Key Customer Relationships b) Value Proposition s Channels d) Revenue Streams called: a) Ideation b) Value Proposition c) Research d) Business Model Canvas 7. Sumia is collecting data that has...

20-21. Standard addition. To measure Ca in breakfast cereal, 0.521 6 g of crushed Cheerios was ashed in a crucible at 600C in air for 2 h.32 The residue was dissolved in 6 M HCl, quantitatively...

Outstanding common stock is stock: Multiple Choice 0 0 : 0 5 4 3 that is performing well on the New York Stock Exchange. held in the corporate treasury. that has been authorized by the state for...

8 Explain in principle what projective techniques are. Discuss how such techniques can help develop creative strategy using examples of brands to illustrate.

a. What are the elements of COSOs enterprise risk management framework? b. What is business process management? List and discuss the steps managers often use to change a business process. c. List and...

In Chapter 3, Exercise 8, you developed a risk/control matrix for two of the Fortune 100 companies. Develop a full enterprise risk management plan for one of them; use the COSO framework to structure...

Match each item on the left with the most appropriate item on the right. 1. Behavioral issues..... a. First step in BPM 2. Control activities..... b. Fraud & resistance to change 3. Define...

The Snedecker Corporation is considering a change in its cash-only policy. The new terms would be net one period. The required return is 1.6 percent per period. Based on the following information,...

QUESTION 6 If the simple CAPM is valid and all portfolios are priced correctly, which of the situations below is possible? Consider each situation independently, and assume the risk-free rate is 5%....

what is a compensating control in security controls?