- Computing and data
- Grade 11
Information systems and the data behind them – 11th Grade
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.
All lessons in Information systems and the data behind them (in learning order)
Common 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.