Activity 10 : File update

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

WELL DONE!!

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