WeLearn

Grade 11 Information Technology · Unit 3

Database Management

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 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.

DatabaseDBMSData redundancyData inconsistencyData integrityData independence

Lesson 3.2

Data Models

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.

Data modelEntityAttribute (field)Record (tuple)Primary keyForeign keyER diagram

Practice questions

3 of the 6 questions in the Unit 3 quiz. Try each one, then reveal the answer.

  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.

  2. 2. In the relational model, a row of a table is also called a:

    • A. Field
    • B. Record (tuple)
    • C. Schema
    • D. Query
    Show answer

    Answer: Record (tuple)

    Each row describes one entity instance and is called a record or tuple; columns are fields (attributes).

  3. 3. In Microsoft Access, which object is used to ask questions of the data, e.g. 'list all students older than 17'?

    • A. Table
    • B. Query
    • C. Report
    • D. Macro
    Show answer

    Answer: Query

    Queries select, filter and sort data from tables according to criteria.

Teach Information Technology Unit 3 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.