information handling software

Benefits of databases
1. Fast access to data
2. Easy to edit data
3. Can validate data
4. Can create reports
5. Can share database with users
6. Security (passwords)
Validation methods
1. Range check
  1. Type check
    1. Length check
      1. Lookup list
        Picture/format check
        Presence check
        Check if data has been entered
        Data has a particular pattern the computer compares it to other accepted records
        compare with a list of allowed answers
      2. No. characters used is reasonable
    2. Correct data type (text/number)
  2. Data entered in a sensible range
Security issues
1. consequences
  1. Loss of customers
    1. Payments for goods not recieved
      1. Bad publicity
        Cash flow problems
        Management cannot make decisions due to lack of information
2. Secure data:
  1. Cannot be destroyed
  2. Cannot be accidentally/purposefully changed
  3. Cannot fall into the hands of unauthorised personel
How to keep data secure
1. Password systems
2. Back-ups
3. File attributes (read only files)

Resource summary

	Created by Matthew Stentiford about 7 years ago