Now that we have a new database, it's time to create a table in it. The example table we will use is a table named book.
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:
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.
We have chosen ...