Chapter 15. Understanding the Database Design Process

In this chapter, you’ll learn the thought processes behind designing a relational database. After this theory-focused chapter, you’ll jump headlong into learning the basic MySQL commands in preparation for integrating MySQL in your own applications.

Topics covered in this chapter are

  • Some advantages to good database design

  • Three types of table relationships

  • How to normalize your database

  • How to implement a good database design process

The Importance of Good Database Design

A good database design is crucial for a high-performance application, just like an aerodynamic body is important to a race car. If the car doesn’t have smooth lines, it will produce drag and go slower. Without optimized relationships, ...

Get Sams Teach Yourself PHP, MySQL and Apache: All in One, Third Edition 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.