Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, tutorials, and more.

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 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 type this in:

As we have three fields or less, the display is now in vertical mode (see the Vertical ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.