Question

Write SQL query to create a table “BOOKS” with the following structure:

Table: BOOKS

Field name	Datatype	Size	Constraint
BOOK_ID	Integer	2	Primary Key
BOOK_NAME	Varchar	20
CATEGORY	Varchar	10
ISSUE_DATE	Date

Answer 1

Create table Books 

( 

BOOK_ID Integer (2) Primary Key, 

BOOK_NAME Varchar (20), 

CATEGORY Varchar (20), 

ISSUE_DATE Date 

);