← Back
T1W3L1

Data modelling: entities, attributes, relationships

Conceptual data modelling

Devotional (5 minutes)(click to expand)
1 Corinthians 12:12
“Though one, [the body] has many parts.”
Christian perspective

Systems have connected parts; good design respects how parts work together.

Secular perspective

Clear models improve data integrity and reduce duplication.

Scenario

A student stores all information in one big table with repeated fields.

What issues can repetition cause in data?

Lesson flow

OPENING5 min
Teacher
  • Entity/attribute modelling overview.
Students
  • List 3 entities for your idea.
ACTIVITY15 min
Teacher
  • Create a draft entity list with attributes.
Students
  • Write attributes for 2–3 entities.
WORKBOOK15 min
Teacher
  • Add relationship notes and keys at a high level.
Students
  • Describe relationships and identify a likely key field.
Workbook questions
  1. List 3–5 entities and 3–6 attributes each (privacy-safe, minimal).
  2. Describe relationships between entities (e.g., one user can create many items).
WRAP5 min
Teacher
  • Exit: one data integrity risk + fix.
Students
  • Record risk + mitigation.

Resources

No resources listed for this lesson yet.

IA1 Draft Checker

Write your own response first. This tool checks alignment with the IA1 marking guide and suggests improvements. It does not write answers.

Question
List 3–5 entities and 3–6 attributes each (privacy-safe, minimal).
Dictation unavailable
Teacher tools
Loading teacher tools…