Because databases often stay in production for decades, careful design is critical to making the database serve the needs of your users over years, and to avoid

What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design

This concise guide sheds light on the principles behind the relational model, which underlies all database products in wide use today. It goes beyond the hype t

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into pr

All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products tru