In our (simple) design, we know that we need another table: the author table. The author table will contain:
Author identification
Full name
Phone number
To create this table, we must go back to the Database view in the left panel. We click on marc_book in the left panel, and request the creation of another table with three fields:
Using the same techniques used when creating the first table, we get:
Since we have three fields or less, the display is now in vertical mode (more details on this in Chapter 6, Vertical Mode section).
Here the field name id, which is our primary key in this new table, relates to the author_id
field from the book
table. After saving the table structure, we enter some data for authors 1 and 2. Use your imagination for this!