官术网_书友最值得收藏!

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:

Creating an additional table

Using the same techniques used when creating the first table, we type this in:

Creating an additional table

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!

主站蜘蛛池模板: 陕西省| 陇西县| 汉沽区| 南康市| 阳信县| 四子王旗| 明星| 康定县| 博爱县| 额敏县| 夏津县| 育儿| 绿春县| 平安县| 梨树县| 丰都县| 邯郸市| 南漳县| 大宁县| 万源市| 获嘉县| 吉木萨尔县| 石门县| 西和县| 明星| 承德市| 葫芦岛市| 蒙城县| 新和县| 碌曲县| 大足县| 曲阜市| 滕州市| 四平市| 石楼县| 民乐县| 香格里拉县| 墨竹工卡县| 旬阳县| 县级市| 宿松县|