Grade 11 Information Technology unit 3
Entities, attributes and how they relate
4 min · 2 past exam questions worked through
Parts of the lesson
Tap a part to play the lesson from there.
A 4-minute Temari video lesson on Grade 11 Information Technology unit 3: Entities, attributes and how they relate. Free to watch, no account needed.
More on unit 3
The chapter's own page holds the rest of what Temari has on it, such as short notes and practice questions with their answers.
Open the unit 3 pageEverything the lesson says
The lesson's words, part by part. Tap a time to play the lesson from there.
0:00Introduction
Before anyone builds a database, they plan it. What things will it store? What will it record about each one? And how are those things linked? Your book calls this plan the data model. Learn its three parts, and you can read any database.
0:17The blueprint of a database
A data model is the blueprint of a database. It shows three things. First, entities: the people, places or events you want to store data about. A bank keeps data about customers and bank accounts. In the database, each entity becomes a table.
Second, attributes: the properties of an entity, which tell one entity apart from another. A customer has a customer id, a name, a sex and an address.
Third, relationships: an association between entities. A customer has an account. That verb, has, names the relationship.
1:03The Student table
Here is part of the student table from your book. The entity is student, so the table is called Student. Each column is an attribute: student ID, sex, grade and name.
Each row is a record: one real student. And look at the student ID. No two students can have the same one. A field with a unique value for each record is called the primary key.
1:31Practice question 1Past exam
Here is a practice question. In a bank database, customer is an entity. Which of these is an attribute of the customer entity? Pause the video, and try it.
An attribute is a property of the entity. Customer id describes a customer, and tells one customer from another. The answer is B. Has is the verb that names a relationship. A bank account is an entity of its own. And a relationship is a link between entities, not a property of one.
2:10Three kinds of relationship
Relationships come in three forms, and they count instances. An instance is one single case of an entity: Addis Ababa is an instance of the entity city.
One-to-one: each instance goes with only one instance on the other side. A country has one capital city, and a capital city belongs to only one country.
One-to-many: one instance goes with many. One department, like Computer Science, has many students. Many-to-many: many on both sides. An employee may work on many projects, and a project may have many employees.
2:52Practice question 2Past exam
Try this one. A country is associated with one capital city, and a capital city is associated with only one country. What type of relationship is this? Pause, and try it.
Count each side. One country, one capital. One capital, one country. One on both sides is one-to-one. The answer is A. One-to-many would need a country with many capitals. Many-to-many needs many on both sides. And a primary key is a field with a unique value, not a kind of relationship.
3:34Summary
So remember. An entity is who or what you store data about, and it becomes a table. An attribute is a property of an entity, a column in that table. A relationship links entities: one-to-one, one-to-many, or many-to-many. Keep practising questions like these on Temari.et.
Practise this unit in the app
Temari turns this chapter into timed practice and marks it as you go, with an AI tutor to explain anything that did not land.
Start freeTemari.et is also an Android app, free on Google Play.

