Database Reference
In-Depth Information
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
Mode
section in Chapter 6 for more details).
Search WWH ::
Custom Search