Activity : File update
[1]

A trivial example of an update run! 

A paint shop's Master File.....(small shop!!) :

Code

Description

Colour

Selling Price

No. Sold

C105

Matt

Primrose

£9.00

4

C106

Matt

Lilac

£9.00

5

C120

Silk

Primrose

£9.00

2

C121

Silk

Lilac

£9.00

1

C123

Silk

Plum

£9.00

0

C124

Matt

Magnolia

£7.00

7

C125

Matt

Jade

£7.00

3

The Transaction File for yesterday looks like :

Code

No. Sold

C106

1

C120

2

C121

1

C125

3

 
Complete the master file below to show the New Master File after the update run:
Code

Description

Colour

Selling Price

No. Sold

C105

Matt

Primrose

£9.00

C106

Matt

Lilac

£9.00

C120

Silk

Primrose

£9.00

C121

Silk

Lilac

£9.00

C123

Silk

Plum

£9.00

C124

Matt

Magnolia

£7.00

C125

Matt

Jade

£7.00

 

(If all your answers are correct, the green light will show...)

   Back