TY - BOOK AU - Date,C.J. TI - SQL and relational theory: how to write accurate SQL code SN - 9789350236086(pbk) U1 - 005.7565 2nd ed. KW - Relational databases N1 - 1. Setting the scene -- 2. Types and domains -- 3. Tuples and relations, rows and tables -- 4. No duplicates, no nulls -- 5. Base relvars, base tables -- 6. SQL and relational algebra I : the original operators -- 7. SQL and relational algebra II : additional operators -- 8. SQL and constraints -- 9. SQL and views -- 10. SQL and logic -- 11. Using logic to formulate SQL expressions -- 12. Miscellaneous SQL topics N2 - Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. This book demonstrates how you can apply ER -