Chapter 3. Designing and Building a Database
In This Chapter
Planning your database
Designing a sample database
Constructing your database
Restructuring your database
The first step in creating a database is to design it. You design a database before you ever put finger to keyboard to create that database. Planning is perhaps the most important step. It's very painful to discover after you build the database and put it in service that it doesn't contain all the data or provide the relationships between data that you need.
After completing your database design, you're ready to build that database. You create the database and its tables according to the design you developed. When it's built, you have a useful, empty database, waiting for you to fill it with data. You can read about adding and retrieving data in Chapter 4 of this minibook.
Get PHP & MySQL® Web Development All-in-One Desk Reference for Dummies® 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.
