Create a table named book by defining the field book ld book name pric

1.	Create a table named book by defining the field book ld book name price publisher category and number of pages enter 25 records in it and perform all the operations
Answer» ANSWER: In this problem, The query can be written in different platforms. MYSQL: CREATE TABLE BOOK( book_id INT NOT NULL, name varchar(255), price int, PUBLISHER varchar(255), catagory varchar(255), Num_of_pages int ); SQL Server / Oracle / MS Access: CREATE TABLE book( book_id int NOT NULL PRIMARY KEY, name varchar(255), price int, publisher varchar(255), catagory varchar(255), Num_of_pages int );

Create a table named book by defining the field book ld book name price publisher category and number of pages enter 25 records in it and perform all the operations

Answer»

ANSWER: In this problem,

The query can be written in different platforms.

CREATE TABLE BOOK(

book_id INT NOT NULL,

name varchar(255),

price int,

PUBLISHER varchar(255),

catagory varchar(255),

Num_of_pages int

);

SQL Server / Oracle / MS Access:

CREATE TABLE book(

book_id int NOT NULL PRIMARY KEY,

name varchar(255),

price int,

publisher varchar(255),

catagory varchar(255),

Num_of_pages int

);