8/20/2019 Projek Uas Oracle

1/1

create table ACCU( type varchar2(10)constraint accu_type_pk PRIMARY KEY, amper varchar2(5),jenis_penggunaan varchar2(5),keterangan varchar2(30));

create table penjualan( notransaksi varchar2(8)constraint penj_not_pk PRIMARY KEY,harga number(10),nomerk varchar2(8),constraint penj_nomerk_fk FOREIGN KEY (nomerk) references MERK(nomerk));

create table MERK( nomerk varchar2(8)constraint merk_nomerk_pk PRIMARY KEY,merk varchar2(10),stock number(10),type varchar2(10),constraint merk_type_fk FOREIGN KEY (type) references ACCU(type));

create table KONSUMEN(nokonsumen varchar2(8),nama varchar2 (10),alamat varchar2(20),notelp number(14),notransaksi varchar(8),constraint kons_not_fk FOREIGN KEY (notransaksi) references penjualan(notransaksi));