Tugas 4 Praktek Pemrograman SQL

Assalamualaikum Wr. Wb

HALLO 👌

Tugas 4 Praktek Pemrograman SQL

Melanjutkan Tugas Minggu Lalu

Progdi Sistem Informasi Universitas Muria Kudus

use "201553028"

insert into Barang

values ('001','supermie','mie instan', 1500, 40)

insert into Barang

values ('002','pantene','shampo', 18000, 200)

insert into Barang

values ('003','closeup','pasta gigi', 14000, 150)

insert into Barang

values ('004','Marlboro','rokok', 20000, 300)

insert into Barang

values ('005','morinaga','susu bayi', 16500, 250)

insert into Barang

values ('006','indomilk','susu kaleng', 18000, 100)

insert into Barang

values ('007','maknyus','beras', 20000, 100)

insert into Barang

values ('008','ultra milk','susu', 18000, 150)

insert into Barang

values ('009','djarum','rokok', 12500, 200)

insert into Barang

values ('010','tropical','minyak goreng', 25000, 250)

select * from Barang

 

select * from supplier

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

)

 

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','002','SUP003','03/01/2017','150','5000','750000')

insert into pembelian

values('HG005','003','SUP004','04/01/2017','350','6000','2100000')

insert into pembelian

values('HG006','005','SUP005','04/01/2017','200','7000','1400000')

insert into pembelian

values('HG007','006','SUP007','05/01/2017','250','8000','2000000')

insert into pembelian

values('HG008','008','SUP008','05/01/2017','100','9000','900000')

insert into pembelian

values('HG009','009','SUP009','06/01/2017','350','2000','700000')

insert into pembelian

values('HG010','010','SUP010','07/01/2017','300','9000','2700000')

select*from pembelian

Waalaikumussalam Wr. Wb

Semoga bermanfaat 😉😉