Chapter 2. Database Design
In some ways, building a database is a lot like building any complex application. You start with a set of requirements, analyze the requirements, build something, and then test and revise until what you built satisfies the requirements. Building a database is also similar to building an application in the sense that it’s easy to build something, but building something that works well can be deceptively difficult. Often what you think will be a simple database becomes surprisingly complex as you work with it.
This chapter describes some of the steps you should take to design a database before you start building it. It discusses how to decide what tables the database needs, how the tables should interact, which fields ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access