SS 2 First Term

Lesson objectives

By the end of the week, learners should be able to:

1. Define a database and describe its purpose in an organisation.
2. Name the main components of a database schema.
3. Distinguish relational and non-relational structures briefly.
4. Create a simple table schema with fields, types and constraints.
5. Explain why indexing speeds up queries.

Key vocabulary

• Database: a structured collection of related records.
• Schema: the design defining tables, fields and relationships.
• Table: a collection of related rows and fields.
• Field: a column holding a characteristic of each record.
• Constraint: a rule limiting what data may enter a field.
• Index: a sorted lookup structure speeding query searches.
• Query: a request returning records matching criteria.
• Relational: a tabular structure holding tables linked by keys.
• Non-relational: a document or graph structure storing loose data.
• Speeds up: makes something faster through a structural aid.

Common misconceptions

• "A database is just a big spreadsheet." Databases enforce constraints and relationships that spreadsheets ignore.
• "Tables store unrelated rows." Related rows belong together because of shared field types.
• "Indexing adds unrelated overhead." Indexing speeds queries substantially without changing stored values.

Teacher activities

1. Starter: ask where a school keeps student records if not on a teacher's desktop.
2. Define a database and describe its organisational purpose.
3. Name the main schema components one by one.
4. Briefly distinguish relational from non-relational structures.
5. Create a simple table schema on the board for a student records table.
6. Demonstrate how an index speeds a query lookup.

Student activities

1. Answer the starter and identify the right storage location.
2. Define a database in their own words and state its purpose.
3. Name the main schema components in one sentence each.
4. Distinguish relational from non-relational structures briefly.
5. Create a simple table schema with fields, types and constraints.
6. Explain why an index speeds up queries in one paragraph.
7. Answer the exit question in one sentence about databases versus spreadsheets.

Practical / learning evidence

A one-table schema worksheet with fields, types and constraints, plus an index explanation paragraph. Submit both for marking.

Resources and preparation

Printed schema templates, sample student data and index example cards. Offline route: paper templates, no device needed. Provide an index example drawn simply on paper.

Assessment for learning

Inspect the schema for correct field names, types and at least one constraint. Mark the index explanation for a plausible lookup analogy. Flag any learner who calls the database a big spreadsheet.

Inclusion and homework

Provide the schema prefilled for the field names and allow oral constraint completion. Extend confident learners with two tables linked by a foreign key and a second index example. Homework: name one advantage and one disadvantage of a relational database over a spreadsheet.