Question: 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
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 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 inactiv
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
