Tugas 4 hari 4

Tugas Membuat Tabel Pembelian

1. Membuat tabel 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),
 tanggalbeli date,
 jumlahbeli int,
 hargabeli int,
 total int)

2. Memasukkan isi tabel pembelian

insert into pembelian
 values ('HG001','001','Sup006','03/01/2017','200','2000','400000')
 insert into pembelian
 values ('HG002','004','Sup002','02/01/2017','150','3000','450000')
 insert into pembelian
 values ('HG003','007','Sup001','02/01/2017','300','2000','1200000')
 insert into pembelian
 values ('HG004','002','Sup003','02/02/2017','150','2000','500000')
 insert into pembelian
 values ('HG005','003','Sup004','02/02/2017','300','2500','1100000')
 insert into pembelian
 values ('HG006','005','Sup005','03/02/2017','110','1000','200000')
 insert into pembelian
 values ('HG007','006','Sup007','04/01/2017','200','2000','1200000')
 insert into pembelian
 values ('HG008','008','Sup008','02/04/2017','100','2000','1500000')
 insert into pembelian
 values ('HG009','009','Sup009','04/03/2017','250','3000','1600000')
 insert into pembelian
 values ('HG010','010','Sup010','03/04/2017','300','2000','1200000')

3. Menampilkan isi tabel pembelian

select * from pembelian