Membuat Table Berelasi MySQL

Membuat Table Pembelian 
(berelasi dengan table Barang dan table Supplier)

create table pembelian
(nonota varchar(10) primary key,
kdbrg varchar (10),
kdsup varchar (10),
tglbeli date,
jumlahbeli int,
hargabeli int,
total int,
foreign key (kdbrg) references barang(kdbrg),
foreign key (kdsup) references supplier(kdsup))

Mengisi Data pada Table 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','4000','1200000')

insert into pembelian

values('HG004','005','sup007','03/01/2017','200','5000','1000000')

insert into pembelian

values('HG005','008','sup004','4/9/2017','100','2000','200000')

insert into pembelian

values('HG006','002','sup003','2017/8/17','200','3000','600000')

insert into pembelian

values('HG007','003','sup008','2017/2/28','150','4000','600000')

insert into pembelian

values('HG008','009','sup005','2017/1/3','300','5000','1500000')

insert into pembelian

values('HG009','010','sup009','2017/1/15','200','2000','400000')

insert into pembelian

values('HG0010','001','sup010','2017/1/22','300','2000','600000')