Firstly, in Relation view for the country
table, we specify the field that we want to display:
Then, we add a country_code column to the author table, and in the Relation view,
we link it to the newly created country table. We must remember to click Go for the
relation to be recorded. For this example, it is not necessary to enter any country data
for an author, as we are interested only in the relational schema.
Editing PDF Pages
Each relational schema is called a page. We can create or edit a page by clicking Edit
PDF pages in the Operations sub-page of the Database view.
Chapter 15
[ 233 ]
Page Planning
In phpMyAdmin version 2.11.0, a relational schema cannot span multiple databases.
But even working with just one database, the number of tables might be large.
Representing the various relations between them in a clear way could be a challenge.
This is why we may use many pages, each showing some tables and their relations.
We must also take into account the dimensions of the final output. Printing on
letter-size paper gives us less space to show all our tables and still have a
legible schema.
Creating a New Page
Because there are no existing pages, we need to create one. As our most important
table is book, we will also name this page book.
We will choose which tables we wish to see in the relational schema.
Pages:
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215