9 · Lesson 1 of 4
What is a database?
Syllabus 9.1Syllabus 9.3
What this lesson covers
- Define a single-table database
- Choose a suitable primary key
Key vocabulary
- Database
- An organised collection of data, stored so it can be searched and sorted.
- Table
- A collection of related data organised into fields and records.
- Field
- One piece of information about each item; a column in the table.
- Record
- All the data about one item; a row in the table.
- Primary key
- A field that holds a unique value for every record, so each record can be identified.
- Single-table database
- A database that stores all its data in one table.
- Query
- A request to search a database for specific data.
Check your learning
- Quick check: 4 questions
- Key vocabulary test: 7 terms
- Activity 1: Fields, records and keys · 6 questions
- Activity 2: Pick the primary key · 5 questions
- Activity 3: Databases quiz · 8 questions