Update H4 Tugas 3

1. Creat Table Pembelian

create table pembelian

(nonota varchar(10) primary key,

kdbrg varchar(10) foreign key references barang(kdbrg),

kdsup varchar(10) foreign key references supplier(kdsup),

tgl_beli date,

jml_beli integer,

hargabeli integer,

total integer

)

2. Memasukkan data pembelian

insert into pembelian

values ('HG001','001','Sup006','2017/01/03','200','2000','400000')

insert into pembelian

values ('HG002','004','Sup002','2017/01/02','150','3000','450000')

insert into pembelian

values ('HG003','007','Sup001','2017/01/02','300','4000','1200000')

insert into pembelian

values ('HG004','002','Sup003','2017/03/05','400','5000','500000')

insert into pembelian

values ('HG005','003','Sup004','2017/02/04','800','8000','1100000')

insert into pembelian

values ('HG006','005','Sup005','2017/05/08','600','7000','1500000')

insert into pembelian

values ('HG007','006','Sup007','2017/07/07','350','2000','400000')

insert into pembelian

values ('HG008','008','Sup009','2017/06/01','550','3000','800000')

insert into pembelian

values ('HG009','009','Sup008','2017/09/09','600','9000','900000')

insert into pembelian

values ('HG010','010','Sup010','2017/08/10','700','6000','300000')

3. Menampilkan Data

select * from pembelian