CREATE TABLE PRODUCT
PCODE VARCHAR2(8) PRIMARY KEY,
PROD_NAME VARCHAR2(20) NOT NULL,
PROD_CAT VARCHAR2(10) NOT NULL,
PRICE NUMBER(9,3));
CREATE TABLE DISCOUNT
PROD_CAT VARCHAR2(10) PRIMARY KEY,
DISCOUNT_RATE NUMBER(6) NOT NULL
);
CREATE TABLE SALES
SLNO NUMBER(4) PRIMARY KEY,
PCODE VARCHAR2(8) NOT NULL,
PROD_NAME VARCHAR2(20)...