CSE Roadmap

Core tier · about 2 hours · 5 parts

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.