Database Design and Relational Theory
by C. J. Date · C.J. Date
C.J. Date grounds schema design in the formal relational model, working through functional dependencies, normal forms up to fifth and sixth, and why each matters. Prior comfort with SQL and set theory is assumed.
This link may earn us a small commission at no extra cost to you. Affiliate disclosure
More resources on Database Design
vertabelo.com
Vertabelo is an online data modeling and database design platform that lets you create and visualize ER diagrams, design schemas, and generate SQL code. It also offers tutorials, articles, and resources on database design best practices for learners and professionals.
use-the-index-luke.com
A practical guide to database indexing and query optimization, offering clear explanations of how indexes work, how to design them, and tutorials with SQL examples across major relational databases.
dbdiagram.io
A browser-based diagramming tool where you write schemas in a simple DSL and it renders the entity-relationship diagram automatically. Useful for sketching tables, keys and relationships, then exporting SQL DDL or sharing the diagram.
Database Star
Ben Brumm's tutorial site covering SQL syntax across Oracle, PostgreSQL, MySQL and SQL Server, plus normalization and schema modelling guides. Articles include runnable scripts and sample datasets, so readers can practise each design or query technique directly.
Database Design for Mere Mortals
A vendor-neutral, step-by-step method for relational design: identifying entities, defining fields and keys, establishing table relationships and applying business rules. Readers finish able to produce a normalized logical schema before writing any SQL.
Database Design
University of Colorado Boulder course, part of its data science master's, covering the relational model, entity-relationship modelling and normal forms. Learners translate requirements into an ER diagram and then into normalized SQL table definitions.