How to create a database for social networking?

[deepucando]

Hi

i am trying to design a social networking site for my project.

i have to design the database for the social networking with user profile and friends contact list as like facebook and orkut.

can anyone help me to implement the database design with fast and accuracy retrieval of data from the database using the Index and Hash table techniques

regards
~Deepu~

[Jerry Winston]

I'm guessing that, because you are reinventing a social networking site rather than taking advantage the API's of the already existing offerings, this is more an academic project than professional.
Your initial question was very, very broad so I'll give you an answer that covers the most content.
First, this project is about indexes and hash tables. Study these topics first, the art of properly indexing tables is very simple but profoundly subtle and a proper solution may not always jump out at you right away.
Second, after you have the skill set, plan,plan,plan! Properly diagramming a project before you code will save you many HOURS and PAGES of code. Start with a verbal diagram of what your program will do. From the written description you can create a visual representation of the objects that will create your data system. With graphical representations of your objects it is often easier to see their relationships or discover new relationships that may have been missed in the initial verbal review.
Third, Revise. Take any changes from step 2 and revise them in your written description of your database.

Although it seems like a lot to do before you even open the Workbench, proper planning will save you many, many nights and long days trying to repair defective code, broken relationships, and data integrity errors.