Instagram Database Model

PostgreSQL database modeling primary functionality of Instagram

This project was completed for a CMU Database Design and Development term project.

To reach its final state, the project went through several phases adhering to the Database Development Lifecycle.

In depth research and analysis of Instagram's business model and features.
Creation of Users and User Stories to model primary features of Instagram.
Conceptual Model
Relational Model
Analysis of Functional Dependencies
Normalization of schema to Boyce-Codd Normal Form (BCNF).
Physical Model in Vertabelo
Population of data
Develop Queries using Python and PostgreSQL to implement Instagram features (e.g posts,follows,likes,comments,etc).

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
Advertisement.csv		Advertisement.csv
Business.csv		Business.csv
Comment.csv		Comment.csv
Content_Creator.csv		Content_Creator.csv
Followers.csv		Followers.csv
Like.csv		Like.csv
Messages.csv		Messages.csv
Partners_With.csv		Partners_With.csv
Personal.csv		Personal.csv
Posts.csv		Posts.csv
Product.csv		Product.csv
Promotion.csv		Promotion.csv
README.md		README.md
User.csv		User.csv
complex_query_1.py		complex_query_1.py
complex_query_2.py		complex_query_2.py
complex_query_3.py		complex_query_3.py
complex_query_4.py		complex_query_4.py
create.sql		create.sql
initialize.sql		initialize.sql
show_all.sql		show_all.sql
simple_query_1.py		simple_query_1.py
simple_query_2.py		simple_query_2.py
simple_query_3.py		simple_query_3.py
simple_query_4.py		simple_query_4.py
simple_query_5.py		simple_query_5.py
simple_query_6.py		simple_query_6.py

Provide feedback