Creating an additional table
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 go back to the Database view for marc_book and request the creation of another table with three columns as indicated in the following screenshot:
Using the same techniques used when creating the first table, we type this in:
As we have three columns or less, the display is now in vertical mode (refer to the Vertical mode section in Chapter 5 for more details).
The column name id, which is our primary key in this new table, relates to the author_id column from the book table. After saving the table structure, we enter some data for authors 1 and 2. Use your imagination for this!
