O'Reilly logo

Sams Teach Yourself PHP, MySQL and Apache: All in One, Third Edition by Julie Meloni

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required