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.