Views are virtual tables. That means they should be updatable, just as "real" or base tables are. In fact, view updatability isn’t just desirable, it’s crucial, for practical reasons as well as theore
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 truly relational? Sadly, the answer is no. Th
As more and more people turn to databases for both large systems and small web-based applications, misunderstandings arise about the precise meaning of terms like "join", "instantiation
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 that theory into practice. In this book, Chris Date explai
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 theory are aimed primarily at theoretic
A master at tying complex theoretical concepts to their real-world implications, CJ Date here takes aim at type inheritance, a concept for which many programmers have an intuition, but not a theoretic
This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world t