WeLearn

Grade 12 Information Technology · Unit 3

Database Management System

Unit 3 of the Grade 12 Information Technology textbook has 2 lessons: Overview of Relational Database Management Systems and Database Manipulation Using SQL.

Lesson 3.1

Overview of Relational Database Management Systems

A database is an organised collection of related data, stored so it can be easily accessed, managed and updated. A database management system (DBMS) is the software used to create and manage databases; it controls storage, security, backup and access by many users at once.

DatabaseDBMSTable (relation)Record (row/tuple)Field (column/attribute)Primary keyForeign keyNormalisation

Practice questions

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

  1. 1. A field that uniquely identifies each record in a table is called...

    • A. a foreign key
    • B. a primary key
    • C. an attribute
    • D. a query
    Show answer

    Answer: a primary key

    A primary key must be unique and not null, so it can identify every record exactly.

  2. 2. In a relational database, a row of a table is also called a...

    • A. field
    • B. record
    • C. column
    • D. schema
    Show answer

    Answer: record

    Each row holds all the data about one item, so it is a record (or tuple); columns are fields.

  3. 3. Which SQL command is used to retrieve data from a table?

    • A. INSERT
    • B. UPDATE
    • C. SELECT
    • D. CREATE
    Show answer

    Answer: SELECT

    SELECT queries data; INSERT adds rows, UPDATE changes rows and CREATE defines new tables.

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.