WeLearn

Grade 12 Information Technology · Lesson 3.1

Overview of Relational Database Management Systems

Unit 3: Database Management System

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. Examples include MySQL, PostgreSQL, Microsoft Access, SQLite, Oracle and SQL Server. Compared with keeping data in separate files, a DBMS reduces duplication (redundancy), keeps data consistent and enforces security.

Key terms

Database
an organised collection of related data
DBMS
software that manages databases
Table (relation)
data arranged in rows and columns
Record (row/tuple)
data about one item
Field (column/attribute)
one property of the item
Primary key
a field that uniquely identifies each record
Foreign key
a field referring to another table's primary key
Normalisation
organising tables to reduce redundancy
All Grade 12 Information Technology key terms →

Summary

  • A DBMS manages data securely and consistently.
  • Relational databases use tables of rows and columns.
  • Primary keys identify records; foreign keys link tables.
  • Integrity rules and normalisation keep data reliable.

In everyday life: Ethiopian banks, the national exam agency and hospitals all store records in relational databases so information about millions of people stays accurate and searchable.

Check yourself

  • What is the difference between a record and a field?
  • Why can a primary key not be null?
  • Give an example of a one-to-many relationship.

Practice questions

  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.

On WeLearn

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

Study Overview of Relational Database Management Systems on WeLearn

Teach Overview of Relational Database Management Systems 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.