Social Networking Site ER Diagram

Subscribe our YouTube channel for latest project videos and tutorials Click Here

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Social Networking Site Entity. The entity-relationship diagram of Social Networking Site shows all the visual instrument of database tables and the relations between Friends, Shares, Users, Videos etc. It used structure data and to define the relationships between structured data groups of Social Networking Site functionalities. The main entities of the Social Networking Site are Users, Friends, Posts, Shares, Photos and Videos.

Social Networking Site entities and their attributes :

  • Users Entity : Attributes of Users are user_id, user_name, user_mobile, user_email, user_username, user_password, user_address
  • Friends Entity : Attributes of Friends are friend_id, friend_name, friend_mobile, friend_email, friend_friendname, friend_password, friend_address
  • Posts Entity : Attributes of Posts are post_id, post_user_id, post_title, post_type, post_description
  • Shares Entity : Attributes of Shares are share_id, share_post_id, share_name, share_type, share_description
  • Photos Entity : Attributes of Photos are photo_id, photo_name, photo_size, photo_type, photo_description
  • Videos Entity : Attributes of Videos are video_id, video_name, video_type, video_description

Description of Social Networking Site Database :

  • The details of Users is store into the Users tables respective with all tables
  • Each entity ( Videos, Posts, Photos, Friends, Users) contains primary key and unique keys.
  • The entity Posts, Photos has binded with Users, Friends entities with foreign key
  • There is one-to-one and one-to-many relationships available between Photos, Shares, Videos, Users
  • All the entities Users, Photos, Posts, Videos are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Social Networking Site tables for fast query execution.
Social Networking Site ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

Student Counselling Management System ER Diagram

Student Counselling Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Counselling Management System Entity. The entity-relationship diagram of Student Counselling Management System shows all the visual instrument of database tables and the relations between Counsellings, Results, Student, Merit...
University Admission Management System ER Diagram

University Admission Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of University Admission Management System Entity. The entity-relationship diagram of University Admission Management System shows all the visual instrument of database tables and the relations between Admission, Subject, University, Degree...
Library Inventory System ER Diagram

Library Inventory System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Inventory System Entity. The entity-relationship diagram of Library Inventory System shows all the visual instrument of database tables and the relations between Store, Author, Student, Address etc. It used structure data and to...
E-Governace System ER Diagram

E-Governace System ER Diagram

This ER (Entity Relationship) Diagram represents the model of E-Governace System Entity. The entity-relationship diagram of E-Governace System shows all the visual instrument of database tables and the relations between Petition, Customer, Bill, Government Services etc. It used structure data and...
Library Management System ER Diagram

Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Management System Entity. The entity-relationship diagram of Library Management System shows all the visual instrument of database tables and the relations between Books, Librarian, Student, Address etc. It used structure data...
University Certificate Management System ER Diagram

University Certificate Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of University Certificate Management System Entity. The entity-relationship diagram of University Certificate Management System shows all the visual instrument of database tables and the relations between University Certificate, Certificate...
Ticket Reservation System ER Diagram

Ticket Reservation System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Ticket Reservation System Entity. The entity-relationship diagram of Ticket Reservation System shows all the visual instrument of database tables and the relations between Seats Availability, Stations, Trains, Passengers etc. It used...
Automobiles Store and Service Management System ER Diagram

Automobiles Store and Service Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Automobiles Store and Service Management System Entity. The entity-relationship diagram of Automobiles Store and Service Management System shows all the visual instrument of database tables and the relations between Store, Services,...
Customer Track System ER Diagram

Customer Track System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Customer Track System Entity. The entity-relationship diagram of Customer Track System shows all the visual instrument of database tables and the relations between Documents, Login, Customer, Payments etc. It used structure data and to...
Car Sales System ER Diagram

Car Sales System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Sales System Entity. The entity-relationship diagram of Car Sales System shows all the visual instrument of database tables and the relations between Car Models, Inventory, Cars, Booking etc. It used structure data and to define the...
Call FreeProjectz WhatsApp FreeProjectz