Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Name the four basic pieces of a relational database and what each one actually is.
- Read a simple schema diagram and say what it claims about the data.
- Explain why "relational" refers to a mathematical relation, not to foreign keys.
- Draw the bookstore schema from the previous module as a labelled diagram.
Every later module keeps using the words table, row, column, schema and key. This page gives each one a precise meaning, once. Nothing after it needs to stop and re-explain basic vocabulary.