PHP and MySQL Tutorials - Modeling and Designing Relational Databases
Planning and designing a database is the essential first step to developing a web database application. In this tutorial, we introduce database modeling and the techniques to convert a model into the SQL statements needed to create a database.
This tutorial isn't intended to replace a tutorial on relational databases. Modeling requirements with an entity-relationship model requires both patience and experience. Instead, we detail our thought processes in a case study that models the winestore requirements and converts these to SQL
TABLE statements. Pointers to resources on modeling and database design are included.
Table of content (tutorial index)