By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,854 Members | 876 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,854 IT Pros & Developers. It's quick & easy.

How to create a database for social networking?

P: 2
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~
Aug 16 '10 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 145
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.
Aug 16 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.