Question: Create a decision table for a batch update of the COMPUTER MASTER file. There are three types of updates: Add, Delete, and Change. The COMPUTER

Create a decision table for a batch update of the COMPUTER MASTER file. There are three types of updates: Add, Delete, and Change. The COMPUTER MASTER record must be read. If the transaction is an Add and the master is not found, format and write the new COMPUTER MASTER record. Print a valid transaction line on an UPDATE REPORT. For a Change or Delete transaction, print a CHANGE ERROR LINE or a DELETE ERROR LINE if the COMPUTER MASTER record is not found. If the COMPUTER MASTER record is found, check the active code. If the record is inactive and the transaction is an Add, format and rewrite the new COMPUTER MASTER record. Print a valid transaction line on an UPDATE REPORT. For a Change or Delete transaction, print a CHANGE ERROR LINE or a DELETE ERROR LINE. If the COMPUTER MASTER record is active and the transaction is an Add, print an ADD ERROR LINE. For a Change transaction, format the changes and rewrite the COMPUTER MASTER record. Print the VALID TRANSACTION LINE. For a Delete transaction, change the ACTIVE CODE to inactive and rewrite the COMPUTER MASTER record. Print the VALID TRANSACTION LINE.

Step by Step Solution

★★★★★

3.49 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Conditions and Actions 1 2 3 4 5 6 7 8 9 Type of transaction A A A D D D C C C Computer Master re... 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

Document Format (1 attachment)

1045-C-S-S-A-A-D (3313).docx

120 KBs Word File

Students Have Also Explored These Related Systems Analysis And Design Questions!

Create a decision table with three conditions. You can make one up, or use a scenario from everyday life. Either way, be sure to show all possible outcomes.

1. Create a decision table that describes Big State University course catalog regarding eligibility for MIS 260. Show all possible rules. 2. Simplify the table you just created. Describe the results....

1. Create a decision table that describes the movement of inventory. 2. Draw a decision tree that describes the merchandise inventory management process. 3. Name four attributes that you can use to...

E8. Create a decision table for a batch update of the COMPUTER MASTER database table. Information is sent from a regional campus in an XML format containing three types of updates: Add, Delete, and...

Due Week 4: Work Breakdown Structure According to the PMBOK Guide, "the WBS is a deliverableoriented hierarchical decomposition of the work to be executed by the project team, to accomplish the...

After doing many follow-up interviews with Dot Matricks, Anna tells Chip, Ive determined the logic needed to update the PENDING COMPUTER ORDERS data store. Because many computers may be ordered on...

Exercises Note: If you are not using Visible Analyst, you can use a Microsoft Word or Microsoft Excel template for decision tables to do some of the following exercises. The repository information is...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

DON'T SUMMARIZE JUST PARAGRAPH OF WHAT YOU THOUGHT/LEARNED CHAPTER 13 - The phrase "garbage in, garbage out" highlights the importance of input controls. If the data entered into a system are...

A potential-energy function for a two-dimensional force is of the form U = 3x3y - 7x. Find the force that acts at the point (x, y).

Figure shows four penguins that are being playfully pulled along very slippery (frictionless) ice by a curator. The masses of three penguins and the tension in two of the cords are m1 = 12 kg, m3 =...

James has a mortgage balance of $ 1 5 0 , 0 0 0 . 0 0 at 4 . 6 % compounded semiannually. How much longer will it take to pay off the mortgage with monthly payments of $ 8 5 0 than with monthly...

You are managing a project on contract. Your bonus is contingent on the timely completion of the project. The project is behind schedule, but the remaining tasks are easy to complete and wont take...

What are the two main problems identified with prototyping?

List the three main advantages in using prototyping.

How can a prototype mounted on an interactive Web site facilitate the prototyping process? Answer in a paragraph.

People were polled on how many books they read the previous year. Initial survey results indicate that s = 13.7 books. Complete parts (a) through (d) below. Click the icon to view a partial table of...

I've been stuck in this can anyone provide a thorough explanation thanks The traffic controller at Sydney's Kingsford Smith International Airport believes that the main reason for delayed aircraft...

The Short-Line Railroad is considering a $185,000 investment in either of two companies. The cash flows are as follows: Year Electric Co. Water Works 1 $ 95,000 $ 45,000 2 45,000 45,000 3 45,000...