Untuk struktur tabel Pembeliannya dalah sebagai berikut :
Struktur Tabel Pembelian :
No.
|
Field
|
Type
|
Size
|
Ket
|
1
|
Nonota
|
Varchar
|
10
|
Primary key
|
2
|
Kdbrg
|
Varchar
|
10
|
Secondary Key
|
3
|
Kdsupplier
|
Varchar
|
10
|
Secondary Key
|
4
|
Tanggalbeli
|
Date
|
-
|
-
|
5
|
Jumlahbeli
|
Integer
|
-
|
-
|
6
|
Hargabeli
|
Integer
|
-
|
-
|
7
|
Total
|
Integer
|
-
|
-
|
Adapun Relasi antar tabelnya adalah seperti di bawah ini :
SQL Query :
Create tabel Pembelian :
select*from barang
select*from Supplier
create table pembelian
(Nonota
varchar(10) Primary key,
Kdbrg varchar(10) Foreign key references barang,
Kdsupplier varchar(10) Foreign key references
supplier,
Tanggalbeli date,
Jumlahbeli int,
Hargabeli int,
Total int
)
Setelah berhasil membuat tabel, isikan 3 data lalu tambahkan lagi sebanyak 7 data agar jumlahnya menjadi 10 data :
insert into pembelian values
('HG001','001','sup006','03/01/2017','200','2000','400000'),
('HG002','004','Sup002','02/01/2017','150','3000','450000'),
('HG003','005','Sup001','02/01/2017','300','4000','1200000'),
('HG004','002','sup008','05/01/2017','100','2500','250000'),
('HG005','004','Sup003','05/01/2017','200','3500','700000'),
('HG006','002','Sup006','06/01/2017','100','4000','400000'),
('HG007','001','sup003','06/01/2017','200','3000','600000'),
('HG008','001','Sup009','07/01/2017','250','2000','500000'),
('HG009','005','Sup007','08/01/2017','350','2000','700000'),
('HG010','003','Sup002','08/01/2017','200','4000','800000')
Jika berhasil, maka hasilnya seperti di bawah ini :
No comments:
Post a Comment