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: 137 pages, ~30.000 words. Available in ebook-friendly PDF format. See table of contents and PDF chapter excerpts.
Extra materials: "Database Design for Google Calendar: a tutorial"; "Historized attributes: systematic table design"; "Many yes/no attributes: table design study".