WeLearn

Grade 11 Information Technology · Lesson 3.1

Data Management Approaches

Unit 3: Database Management

Data management is the way an organisation collects, stores, organises, protects and retrieves its data. Two main approaches exist: the traditional file-based approach and the database approach. Understanding their differences explains why almost every modern organisation, from banks to schools, uses databases.

Key terms

Database
organised, shared collection of related data
DBMS
software that creates, manages and controls access to a database
Data redundancy
unnecessary repetition of the same data
Data inconsistency
different copies of the same data that do not agree
Data integrity
accuracy and consistency of stored data
Data independence
ability to change data storage without changing programs
All Grade 11 Information Technology key terms →

Summary

  • File-based systems keep separate files per department.
  • They cause redundancy, inconsistency, poor sharing and weak security.
  • A database managed by a DBMS stores data once and shares it securely.
  • Databases cost more and need backups and skilled staff.

In everyday life: Ethiopian banks moved from paper ledgers in each branch to central core-banking databases, so you can now withdraw money from any branch.

Check yourself

  • What is a DBMS? Name two examples.
  • Explain data redundancy with an example.
  • Give three advantages of the database approach.
  • Why is a spreadsheet not a full database?

Practice questions

  1. 1. Which problem is typical of the traditional file-based approach to data management?

    • A. Data redundancy and inconsistency
    • B. Too much data security
    • C. Automatic backup
    • D. Central control
    Show answer

    Answer: Data redundancy and inconsistency

    When each department keeps its own files, the same data is stored many times and copies drift apart; a DBMS reduces this.

On WeLearn

The full lesson: reading notes, worked examples, class activities and the Unit 3 quiz

Study Data Management Approaches on WeLearn

Teach Data Management Approaches with WeLearn

We will bring a demo to your school: a lesson on your interactive TV, a virtual lab and a classroom game, with your own teachers.