Database Relationship is a vast subject in database system, which I will discus latter, but for now, I want to give you a brief knowledge about the database relationship.

Here, we will create two tables to store each user’s registration information. One is “login” table, which we already created in the early season, and the other is “user_information” table to store the detailed information of the users. To find out a particular user’s information you need a relationship column to relate with both the login and user_information tables. These columns must be unique in this case and both the columns in each table will hold the same unique data. In this case, userName will be the unique column for both of the tables to identify the particular information of a user.


continue...


marlopax


Sunday, January 24, 2010