Praktek Pemrograman SQL-4

Hari/Tanggal : Selasa/ 04 April

Relasi Antar Tabel

use "201553066"

create table pembelian (

Nonota 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))

insert into pembelian

values

('HG001','002','Sup003','2017/01/03',200,2000,400000),

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

('HG003','003','Sup002','2017/01/01',300,4000,1200000),

('HG004','001','Sup004','2017/01/04',200,5000,1000000),

('HG005','006','Sup001','2017/01/04',100,6000,600000),

('HG006','005','Sup007','2017/01/05',250,6500,1625000),

('HG007','007','Sup005','2017/01/05',100,4000,400000),

('HG008','010','Sup008','2017/01/06',150,2000,300000),

('HG009','009','Sup010','2017/01/06',300,3000,900000),

('HG010','008','Sup009','2017/01/06',400,5000,2000000)

select*from pembelian

 

Relasi dari ketiga tabel tersebut adalah sebagai berikut: