First edition, 2025

Database Design Book

Learn how to get from business requirements to a database schema

The goal of this book is to help you get from a vague idea of what you need to implement (e.g.: “I need to build a website to manage schedule and instructor appointments for our gym”), to the comprehensive definition of database tables.

To achieve the goal, first we show how to build a structured list of anchors, attributes and links. To understand the business requirements, we spell out what each element does, using carefully designed formalized sentences. After that, we can build a physical model based on the logical model, in a straightforward way.

Book length: 145 pages, ~32.000 words. Available in both ebook-friendly PDF and in EPUB format. See table of contents and PDF chapter excerpts.

or,

More than 100 copies sold. If you find that the book is not what you were looking for, just send me an email and I’ll issue a refund, no questions asked.


Extra materials: https://kb.databasedesignbook.com/

  • database design case studies;
  • SQL;
  • classic relational modeling topics;
  • graphical notation.

Database Design Book cover

Subscribe to receive book updates and extra materials

Database design case studies, SQL advice, data modeling research.

    We respect your privacy. Unsubscribe at any time.

    My name is Alexey Makhotkin, I’ve been working with databases for more than 25 years in various roles: software engineer, database administrator, team lead, head of software engineering. I've built dozens of schemas along the years.


    A few years ago I started the “Minimal Modeling” substack: https://minimalmodeling.substack.com/, to summarize what I’ve learned along the way. This book is another step in that direction.

    or, alternatively:

    VAT ID: NL005240201B52