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

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!

主站蜘蛛池模板: 秭归县| 罗甸县| 蕲春县| 绵阳市| 容城县| 会东县| 柳河县| 泰州市| 华蓥市| 陵川县| 嘉祥县| 和顺县| 辉县市| 棋牌| 会宁县| 克什克腾旗| 将乐县| 察雅县| 泸西县| 云龙县| 辽源市| 黄山市| 登封市| 普陀区| 科技| 富裕县| 朝阳区| 南安市| 武义县| 六盘水市| 唐海县| 商河县| 吉木萨尔县| 潼南县| 威信县| 沙河市| 鹤峰县| 榆社县| 甘德县| 侯马市| 阿尔山市|