/exercise-instagram-data-modeling

Doing the data modeling UML diagram

Primary LanguagePython

Create the database model for Instagram

Inside he src/models.py file you will find a couple of classes describing an example database.

Here is a 4min video explaining what UML is: https://www.youtube.com/watch?v=UI6lqHOVHic

We are going to be creating the Entity Relationship Diagram for Instagram Database, a very similar diagram to this one:

Instagram Diagram Click to open diagram

🔥 You can use this FREE tool to practice your diagram for the first time: https://app.quickdatabasediagrams.com/#/d/

💻 Instalation

  1. Get inside the environment $ pipenv shell

  2. Install all dependencies $ pipenv install

  3. Generate de diagram as many times as you need $ python src/models.py

  4. Open the file diagram.png to check out your UML diagram!

📝Instructions

Your Job is to update the src/models.py file with the code needed to replicate the instagram data model.

The project is using the SQLAlchemy Python library to generate the database.

  • What tables do you think instagram might have on its database: E.g: Post, User, etc.?
  • What properties should go inside the user? or inside the Post table?
  • Please add at least 4 models with all of its properties.
  • Degenerate the diagram.png file at the end by running $ python3 models.py on the console.