Click here to go to the Nelson Thornes web site
Information Systems for you
Chapter 12 - How to Describe Information Systems 
» Chapter 1
» Chapter 2
» Chapter 3
» Chapter 4
» Chapter 5
» Chapter 6
» Chapter 7
» Chapter 8
» Chapter 9
» Chapter 10
» Chapter 11
» Chapter 12
» Chapter 13
» Chapter 14
» Chapter 15
» Chapter 16
» Chapter 17
» Chapter 18
» Chapter 19
» Chapter 20
» Chapter 21
» Chapter 22
» Chapter 23
» Chapter 24
» Chapter 25
» Chapter 26
» Chapter 28
» Chapter 29
» Chapter 30
» Chapter 31
» Chapter 32
» Chapter 33
» Chapter 34
» Exam Answers
   - Full Course
» Exam Answers
   - Short Course
Questions (Page 94)

 
Things To Do (page 95)
1(a)
 
(b)
  It needs to be in the same order as the master file otherwise there would be too much forward and backward winding of the tape which would take a long time.
(c)
  Their Account Number or Customer Number
(d)
  The primary key field
(e)
  The master file has not been updated by the transaction file.
(f)
  The bottom left tape file on the diagram (i.e. the updated customer file)
(g)
  The old customer file
(h)
After the validation and update stages.
(i)
  The old customer file, the new customer file and the payments transaction file.
 
2(a)
  So that the transactions are in the same order as the master file.
(b)
  Amendment Insertion Deletion
(c)
  Reference to a record which is not included in the master file. An instruction to delete a record which was deleted during the last update.
 
Examination Questions (page 337)
1(a)
  A bar code is read using a scanner.
(b)
  Need to know that item has been accepted. Items could be missed if the rejected signal were used.
(c)
  Quantity in stock
(d)
  Any three from; Supplier code (the primary key field), Supplier name, Fax number, address.
(e)
(i)
(ii)
Item code
To provide a backup to the master file should it become damaged.