Chapter 5Relational Database Design
Since Chapter 2, we’ve worked with a very
simple database of jokes, composed of a single table named, appropriately
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 ...