Lesson 3.1
Data Management Approaches
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.
Grade 11 Information Technology · Unit 3
Unit 3 of the Grade 11 Information Technology textbook has 3 lessons: Data Management Approaches, Data Models and Creating a Relational Database in Microsoft Access.
Lesson 3.1
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.
Lesson 3.2
A data model is a way of describing how data is structured, how pieces of data relate to each other and what rules apply to them. It acts like a plan or blueprint for a database.
Lesson 3.3
Microsoft Access is a relational DBMS that is part of Microsoft Office.
3 of the 6 questions in the Unit 3 quiz. Try each one, then reveal the answer.
1. Which problem is typical of the traditional file-based approach to data management?
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.
2. In the relational model, a row of a table is also called a:
Answer: Record (tuple)
Each row describes one entity instance and is called a record or tuple; columns are fields (attributes).
3. In Microsoft Access, which object is used to ask questions of the data, e.g. 'list all students older than 17'?
Answer: Query
Queries select, filter and sort data from tables according to criteria.
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.