Chapter 23, Problem 5RE

Explanation of Solution

Create a Book table using SQL commands:

Query 1:

The SQL command to create a table named “Book” with given columns is as follows:

/* Create a table named Book */

CREATE TABLE Book

(

ISBN INTEGER,

author VARCHAR(50),

title VARCHAR(40)

);

Explanation:

In the above query,

• A table “Book” has been created using “CREATE TABLE” statement.
• The “Book” table contains three columns:
  • The “ISBN” column is a unique ID for searching a book; the datatype of this column is “INTEGER”.
  • The “Author” column is used to search and save a book by author name; the datatype of this column is “VARCHAR” and the size is “50”.
  • The “Title” column is used to search and save a book by title name; the datatype of this column is “VARCHAR” and the size is “40”...