Grade 12 results are out. Where to check yours

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 page

Everything 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 free

Temari.et is also an Android app, free on Google Play.

Sign inCreate your account