Home arrow MySQL arrow 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.

TABLE OF CONTENTS:
  1. An Introduction to Database Normalization (part 2)
  2. The Project
  3. Querying the MySQL database
  4. Conclusion
By: W.J. Gilmore
Rating: starstarstarstarstar / 9
December 05, 2000

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement
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.



 
 
>>> More MySQL Articles          >>> More By W.J. Gilmore
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: