Case Study's Final Structure

In this section we examine the final data structure for our case study. There are many ways to present this structure. First we'll see all the tables that are related to each other—almost all tables are—then we will examine group of related tables and their columns.

The following schema is produced by phpMyAdmin's PDF Page feature. To access this feature, we open a database and access the Operations sub-page. Then we click Edit PDF pages.

Case Study's Final Structure

When generating the PDF schema, we can also ask phpMyAdmin to produce a data dictionary. In order to do this, we click the Data Dictionary checkbox in the Display PDF schema dialog. Here ...

Get Creating your MySQL Database: Practical Design Tips and Techniques now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.