# Information systems and the data behind them – 11th Grade

> Written with AI · Grade 11 · 2026-11-01 · https://lessoons.com/en/information-systems-and-the-data-behind-them

Before any table exists, someone decided which events are worth keeping. How an organisation turns what it does into information it can act on: deciding what counts as a thing worth recording, giving every record a key that cannot be confused, asking questions that cross tables, and telling apart a number a system produced from a number a person can use.

## Lessons in this topic (in learning order)

1. [What is What an organisation needs to remember, and why?](https://lessoons.com/en/information-systems-and-the-data-behind-them#lesson-1) (Grade 11) — Before any table exists, someone decided which events are worth keeping. A system that records the wrong things is not fixed by better software, and a system that records everything is not usable at all.
2. [What is Entities, attributes and the relationships that connect them?](https://lessoons.com/en/information-systems-and-the-data-behind-them#lesson-2) (Grade 11) — A model names the kinds of thing an organisation deals with, what is known about each, and how they relate. Getting this drawing right is most of the work, because everything built afterwards inherits its mistakes.
3. [What is Every record needs a key that cannot be confused?](https://lessoons.com/en/information-systems-and-the-data-behind-them#lesson-3) (Grade 11) — Two customers can share a name, a street and a birthday. A key is the promise that one row means exactly one real thing, and choosing a poor one causes damage that surfaces years later.
4. [What is Splitting a wide table so nothing is stored twice?](https://lessoons.com/en/information-systems-and-the-data-behind-them#lesson-4) (Grade 11) — When a supplier's address is written on every one of its orders, changing that address means finding all of them and one will be missed. Normalisation is the discipline of keeping each fact in exactly one place.
5. [What is Turning a question from the business into a query?](https://lessoons.com/en/information-systems-and-the-data-behind-them#lesson-5) (Grade 11) — Someone asks which branches slipped this quarter. Answering means deciding which tables hold the answer, which rows belong in it, and what exactly the word slipped was going to mean.
6. [What is Grouping and summarising: from rows to a figure a manager reads?](https://lessoons.com/en/information-systems-and-the-data-behind-them#lesson-6) (Grade 11) — A summary replaces many rows with one number, and every summary throws something away. Knowing what was thrown away is the difference between a report and a misleading report.
7. [What is Who may see which record, and how long it is kept?](https://lessoons.com/en/information-systems-and-the-data-behind-them#lesson-7) (Grade 11) — An information system holds facts about real people, and both the law and ordinary decency limit who may look and for how long the record should exist at all. These limits are part of the design, not an afterthought.

## Frequently Asked Questions

### What is What an organisation needs to remember, and why?

Before any table exists, someone decided which events are worth keeping. A system that records the wrong things is not fixed by better software, and a system that records everything is not usable at all.

### What is Entities, attributes and the relationships that connect them?

A model names the kinds of thing an organisation deals with, what is known about each, and how they relate. Getting this drawing right is most of the work, because everything built afterwards inherits its mistakes.

### What is Every record needs a key that cannot be confused?

Two customers can share a name, a street and a birthday. A key is the promise that one row means exactly one real thing, and choosing a poor one causes damage that surfaces years later.

### What is Splitting a wide table so nothing is stored twice?

When a supplier's address is written on every one of its orders, changing that address means finding all of them and one will be missed. Normalisation is the discipline of keeping each fact in exactly one place.

### What does Information systems and the data behind them for 11th Grade cover?

How an organisation turns what it does into information it can act on: deciding what counts as a thing worth recording, giving every record a key that cannot be confused, asking questions that cross tables, and telling apart a number a system produced from a number a person can use. The unit includes 7 ordered lessons covering What an organisation needs to remember, and why, Entities, attributes and the relationships that connect them, Every record needs a key that cannot be confused, Splitting a wide table so nothing is stored twice.
