Databases Reference
In-Depth Information
2.
Create the
Inventory
table as follows:
CREATE TABLE "INVENTORY"
(
"ID" NVARCHAR2(255),
"BOOKID" NVARCHAR2(255),
"COPIESINSTOCK" NUMBER(9,3),
CONSTRAINT "INVENTORY_PK" PRIMARY KEY ("ID") ENABLE
)
/
INSERT INTO INVENTORY(ID,BOOKID,COPIESINSTOCK) VALUES('1','B1',10)
/
INSERT INTO INVENTORY(ID,BOOKID,COPIESINSTOCK) VALUES('2','B2',15)
/
INSERT INTO INVENTORY(ID,BOOKID,COPIESINSTOCK) VALUES('3','B3',1)
/
INSERT INTO INVENTORY(ID,BOOKID,COPIESINSTOCK) VALUES('4','B4',6)
/
INSERT INTO INVENTORY(ID,BOOKID,COPIESINSTOCK) VALUES('5','B5',17)
/
INSERT INTO INVENTORY(ID,BOOKID,COPIESINSTOCK) VALUES('6','B6',9)
/
INSERT INTO INVENTORY(ID,BOOKID,COPIESINSTOCK) VALUES('7','B7',14)
/
INSERT INTO INVENTORY(ID,BOOKID,COPIESINSTOCK) VALUES('8','B8',9)
/
3.
Create the
Category
table as follows:
CREATE TABLE "CATEGORY"
(
"CATEGORYID" NVARCHAR2(255),
"CATEGORYNAME" NVARCHAR2(255),
"DESCRIPTION" NVARCHAR2(255),
CONSTRAINT "CATEGORY_PK" PRIMARY KEY ("CATEGORYID") ENABLE
)
/
INSERT INTO CATEGORY(CATEGORYID, CATEGORYNAME, DESCRIPTION) VALUES('C1','FICTION','Fiction
selection')
/
INSERT INTO CATEGORY(CATEGORYID, CATEGORYNAME, DESCRIPTION)
VALUES('C2','SCIENCEFICTION','Science Fiction Selection')
/
