[System design] Data modelling exercise

We look at several system design challenge. For each of them, we only do the database modelling part: what tables are needed, what indexes does each table need, and how are the tables partitioned to support the most used queries.

System design challenges: we use the exercises from hellointerview:

• [design bit.ly](https://www.hellointerview.com/learn/system-design/problem-breakdowns/bitly)
• design dropbox
• desing an online store
• design tinder
• design whatsapp

We will use only relational databases (SQL)

What We’ll Do:
We read the requirements for each application, and we propose a solution for:

• the database model – what tables should there be
• the needed indexes – what indexes should each table have
• how to partition data – in order to best support the most common queries

Bring your creativity and architectural thinking!