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)

Civil Registrar System ER Diagram

Civil Registrar System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Civil Registrar System Entity. The entity-relationship diagram of Civil Registrar System shows all the visual instrument of database tables and the relations between Birth, Blocks, Civil, Civilization etc. It used structure data and to...
Provident Fund System ER Diagram

Provident Fund System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Provident Fund System Entity. The entity-relationship diagram of Provident Fund System shows all the visual instrument of database tables and the relations between Employees, Registration, Provident Fund, Users etc. It used structure...
Farm Management System ER Diagram

Farm Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Farm Management System Entity. The entity-relationship diagram of Farm Management System shows all the visual instrument of database tables and the relations between Plants, Medicines, Farm, Login etc. It used structure data and to...
Stock Management System ER Diagram

Stock Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Stock Management System Entity. The entity-relationship diagram of Stock Management System shows all the visual instrument of database tables and the relations between Product, Bill, Stock, Store etc. It used structure data and to define...
Auto Spare Parts Management System ER Diagram

Auto Spare Parts Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Auto Spare Parts Management System Entity. The entity-relationship diagram of Auto Spare Parts Management System shows all the visual instrument of database tables and the relations between Sales, Billing, Purchase, Order etc. It used...
Multiple Choice Quiz System ER Diagram

Multiple Choice Quiz System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Multiple Choice Quiz System Entity. The entity-relationship diagram of Multiple Choice Quiz System shows all the visual instrument of database tables and the relations between Examinations, Courses, Students, Results etc. It used...
Canteen Billing System ER Diagram

Canteen Billing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Canteen Billing System Entity. The entity-relationship diagram of Canteen Billing System shows all the visual instrument of database tables and the relations between Products, Items, Canteen, Payment etc. It used structure data and to...
Online Music Portal System ER Diagram

Online Music Portal System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Online Music Portal System Entity. The entity-relationship diagram of Online Music Portal System shows all the visual instrument of database tables and the relations between Track, Singer, Performaer, Album etc. It used structure data...
Order Processing System ER Diagram

Order Processing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Order Processing System Entity. The entity-relationship diagram of Order Processing System shows all the visual instrument of database tables and the relations between Customer, Bill, Product, Payment etc. It used structure data and to...
Photo Gallery ER Diagram

Photo Gallery ER Diagram

This ER (Entity Relationship) Diagram represents the model of Photo Gallery Entity. The entity-relationship diagram of Photo Gallery shows all the visual instrument of database tables and the relations between Images, Category, Media, Uploads etc. It used structure data and to define the...
Call FreeProjectz WhatsApp FreeProjectz