Start interactive tutorial
Building Instagram.com Database Model
🌱 How to start this project
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.
In the src/models.py file of the forked repository, you will find several classes that represent the structure of a sample 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/
💻 Installation
-
Get inside the environment
$ pipenv shell -
Install all dependencies
$ pipenv install -
To generate a database diagram as many times as needed, run
$ pipenv run diagram -
Once the
diagram.pngfile is created in the root of the project, open it to see the UML representation of your database.
📝Instructions
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.