Chapter 15. Understanding the Database Design Process

In this chapter, you learn the following:

Some advantages to good database design

Three types of table relationships

How to normalize your database

How to implement a good database design process

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

The Importance of Good Database Design

A good database design is crucial for a high-performance application, just as an aerodynamic body is important to a race car. If a car does not have smooth lines, it produces drag and goes slower. Without optimized relationships, ...

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