Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table barang(
- KODE_BARANG char(6),
- NAMA_BARANG varchar2(25),
- SATUAN_BARANG varchar2(20),
- STOK_BARANG number(4),
- constraint pk_barang primary key(KODE_BARANG)
- );
- create table supplier(
- KODE_SUPPLIER char(5),
- NAMA_SUPPLIER varchar2(30),
- ALAMAT_SUPPLIER varchar2(30),
- KOTA_SUPPLIER varchar2(15),
- TELEPON_SUPPLIER varchar2(4),
- constraint pk_supplier primary key(KODE_SUPPLIER)
- );
- create table customer(
- KODE_CUSTOMER char(6),
- NAMA_CUSTOMER varchar2(30),
- ALAMAT_CUSTOMER varchar2(30),
- KOTA_CUSTOMER varchar2(15),
- TELEPON_CUSTOMER varchar2(4),
- constraint pk_customer primary key(KODE_CUSTOMER)
- );
- create table pasokk(
- KODE_PASOK char(10),
- KODE_BARANG char(6),
- KODE_SUPPLIER char(5),
- TANGGAL_PASOK date,
- JUMLAH_PASOK number(4),
- constraint pk_customerr primary key(KODE_PASOK,
- KODE_BARANG, KODE_SUPPLIER),
- constraint fk_pasokk_barang foreign key(KODE_BARANG)
- references barang (KODE_BARANG),
- constraint fk_pasokk_supplier foreign key(KODE_SUPPLIER)
- references supplier (KODE_SUPPLIER)
- );
- create table pembelian(
- KODE_PEMBELIAN char(10),
- KODE_BARANG char(6),
- KODE_CUSTOMER char(6),
- TANGGAL_PEMBELIAN date,
- JUMLAH_PEMBELIAN number(4),
- constraint pk_pembelian primary key(KODE_PEMBELIAN,
- KODE_BARANG, KODE_CUSTOMER),
- constraint fk_pembelian_barang foreign key(KODE_BARANG)
- references barang (KODE_BARANG),
- constraint fk_pembelian_customer foreign key(KODE_CUSTOMER)
- references customer(KODE_CUSTOMER)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement