56,966 blogs · [ { "id": "01a0bb47-8161-7218-99ea-1e3914efd7d4", "title": "Database Design Book", "url": "https://kb.databasedesignbook.com/posts/toc/", "published_at": "2026-09-12T23:00:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf3a79c79", "title": "Historized links, pt. 1 (M:N case)", "url": "https://kb.databasedesignbook.com/posts/historized-links-1/", "published_at": "2026-07-17T18:23:36+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf4a34aea", "title": "Historized links: introduction", "url": "https://kb.databasedesignbook.com/posts/historized-links/", "published_at": "2026-07-12T21:22:05+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf5051e89", "title": "5NF and Database Design", "url": "https://kb.databasedesignbook.com/posts/5nf/", "published_at": "2026-04-11T21:00:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf5d5cdc8", "title": "A modern guide to SQL JOINs", "url": "https://kb.databasedesignbook.com/posts/sql-joins/", "published_at": "2025-11-25T21:56:08+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf5e3ef5d", "title": "State park database: a Minimal Modeling approach (pt. III-b)", "url": "https://kb.databasedesignbook.com/posts/erd-diagrams-3b/", "published_at": "2025-11-11T17:00:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf5e4493b", "title": "ERD diagrams as specification tool (pt. III)", "url": "https://kb.databasedesignbook.com/posts/erd-diagrams-3/", "published_at": "2025-10-27T21:00:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf5fb22ac", "title": "ERD diagrams, pt. II: physical diagrams", "url": "https://kb.databasedesignbook.com/posts/erd-diagrams-2/", "published_at": "2025-08-25T21:30:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf671ef30", "title": "ERD diagrams, pt. I: many-to-many relationships", "url": "https://kb.databasedesignbook.com/posts/erd-diagrams/", "published_at": "2025-07-25T21:30:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf6c0ff13", "title": "Systematic design of multi-join GROUP BY queries", "url": "https://kb.databasedesignbook.com/posts/systematic-design-of-join-queries/", "published_at": "2025-05-22T21:30:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf76fd1b8", "title": "Foreign Keys", "url": "https://kb.databasedesignbook.com/posts/foreign-keys/", "published_at": "2025-01-12T14:07:20+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf86f7f2d", "title": "Historized attributes: systematic table design", "url": "https://kb.databasedesignbook.com/posts/historized-attributes-design/", "published_at": "2024-11-09T13:00:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf8f6b0f7", "title": "Many yes/no attributes: table design study", "url": "https://kb.databasedesignbook.com/posts/restaurant-attributes-design/", "published_at": "2024-06-19T23:13:00+00:00" }, { "id": "01a08794-4165-734d-8871-3d4bf8f79e3c", "title": "Database Design for Google Calendar: a tutorial", "url": "https://kb.databasedesignbook.com/posts/google-calendar/", "published_at": "2024-05-20T21:30:00+00:00" } ] posts Claim your blog

Back to kb.databasedesignbook.com

Blog · corpus.blog/blogs/kb.databasedesignbook.com/posts

kb.databasedesignbook.com

kb.databasedesignbook.com

2026

Database Design Book original ↗

12 Sept 2026

Historized links, pt. 1 (M:N case)original ↗

17 Jul 2026

Historized links: introduction original ↗

12 Jul 2026

5NF and Database Design original ↗

11 Apr 2026

2025

A modern guide to SQL JOINs original ↗

25 Nov 2025

State park database: a Minimal Modeling approach (pt. III-b)original ↗

11 Nov 2025

ERD diagrams as specification tool (pt. III)original ↗

27 Oct 2025

ERD diagrams, pt. II: physical diagrams original ↗

25 Aug 2025

ERD diagrams, pt. I: many-to-many relationships original ↗

25 Jul 2025

Systematic design of multi-join GROUP BY queries original ↗

22 May 2025

Foreign Keys original ↗

12 Jan 2025

2024

Historized attributes: systematic table design original ↗

9 Nov 2024

Many yes/no attributes: table design study original ↗

19 Jun 2024

Database Design for Google Calendar: a tutorial original ↗

20 May 2024