
Database Design and Relational Theory
C. J. Date · 2012
Programming and computer science › Databases and distributed data
#11,417 most recommended
Hacker News
3
mentions by 3 people · top 64% of 15,732 books
Open Library
—
No ratings yet
1 want to read
Wikipedia
—
No article yet
About the book
The book covers the relational model as the theoretical foundation for designing databases, focusing on the logical design of relation variables and their constraints. It treats functional, multivalued, and join dependencies, and the normal forms from 1NF through 5NF and DKNF that follow from them. Good database design is a matter of logic, not intuition, and it should be derived from the relational model's formal foundations. Date argues that each relation variable should represent a single, well-defined predicate, and that normalization is the systematic removal of redundancy and update anomalies. He presents domain-key normal form as the ideal target, where all constraints follow from domain and key constraints alone. The book also explains where SQL practice departs from these principles and why those departures matter for correctness.
Written by Claude from what it knows of this book.
What Hacker News says 33% recommend · 0% critical
In the commenters’ own words
Just about anything written by C. J. Date would be worth your while in this regard. It will give you a solid grounding in the relational model, which you can…
There is a book by c.j date that goes into these . It is very theory based and heavily criticises people for confusing relation and table . Book is Database…
What Open Library readers say
No Open Library reader has rated it yet.
- 1 want to read
- 0 reading
- 0 have read
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
Details
- First published
- 2012
- ISBN
- 9781484255391
- Editions known
- 6 at Open Library
- Open Library
- OL20923136W
Com021000Cs.cmp_sc.app_swCs.cmp_sc.app_sw.dbData miningData modeling & designData processingData warehousingDatabase managementGeneralProfessional, career & trade -> computer science -> data modeling & designProfessional, career & trade -> computer science -> data processingProfessional, career & trade -> computer science -> database managementRelational databases
Read next: its neighbours on the mosaic
SQL and relational theoryC. J. Date · 2009 · recommended by 9 people · similar by subject and what people say about it
An introduction to database systemsC. J. Date · 1975 · recommended by 14 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Database in depthC. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
Time and Relational TheoryC. J. Date · 2014 · recommended by 1 person · similar by subject and what people say about it
The relational model for database managementE. F. Codd · 1990 · recommended by 2 people · similar by subject and what people say about it
Fundamentals of database systemsRamez Elmasri · 1989 · recommended by 2 people · similar by subject and what people say about it
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
Foundations of databasesSerge Abiteboul · 1994 · recommended by 1 person · similar by subject and what people say about it
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
UNIX relational database managementRod Manis · 1988 · recommended by 2 people · similar by subject and what people say about it
Database management systemsRaghu Ramakrishnan · 2001 · recommended by 7 people · similar by subject and what people say about it
Architecture of a database systemJoseph M. Hellerstein · 2007 · recommended by 7 people · similar by subject and what people say about it
The data model resource bookLen Silverston · 1997 · recommended by 8 people · similar by subject and what people say about it
Readings in database systemsMichael Stonebraker · 1998 · recommended by 11 people · similar by subject and what people say about it
Database systemsPeter Rob · 2006 · recommended by 4 people · similar by subject and what people say about it
Data and RealityWilliam Kent · 1978 · recommended by 15 people · similar by subject and what people say about it
Database Reliability EngineeringLaine Campbell · 2017 · recommended by 2 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
Database system implementationHector Garcia-Molina · 1999 · recommended by 3 people · similar by subject and what people say about it
Beginning Database DesignClare Churcher · 2007 · recommended by 2 people · similar by subject and what people say about it
Database InternalsAlex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · similar by subject and what people say about it