Visitors
Popular Posts
-
Please read my previous post before you watch this video. 1. Setting Your Own Website On CentOS 6 (PHP 5 & MySQL 5) 2. Instal...
-
In my previous post, I showed you how to build an website from scratch with PHP and MySQL. Now, I will start to build my forum using phpB... -
After your fresh install phpBB forum, usually users can not post their video link such as YouTube to the forum. It's because the permis...
-
1- Winetricks is a application which hel p to ins tall library or part for Wine. The process to inst all is quite simple :
My Blog List
How To Organize Your Database (MySQL)
Tuesday, August 16, 2011
MySQL is an RDBMS (Relational Database Management System), which means that the data is organized into tables. You can establish relationships between the tables in the database. Here are the steps for organizing your data into tables:
Step 1. Name your database
Step 2. Identify the objects
Step 3. Define and name a table for each object
Step 4. Identify the attributes for each object
Step 5. Define and name columns for each separate attribute that you identified in Step 4
Step 6. Identify the primary key
Step 7. Define the defaults
Step 8. Identify columns that require data
Have fun!
