#database #development #mysql #reading-list

🔗 Database Design for Google Calendar: a tutorial

In this database design tutorial (~9000 words) I'm going to show how to design the database tables for a real-world project of substantial complexity.

We'll design a clone of Google Calendar. We will model as much as possible of the functionality that is directly related to the calendar.

This series illustrates an approach explained in the book called " Design using Minimal Modeling", scheduled to be released in Summer 2024. Here is the website of the book: https://databasedesignbook.com/. You can leave your email address to receive occasional updates on the book and related materials.

We will first build a complete logical model that describes the calendar data to be stored. This should take most of the effort (~80% of text by word count). After the logical model is finished, we'll build table design directly based on the logical model.

continue reading on kb.databasedesignbook.com

⚠️ This post links to an external website. ⚠️