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.