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

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!

主站蜘蛛池模板: 石景山区| 故城县| 威宁| 宜昌市| 阳新县| 韶关市| 屏南县| 休宁县| 泸西县| 咸丰县| 大连市| 库尔勒市| 贡嘎县| 渝中区| 依兰县| 喜德县| 松原市| 德格县| 准格尔旗| 隆德县| 丹东市| 莱芜市| 得荣县| 灌云县| 德江县| 佛坪县| 化隆| 天长市| 宿州市| 梁山县| 金堂县| 兴义市| 台东县| 波密县| 石阡县| 嘉禾县| 竹山县| 东海县| 宁南县| 深圳市| 信丰县|