create table SUPPLIER (
SUPPLIER varchar( 10 ) not null
);

alter table SUPPLIER
add constraint PK_SUPPLIER
primary key ( SUPPLIER );

create table PRODUCT (
SUPPLIER varchar( 10 ) not null,
PRODUCT varchar( 10 ) not null
);

alter table PRODUCT
add constraint PK_PRODUCT
primary key ( SUPPLIER, PRODUCT );

alter table PRODUCT
add constraint FK_PRODUCT_SUPPLIER
foreign key ( SUPPLIER )
references SUPPLIER ( SUPPLIER ) on update cascade;

create table DELIVERY (
SUPPLIER varchar( 10 ) not null,
DELIVERY_NO integer not null
);

alter table DELIVERY
add constraint PK_DELIVERY
primary key ( SUPPLIER, DELIVERY_NO );

alter table DELIVERY
add constraint FK_DELIVERY_SUPPLIER
foreign key ( SUPPLIER )
references SUPPLIER ( SUPPLIER ) on update cascade;

create table COST (
SUPPLIER varchar( 10 ) not null,
PRODUCT varchar( 10 ) not null,
DELIVERY_NO integer not null,
PRICE float
);

alter table COST
add constraint PK_COST
primary key ( DELIVERY_NO, PRODUCT, SUPPLIER );

alter table COST
add constraint FK_COST_DELIVERY
foreign key ( SUPPLIER, DELIVERY_NO )
references DELIVERY ( SUPPLIER, DELIVERY_NO ) on update cascade;

alter table COST
add constraint FK_COST_PRODUCT
foreign key ( SUPPLIER, PRODUCT )
references PRODUCT ( SUPPLIER, PRODUCT ) on update cascade;


insert into SUPPLIER (
SUPPLIER )
values ( 'ITNEL' );

insert into PRODUCT (
SUPPLIER,
PRODUCT )
values ( 'ITNEL', 'PENTIUM-1' );

insert into PRODUCT (
SUPPLIER,
PRODUCT )
values ( 'ITNEL', 'CORE I7' );

insert into DELIVERY (
SUPPLIER,
DELIVERY_NO )
values ( 'ITNEL', 1 );

insert into COST (
SUPPLIER,
PRODUCT,
DELIVERY_NO,
PRICE )
values ( 'ITNEL', 'PENTIUM-1', 1, 100 );

insert into COST (
SUPPLIER,
PRODUCT,
DELIVERY_NO,
PRICE )
values ( 'ITNEL', 'CORE I7', 1, 280 );

commit;

update SUPPLIER
set SUPPLIER = 'INTEL'
where SUPPLIER = 'ITNEL';

/*
violation of FOREIGN KEY constraint "".
violation of FOREIGN KEY constraint "FK_COST_DELIVERY" on table "COST".
Foreign key reference target does not exist.
Problematic key value is ("SUPPLIER" = 'INTEL', "DELIVERY_NO" = 1).
At trigger 'CHECK_4'
At trigger 'CHECK_1'.
*/

alter table COST
add drop FK_COST_DELIVERY;


update SUPPLIER
set SUPPLIER = 'INTEL'
where SUPPLIER = 'ITNEL';

alter table COST
add constraint FK_COST_DELIVERY
foreign key ( SUPPLIER, DELIVERY_NO )
references DELIVERY ( SUPPLIER, DELIVERY_NO ) on update cascade;