Random Processing:
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 |
This is a rather simplistic approach, but I feel it gets the point across:
Index to Master File:
Idno |
Record |
11111 |
1 |
12345 |
2 |
13456 |
3 |
14567 |
4 |
15678 |
5 |
16789 |
6 |
17890 |
7 |
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 |
15678 |
|
|
|
|
24 |
|
C |
16789 |
|
|
|
|
|
|
D |
14444 |
|
|
|
3.8 |
|
|
C |
13333 |
Richard Smith |
CIS |
CIB |
3.0 |
15 |
RI |
A |
17777 |
|
|
|
|
|
MA |
C |
14666 |
|
|
|
|
|
|
D |
12345 |
|
CIS |
CIT |
|
|
|
C |
13456 |
Amy Jones |
CIS |
CIC |
3.2 |
15 |
MA |
A |
15678 |
|
|
|
|
|
RI |
C |
Your assignment is to show me the changes to the Master File and the output on the error report. To do this, you should use the random processing logic discussed on the PowerPoint presentation.
When you want to retrieve a master record, look up the record in the index and determine what record it is on the master file and process according.