There are many social networking websites like facebook, orkut, twitter. These websites handling many users at a time. All the queries are processed faster. Which database do they use for building it?
Also they handles for login,user creation,scarps, photos etc. all these must be stored in a database.
How they create relatioships with each table? Will they only link each and every table with ID.