hi i'm having a hard time coming up with a database design/architecture for the friendster site. i'm particulary interested on how they design the "network of friends and friends and friends etc.," that is, how to design a graph data structure inside a databse since friendster's architecture resembles more of a graph rather than a tree/hierarchical. i couldn't find any tutorial on the net so i went this way instead. please also give attention to the favorite music, favorite tv shows, favorite movies etc., the reason for comma seperated and how they come up in storing those and allow users to click on it and shows a list of matching criteria i just need the sql statements to construct the database and an explanation why it was designed that way. then last, when you log in to friendster at your home page, id like to know the queries to get the total people in your networks, + when you view a particular person, it shows how you are connected to that person. for instance, your are connected to john via: me -> mark -> sarah -> jessie -> tom -> john i need the most optimize database design. thanks.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).