DeepRead
Cover of Database Design and Relational Theory

Database Design and Relational Theory

C. J. Date · 2012

Programming and computer science › Databases and distributed data

#11,417 most recommended

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

024201220142016201820212012 peak · 1
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say

No Open Library reader has rated it yet.

  • 1 want to read
  • 0 reading
  • 0 have read

Open Library’s page for the book

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

Explore in the mosaic

Read next: its neighbours on the mosaic