An Introduction to Database Normalization (part 2)
By W.J. Gilmore
December 05, 2000
Introduction
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.
Printer friendly version