Sequential
Processing:
Old
Master File:
Idno |
Name |
Major |
Option |
GPA |
NumCrs |
State |
11111 |
John Doe |
CIS |
CIC |
3.0 |
24 |
RI |
12345 |
Linda Hall |
BUS |
BST |
2.8 |
31 |
MA |
13456 |
David White |
CIS |
CIX |
3.4 |
15 |
RI |
14567 |
Ann Page |
CIS |
CIN |
2.3 |
45 |
MA |
15678 |
Susan French |
CIS |
CIW |
3.2 |
36 |
MA |
16789 |
Alan Ross |
CIS |
CIM |
2.6 |
45 |
MA |
17890 |
Jane Alden |
CIS |
CIW |
2.8 |
39 |
MA |
Good
Transactions:
Note: When making a change, only the fields with data entered in the transaction field are changed on the record written to the new master. All other fields stay the same.
Idno |
Name |
Major |
Option |
GPA |
NumCrs |
State |
Action |
12345 |
|
CIS |
CIT |
|
|
|
C |
13333 |
Richard Smith |
CIS |
CIB |
3.0 |
15 |
RI |
A |
13456 |
Amy Jones |
CIS |
CIC |
3.2 |
15 |
MA |
A |
14444 |
|
|
|
3.8 |
|
|
C |
14666 |
|
|
|
|
|
|
D |
15678 |
|
|
|
|
24 |
|
C |
15678 |
|
|
|
|
|
RI |
C |
16789 |
|
|
|
|
|
|
D |
17777 |
|
|
|
|
|
MA |
C |
Your
assignment is to show me the output on the New Master File and the output on
the error report. To do this, you
should use the sequential processing logic discussed on the PowerPoint
presentation.