 alter table diagnosis add constraint foreign key (patNo) references patients(No) on update cascade on delete cascade;
 
 alter table products add constraint foreign key (supplier) references   supliers(suplier_id) on update cascade on delete cascade;
 
 alter table  treatment add constraint foreign key (pNo) references   patients(No) on update cascade on delete cascade;
 alter table  procedurers add constraint foreign key (paNo) references   patients(pid) on update cascade on delete cascade;