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