Building Instagram.com Database Model

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:

• https://www.youtube.com/watch?v=QpdhBUYk7Kk
• https://www.youtube.com/watch?v=-CuY5ADwn24

You will have to create the Entity Relationship Diagram for Instagram's Database - a very similar diagram to this one:

Click to open diagram

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

💻 Installation

1. Get inside the environment $ pipenv shell

2. Install all dependencies $ pipenv install

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

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

📝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.png file at the end by running $ python src/models.py on 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.