# C.J. Date

> 1941– · Computer Scientist, Database Theorist
>
> **Recorded contribution:** Relational database theory; An Introduction to Database Systems; worked with Codd

## How to use this dossier

Read for a causal chain, not a hero story: inherited problem → contribution → mechanism → downstream capability → limit. Then close the page and complete the reconstruction exercise from memory.

## 1. Historical orientation

Christopher J. Date (born 1941) is a database theorist, author, and educator who worked with IBM's relational research community and became one of the model's clearest expositors and critics. His textbook An Introduction to Database Systems trained generations, while later work with Hugh Darwen argued for a more faithful relational language and challenged SQL's nulls, duplicates, and update anomalies. Date did not invent the relational model—that is Codd's contribution—and he should not be described merely as Codd's assistant. His historical role is conceptual precision: distinguish the mathematical model from products that call themselves relational and show why logical consistency matters to database design.

## 2. The problem inherited

Commercial SQL systems adopted parts of the relational model while adding nulls, duplicate rows, and ad hoc behaviors that blurred what relational guarantees actually mean.

## 3. The central contribution

Date systematized relational theory for practitioners and, with Darwen, developed Tutorial D and the Third Manifesto as a rigorous alternative contract for database languages.

## 4. Reconstruct the mechanism

1. Model each relation as a set of tuples over named typed attributes, with keys and constraints stated declaratively.
2. Derive results through closed relational operations so every query result is itself a relation.
3. Represent missing or inapplicable information through explicit modeling choices rather than a generic three-valued null marker.
4. Separate logical relation variables and constraints from physical storage, indexing, and access strategy.

## 5. What changed downstream

- Date's textbooks made relational concepts accessible to students and working database designers.
- His critiques exposed differences among relational algebra, SQL, and implementation practice.
- The Third Manifesto influenced thinking about type systems and relational language design.

## 6. Attribution, limits, and uncertainty

- Codd originated the relational model; Darwen is Date's principal collaborator on the Manifesto.
- Rejecting nulls requires alternative schemas whose complexity and usability must be evaluated case by case.
- Theoretical purity does not alone solve distribution, performance, operations, or application-domain ambiguity.

## 7. Reconstruction lab

Model an employee with an optional commission using both SQL null and explicit subtype relations. Write equivalent queries, evaluate unknown comparisons, and identify which integrity constraints each design makes easier to state.

## 8. Evidence trail

- [C. J. Date](https://en.wikipedia.org/wiki/Christopher_J._Date) — Wikimedia Foundation
- [The Third Manifesto](https://www.thethirdmanifesto.com/) — The Third Manifesto

---

*Research checked 2026-08-09. Dates, roles, and claims about living people are historical snapshots. Linked sources remain the authority; this dossier is original instructional synthesis.*