Group members: Zoey Ma, Anna Tao, Edmond Ye
Our Projects looks to model the Database of a social media application such as Instagram. In our project we primarily focused on the various operations that can be done using Instagram Users and Instagram Posts.
Database project with Backend in SQL and PHP. The web page design was done using HTML/CSS. We aimed to model a relational database system for a social media platform such as Instagram. We used an SQL initialization script to create all the tables and populate the data into the database.
User Insertion Query
Before Insertion:
After Insertion:
Post Insertion Query
Before And After Insertion:
Post deletion Query:
Update Post Location Query:
Selection in User Query:
Projection in User Query:
Aggregation with Group By Query:
Aggregation + Having Query:
Nested Aggregation Query:
Division Query:
