Tuesday, August 16, 2011

How To Organize Your Database (MySQL)

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!