PRAKTEK PEMOGRAMAN SQL

membuat table pembelian

create table pembelian

(no_nota varchar(10) primary key,

kdbrg varchar(10),

kdsup varchar(10),

tanggalbeli date,

jumlahbeli int,

hargabeli int,

total int,

foreign key (kdbrg) references barang (kdbrg),

foreign key (kdsup) references supplier (kdsup),

)

 menginputkan isi data 

insert into pembelian values ('HG001','002','Sup006','2017/01/03',200,2000,400000)

insert into pembelian values ('HG002','003','Sup007','2017/01/02',150,3000,450000)

insert into pembelian values ('HG003','004','Sup008','2017/01/02',300,4000,1200000)

insert into pembelian values ('HG004','002','Sup009','2017/01/04',100,3000,30000)

insert into pembelian values ('HG005','001','Sup010','2017/02/03',200,2000,4000000)

insert into pembelian values ('HG006','005','Sup001','2017/03/04',100,3000,300000)

insert into pembelian values ('HG007','006','Sup002','2017/04/05',300,2000,600000)

insert into pembelian values ('HG008','007','Sup003','2017/05/06',100,4000,400000)

insert into pembelian values ('HG009','008','Sup004','2017/06/07',250,5000,1250000)

insert into pembelian values ('HG010','009','Sup005','2017/07/03',200,2000,1000000)

sehingga akan terbentuk garis garis relasi