Recent Posts

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

read more

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

read more

Systematic design of multi-join GROUP BY queries

read more

More

Foreign Keys

Historized attributes: systematic table design

Many yes/no attributes: table design study

Database Design for Google Calendar: a tutorial

All Posts