Question: 2 . The create table statement and the two instants of the book table are shown below. Write the smallest and minimum SQL commands (

2. The create table statement and the two instants of the book table are shown below. Write the smallest and minimum SQL commands (insert, update, delete) needed to get the second snapshot in the table. (10 pts)
CREATE TABLE book (
book_id int8 NOT NULL,
book_name varchar NOT NULL,
num_page integer NULL,
pubish_date date NULL,
price double precision NULL,
publisher varchar NULL,
CONSTRAINT book_pk PRIMARY KEY (book_id)
);
Snapshot I:
Snapshot II:
2 . The create table statement and the two

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!