HomeMySQL An Introduction to Database Normalization (part 2)
An Introduction to Database Normalization (part 2)
Last week we introduced you to the basics of creating an efficientdatabase 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.