Important: To do this activity you need to fork this repo into your Github account and then open the forked repo on Codespaces (recommended) or Gitpod.
Inside the src/models.py file, you will find a couple of classes describing an example database.
Here is a 10 min video explaining what UML is: https://www.youtube.com/watch?v=UI6lqHOVHic
The diagram.png file generates a database chart based on the classes that you will be creating. Such charts in Database Management are referred to as ERDs (Entity Relatonship Diagrams).
Please watch these two short videos explaining ERDs:
You will have to create the Entity Relationship Diagram for Instagram's 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 the diagram as many times as you need
$ python src/models.py -
Open the file
diagram.pngto check out your ERD diagram!
Your job is to update the src/models.py file with the code needed to replicate Instagram's 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 their properties.
- Refresh the
diagram.pngfile at the end by running$ python src/models.pyon the console.
This and many other projects are built by students as part of the 4Geeks Academy Coding Bootcamp by Alejandro Sanchez and many other contributors. Find out more about our Full Stack Developer Course, and Data Science Bootcamp.