Databases Reference
In-Depth Information
For this example, it's not necessary to enter any country data for an author, as we are
interested only in the relational schema.
Producing schema pages
Each relational schema is called a page . We can create or edit a page by clicking on
Edit or export relational schema in the Operations page of the Database view.
Page planning
A relational schema cannot span multiple databases. But even working with just
one database, the number of tables might be large. Representing the various table
relations 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 of our tables and still have a
legible schema.
Creating a new page
As 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. We could
choose each table individually. However, for a good start, checking the appropriate
Automatic layout checkbox is recommended. Doing this puts all the related
tables from our database onto the list of tables to be included in the schema. It
then generates appropriate coordinates so that the tables will appear in a spiral
layout, starting from the center of the schema. These coordinates are expressed in
millimeters, with (0, 0) being located at the upper-left corner. We then click on Go :
 
Search WWH ::




Custom Search