Chapter 5Relational Database Design
Since Chapter 2, we’ve worked with a very
simple database of jokes, composed of a single table named, appropriately
enough, joke
. While this database has
served us well as an introduction to MySQL databases, there’s more to
relational database design than can be understood from this simple example.
In this chapter, we’ll expand on this database and learn a few new features
of MySQL, in an effort to realize and appreciate the real power that
relational databases have to offer.
Be forewarned that I will cover several topics only in an informal, nonrigorous sort of way. As any computer science major will tell you, database design is a serious area of research, with tested and mathematically provable principles ...
Get PHP & MySQL: Novice to Ninja, 5th 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.