Database Design and Relational Theory: Normal Forms and All That Jazz

by C.J. Date

Part I. Setting the Scene
Chapter 1. PreliminariesChapter 2. Prerequisites
Part II. Functional Dependencies, Boyce/CODD Normal Form, and Related Matters Chapter 3. Some GeneralitiesChapter 4. FDs and BCNF (Informal)Chapter 5. FDs and BCNF (Formal)Chapter 6. Preserving FDsChapter 7. FD AxiomatizationChapter 8. Denormalization
Part III. Join Dependencies, Fifth Normal Form, and Related Matters Chapter 9. JDs and 5NF (Informal)Chapter 10. JDs and 5NF (Formal)Chapter 11. Implicit DependenciesChapter 12. MVDs and 4NF
Part IV. Further Normal Forms Chapter 13. ETNF, RFNF, SKNFChapter 14. 6NFChapter 15. The End Is Not Yet
Part V. Orthogonality Chapter 16. The Principle of Orthogonal Design
Part VI. Redundancy Chapter 17. We Need More Science
Part VII. Appendixes Chapter 18: Appendix A. What Is Database Design, Anyway?Chapter 19: Appendix B. More on ConsistencyChapter 20: Appendix C. Primary Keys Are Nice but Not EssentialChapter 21: Appendix D. Historical Notes

Genres: Technical, Technology, Computer Science, Programming, Textbooks

472 pages, Paperback

First published January 1, 2012

About the author

Christopher J. Date (born 1941) is an independent author, lecturer, researcher, and consultant, specializing in relational database theory.
—from wikipedia

Reviews

[Helen Mary · Rating 5 out of 5]

It's not a dry database textbook. it's not beginner friendly though. It assumes you know about the basics like the NFs and the redundancies. The approach is mathematical and very much grounded on author's experience. I like how I can consider this a foundational read in developing apps even in the age of cloud.

[Daniel · Rating 4 out of 5]

This book presents enough theory for a formal discussion, and also ilustrates with examples.

It seems to be as close to practical a theoretical book can be.

[James A · Rating 4 out of 5]

A bit heavy but a great read that helps to both sharpen current skills in database planning and development as well as getting a broader perspective on current perspectives of relational theory