CSE Roadmap

Core tier · about 2 hours · 5 parts

Part 4 of 5 · 2 min read

Why the example stays small, and where it grows

What later levels will add, and why nothing extra is included yet.

Why the example stays small, and where it grows

Think of a model building kept small enough to carry across a room, with new floors added one at a time only when the lesson actually needs them.

In plain words: the bookstore schema includes exactly what has been needed so far, and nothing else. Extra tables or columns added too early would make early modules harder to follow for no benefit yet. Later levels add exactly what their own topic needs: indexes in Level 5, a second database for replication in Level 9, a partitioned version of orders in Level 10, and a document-style reviews feature as a NoSQL comparison in Level 11.

A worked example. Level 2's module on authorization adds roles and permissions around this same schema, not a new business concept. Level 3's modules on normalization will examine whether books.price, stored once per book, is the right design, or whether price history needs its own table, using this same five-table base to reason about.

The key lines. No new code; this part is a map of what is coming, not a new mechanism.

For the curious A capstone returns to this schema

The very last module of this subject, in Level 13, is a capstone that designs a database for the CSE Roadmap platform itself, not the bookstore. The bookstore's job is to carry every mechanism explained along the way; the capstone is where that practice gets applied to a schema built from scratch.

Quick notes

  • The starting schema has five tables: customers, authors, books, orders, order_items.
  • order_items is a junction table, representing the many-to-many relationship between orders and books.
  • authors to books, and customers to orders, are simple one-to-many relationships, written as a direct foreign key.
  • The schema stays deliberately small; later levels add exactly what their own topic needs, on top of this same base.
  • A capstone module at the end of the subject applies everything learned to a brand-new schema, the CSE Roadmap platform's own database.