locked
Social networking site database RRS feed

  • Question

  • hello,

    im willing to make a social networking website using asp.net 4.0

     

    i want to ask if u guys can help me in database structure of it ?????

    Monday, July 18, 2011 4:52 PM

Answers

  • Have you looked at examples over a internet?

    http://bhu1st.blogspot.com/2010/05/social-network-database-design-sample.html

    http://dbdesign-sn.blogspot.com/


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, July 19, 2011 5:02 AM
  • There are many social network web applications where you can get for free or paying some

    You can download some and check database designs of those applications.

     

    You can also extract the functionality of a web application like facebook, twitter or linkedin page by page.

    Then you will see what data you should display. This will be a base of your views and stored procedures that will be used on that page.

    Also by analyzing the above data, you can end up with your entities, database tables and relation between these tables or entities.


    SQL Server for T-SQL Developers
    Our true mentor in life is science
    Thursday, July 21, 2011 8:27 AM

All replies

  • Sure, we'd love to help.

     

    Please explain what the goal is, and where your current design is not meeting them.

    Monday, July 18, 2011 6:24 PM
    Answerer
  • it going to be a tree structure. meaning a is friend of b and b is friend of c and so on

    the first thing that you need to know is "self-join"

    http://msdn.microsoft.com/en-us/library/ms177490.aspx

     

    http://en.wikipedia.org/wiki/Join_(SQL)


    http://joeydj.com
    Tuesday, July 19, 2011 1:38 AM
  • i've just started have no idea how social networking database is like :P

    besides i wanna make just like facebook

    im searching for to collect material from where ever i can and i have gathered a lot of material but it's not related to database of it... now i m in search of database material and here was my first stop.....

     

    i know i have to make a tree structure and few other things but still if u can explain more precisely... would be thankful to you.... 


    junaid shaikh
    Tuesday, July 19, 2011 3:03 AM
  • i know self joining.........

     

    but i don't know the structure... yes i know that i have to make a tree structure but what tables and fields i've no idea right now.... but in just one week im telling ya my database would be ready :P

     

    coz i know me im JUNAID JABBAR SHAIKH :D


    junaid shaikh
    Tuesday, July 19, 2011 3:04 AM
  • Have you looked at examples over a internet?

    http://bhu1st.blogspot.com/2010/05/social-network-database-design-sample.html

    http://dbdesign-sn.blogspot.com/


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, July 19, 2011 5:02 AM
  • If you do not have a design yet, but you know what you want, and just need some help to get started, please post exactly what you want. "like facebook", isn't really a good description. :) Especially, as not all of us know what it is (in detail).

    The first part of any good project is a good description. Perhaps we can start there.

    Tuesday, July 19, 2011 11:00 AM
    Answerer
  • There are many social network web applications where you can get for free or paying some

    You can download some and check database designs of those applications.

     

    You can also extract the functionality of a web application like facebook, twitter or linkedin page by page.

    Then you will see what data you should display. This will be a base of your views and stored procedures that will be used on that page.

    Also by analyzing the above data, you can end up with your entities, database tables and relation between these tables or entities.


    SQL Server for T-SQL Developers
    Our true mentor in life is science
    Thursday, July 21, 2011 8:27 AM
  • >Our true mentor in life is science

    Umm, not really. at least not for most of the world.

    Perhaps you meant "Our true mentor in science is life"

    Thursday, July 21, 2011 11:20 AM
    Answerer
  • U can find really helpful material in that regard over the following link.......

    http://bhu1st.blogspot.com/2010/05/social-network-database-design-sample.html



    • Proposed as answer by Farhan Hoti Saturday, December 17, 2011 2:29 PM
    • Edited by Farhan Hoti Saturday, December 17, 2011 2:30 PM
    • Unproposed as answer by Brian TkatchEditor Monday, December 19, 2011 2:34 PM
    Saturday, December 17, 2011 2:29 PM