In our (simple) design, we know that we need another table—the author table. The author table will contain:

To create this table, we must go back to the Database view. We click on marc_book in the navigation panel, and request the creation of another table with three fields, as indicated in the following screenshot:

Using the same techniques used when creating the first table, we enter the data shown in the following screenshot:

As we have three fields or less, the display is now in vertical mode (see the Vertical mode section in Chapter 5, Changing Data and Structure for more details).

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!