Social-Networking-Site-DataBase

Social Networking Database created on SQL server created for the university project

INTRODUCTION OF THE PROJECT

A social networking site is an online platform that allows users to create a public profile and interact with other users. Social networking sites usually allow a new user to provide a list of people with whom they share a connection, and then allow the people on the list to confirm or deny the connection. After connections are established, the new user can search the networks of connections to make more connections. A social networking site is also known as a social networking website or social website.

SCOPE OF THE PROJECT

The scope of social networking is widening, and today it offers a strong support to the companies in providing the much desired touch of concern. It enables users to post some informative materials, users can join different groups to stay tuned, users may also follow some groups for seeking information according to their concern, users can also like or post any material they liked. Basically the SNS turned this world into a global village in which everyone is connected and updated.

Use The Project

Don't forget to Give a star to the project
Clone/Fork the repository
Select and open the File "Query to Create DATABASE.sql" and Paste the script in your SQL SERVER
All Data Insertion Queries are also given so just copy and paste the scripts and enjoy

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
1st Query To Show.sql		1st Query To Show.sql
Code to insert Posts in Parent Table.sql		Code to insert Posts in Parent Table.sql
ERD.png		ERD.png
PrOJECT.pdf		PrOJECT.pdf
PrOJECT.pptx		PrOJECT.pptx
Query to Create DATABASE.sql		Query to Create DATABASE.sql
README.md		README.md
Total Functions Created.txt		Total Functions Created.txt
Users Table Data Insertion.txt		Users Table Data Insertion.txt
add followers trigger.sql		add followers trigger.sql
add friends insertion.sql		add friends insertion.sql
add friends trigger.sql		add friends trigger.sql
auto Like increase Trigger.sql		auto Like increase Trigger.sql
decrease groups posts trigger.sql		decrease groups posts trigger.sql
delete followers trigger.sql		delete followers trigger.sql
generate username Trigger.sql		generate username Trigger.sql
group followers insertion.sql		group followers insertion.sql
group insertion.sql		group insertion.sql
group member insertion.sql		group member insertion.sql
group post insertion.sql		group post insertion.sql
increase posts trigger.sql		increase posts trigger.sql
increase user posts trigger.sql		increase user posts trigger.sql
post_likes insertion.sql		post_likes insertion.sql
query to show 2.sql		query to show 2.sql
query to show 3.sql		query to show 3.sql
remove friends trigger.sql		remove friends trigger.sql
remove likes trigger.sql		remove likes trigger.sql
semove likes trigger.sql		semove likes trigger.sql
triggers.txt		triggers.txt
user followers insertion.sql		user followers insertion.sql
user messages insertion.sql		user messages insertion.sql
user_post data insertion.txt		user_post data insertion.txt

inshalayaz/Social-Networking-Site-DataBase

Folders and files

Latest commit

History

Repository files navigation

Social-Networking-Site-DataBase

INTRODUCTION OF THE PROJECT

SCOPE OF THE PROJECT

Use The Project

About

Topics

Resources

Stars

Watchers

Forks

Languages