Database Design Concepts is one of 10 topics in the Grade 12 Information Technology CAPS syllabus, covered across 3 lessons on Study Vault. Below are real practice questions from this topic with full worked answers.
Sample practice questions
Easy
1. In a database table, what does a single record (row) represent?
One complete instance of the entity the table describes, such as one specific student
One single piece of information, such as a surname
The entire database as a whole
The software used to manage the database
Answer: One complete instance of the entity the table describes, such as one specific student — A record (row) represents one complete instance of the entity a table describes, for example one specific student's full set of details.
Easy
2. What is the main purpose of a Database Management System (DBMS)?
To allow users and applications to create, read, update and delete data while managing security, integrity and concurrent access
To physically manufacture computer hardware
To provide internet connectivity to a network
To compress files to save storage space
Answer: To allow users and applications to create, read, update and delete data while managing security, integrity and concurrent access — A DBMS is software that enables data to be created, read, updated and deleted, while also managing security, data integrity and safe concurrent access by multiple users.
Medium
3. Name the term for one particular piece of information about an entity within a database record, such as a student's date of birth (also called a column or attribute).
Answer: field — A field (also called a column or attribute) represents one particular piece of information about the entity described by a record, such as a date of birth.
