Hallo ketemu kembali
sekarang saya akan membagikan tugas sql yang ke empat dari tabel barang dan supplier kemarin sekarang kita relasikan dengan tabel pembelian , kita harus membuat tabel pebelian terlebih dahulu
TABEL RELASI
Use "201553049"
select*from supplier
select*from Barang
create table pembelian
(nonota
varchar(10) primary key,
kdbrg varchar(10) foreign key references barang,
kdsupplier varchar(10) foreign key references
supplier,
tanggalbeli date,
jumlahbeli int,
hargabeli int,
total int)
select*from pembelian
insert into pembelian
values ('HG001','001','Sup006','03/01/2017',200,2000,40000)
insert into pembelian
values ('HG002','004','Sup002','02/01/2017',150,3000,45000)
insert into pembelian
values ('HG003','005','Sup001','02/01/2017',300,4000,120000)
insert into pembelian
values ('HG004','002','Sup003','02/05/2017',500,5000,250000)
insert into pembelian
values ('HG005','003','Sup004','02/05/2017',200,1000,20000)
insert into pembelian
values ('HG006','004','Sup007','03/10/2017',100,1000,10000)
insert into pembelian
values ('HG007','005','Sup008','06/20/2017',600,2000,1200000)
insert into pembelian
values ('HG008','002','Sup009','03/20/2017',500,2000,1000000)
values ('HG009','004','Sup007','01/21/2017',150,2000,300000)
values ('HG010','001','Sup005','03/15/2017',150,4000,600000)
No comments:
Post a Comment