An Introduction to Database Normalization - What's Next (
Page 5 of 5 )
Taking time to properly
design your database is arguably the most important step in developing
database-oriented applications. This article focused upon informing you of the
basic premises of efficient db design, introducing database normalization,
general definitions, and the first three Normal Forms.
Next article, I’ll
focus upon applying these principles to a MySQL database, introducing you to the
syntax necessary to make database normalization possible. I’ll also illustrate
how SQL queries can then be used to mine the normalized tables for useful
information. If you can’t wait to learn more about how queries are used to
retrieve data from normalized tables, I would suggest checking out the Devshed
article
MySQL
Table Joins.