March 26th, 2009
Converting Data into Tables (Part 2 of 2)
Posted by
admin in
O. Database Objects
When designing SQL tables, you go through several logical steps:> Identify all of your tables.
> Decide what columns are to be in each table.
> Decide what column(s) will be used as the primary key so that every row is uniquely identified.
Primary key will be discussed in more detail.
> See that every table has at least one column in common with other columns in other tables in the database.
These common columns provide the logical links to the data in the other tables making this a relational database.
> Now normalize these tables to eliminate irregularities and anomalies.
Comments Off
