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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
