This was done as a course project. We were group of 4 people. This is Relation Database Management System which is built using postgreSQL.
This project contains following files:
- create_DDL.sql :A DDL script to generate relational tables for our mini-twitter schema including relevant constraints.\
- ER_Diagram.png :An Entity Relational diagram of the schema to give conceptual idea of the project.\
- insert_statements.sql :DML commands to insert data into the relational tables.\
- Normal_Forms.pdf :Normalization Proofs of the given relations.\
- queries.sql :List of several SQL queries of the project.\
- Relational_Schema.png :Relatioal Schema to better visualize relations among the tables.\
- stored_procedures_and_triggers.sql :Several Stored Procedures and Triggers to perform some complex queries.\
By using this project a user can following actions:
- A user can tweet a Tweet and manage Like and Retweet counts.
- A user can block/unblock another user.
- A user can fetch tweets in chronological order using timestamp associated with each tweet
- A user can fetch famous tweets based on geographical locations.
- A user can search famous trends based on Hashtags included in tweets.
Roshan Shah
Bhavesh Khatnani
Rishikesh Bhatt
Devansh Purohit