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