Modeling and Designing Relational Databases

PHP & MySQL - Modeling and Designing Relational Databases

Modeling and Designing Relational Databases The Relational Model Case Study: Relations in the Winestore Entity-Relationship Modeling Case Study: Modeling the Online Winestore System requirements analysis Identifying entities in ER modeling Identifying relationships in ER modeling Relationships in the winestore ER model Identifying key attributes in ER modeling Other ER modeling tools Completing the ER model Converting an Entity-Relationship Model to SQL Step 1: Convert regular entities to tables Step 2: Convert weak entities to tables Step 3: One-to-one relationships Step 4: Regular one-to-many relationships Step 5: Many-to-many relationships Managing Sessions in the Database Tier Using a Database to Keep State PHP Session Management PHP Session Management Storage Methods Building User-Defined Session Handlers MySQL Session Store Session Table Structure Handler Implementations Support functions sessionOpen sessionRead sessionWrite sessionClose sessionDestroy Garbage collection Registering session handlers Using the User-Defined Session Handler Code Resources Client Tier Resources Middle Tier Resources Web Server and Web Technology Resources Networking and Web Resources More About PHP Web resources Libraries Third-party products Open source PHP applications

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.

[Next]