An Introduction to Database Normalization (part 2) (
Page 1 of 4 )
Last week we introduced you to the basics of creating an efficient
database table structure. After today's concluding article of this series
you'll be able to create some of your own MySQL-powered applications, or
use this syntax as the basis for learning to create normalized databases on
your database server of choice.As your Web application grows in size and complexity, the importance of
employing sound design techniques begins to weigh particularly heavily into the
project’s success and longetivity. Since many of these large-scale productions
incorporate database usage, taking time to adequately plan for the scaleability
and manageability of the data to be stored within the database should be a
high-priority item on your initial design checklist.
Last week’s article,
An
Introduction to Database Normalization, introduced you to the basic
vocabulary and underlying principles of creating efficient database table
structures. This week, I’ll build upon what you have learned thus far, creating
a sample application using the popular
MySQL
database server. After finishing this tutorial, you’ll be able to use what you
have learned about MySQL syntax to begin building your own MySQL-powered
applications, or use this syntax as the basis for learning how to create
normalized databases on your database server of choice.
Before delving
into this introduction of MySQL syntax as it applies to normalized databases,
allow me to begin by introducing the sample application that will be created in
this tutorial.
/ 8 
