Community MX learns you how to develop your own Myspace like social networking site:
The purpose of this, first of many articles is to deconstruct the application—in this case, MySpace.com—and show you how to build your own. I believe that the lessons that can be gleaned from learning how a successful site is constructed are plentiful and valuable. Namely, the ability for the users of your site to connect to each other. The first thing we will look at is what database structure would be required to implement the social networking aspect of MySpace.com. The examples will be in the context of SQL Server 2005, but the knowledge should be transferable to other RDBMSs.