--Appliance table
CREATE TABLE APPLIANCE (
  --Columns
  APPLIANCEID CHAR(4) NOT NULL
  ,MODELID CHAR(4) NOT NULL
  ,APPLIANCENAME VARCHAR2(25)
  ,MANAFACTURERYEAR NUMBER(4)
  ,PRICE NUMBER(6,2)

  --Primary Key
  ,CONSTRAINT APPLIANCE_PK
    PRIMARY KEY (APPLIANCEID, MODELID)
);
--Delivery table
CREATE TABLE DELIVERY (
  --Columns
  DELIVERYID CHAR(5) NOT NULL
  ,DELIVERYDATE DATE
  ,QUANTITY NUMBER(2)
  ,PRICEPERUNIT NUMBER(6,2)

  --Primary Key
  ,CONSTRAINT DELIVERY_PK
    PRIMARY KEY (DELIVERYID)

    --Foreign keys
  ,WHOLESALERID CHAR(4) NOT NULL
  ,APPLIANCEID CHAR(4) NOT NULL
  ,MODELID CHAR(4) NOT NULL
  ,SHOPID CHAR(4) NOT NULL

  ,CONSTRAINT SHOP_FK
    FOREIGN KEY (SHOPID)
    REFERENCES SHOP(SHOPID)

  ,CONSTRAINT APPLIANCE_FK
    FOREIGN KEY (APPLIANCEID,MODELID)
    REFERENCES APPLIANCE(APPLIANCEID,MODELID)

  ,CONSTRAINT WHOLESALER_FK
    FOREIGN KEY (WHOLESALERID)
    REFERENCES WHOLESALER(WHOLESALERID)
);

--Insert statement
INSERT INTO DELIVERY VALUES ('D0015','07/AUG/15','40','200','W002','MI01','M099','S002');