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 ...

Get Visual Basic® .NET Database Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.