Important: To do this activity you need to fork this repo into your Github account and then open the forked repo on Gitpod.
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:
🔥 You can use this FREE tool to practice your diagram for the first time: https://app.quickdatabasediagrams.com/#/d/
-
Get inside the environment
$ pipenv shell -
Install all dependencies
$ pipenv install -
Generate de diagram as many times as you need
$ python src/models.py -
Open the file
diagram.pngto check out your UML diagram!
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.pyon the console.