Question: 2 . The create table statement and the two instants of the book table are shown below. Write the smallest and minimum SQL commands (
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. pts
CREATE TABLE book
bookid int NOT NULL,
bookname varchar NOT NULL,
numpage integer NULL,
pubishdate date NULL,
price double precision NULL,
publisher varchar NULL,
CONSTRAINT bookpk PRIMARY KEY bookid
;
Snapshot I:
Snapshot II:
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
