Now that we have a new database, it's time to create a table in it. The example table we will use is the familiar book table.
Before creating a table, we should plan the information we want to store. This is usually done during database design. In our case, a simple analysis leads us to the following book-related data we want to keep:
International Standard Book Number (ISBN)
Title
Number of pages
Author identification
For now, it is not important to have the complete list of fields (or columns) for our book table; we will modify it by prototyping the application and refine it later. At the end of the chapter, we will add a second table, author, containing information about each author.