Rancangan Database Supermarket
*Tabel Penjualan Barang
*Tabel Barang
|
Kode_Barang
|
Nama_Barang
|
Satuan
|
Harga
|
|
BR-019421
|
INDOMIE
|
KARDUS
|
45000
|
|
BR-019422
|
SAUS
ABC
|
BOTOL
|
3000
|
|
BR-019423
|
KECAP
ABC
|
BOTOL
|
2500
|
|
BR-019424
|
AQUA
GALON
|
GALON
|
55000
|
*Tabel Penjualan Barang
|
Kode_Barang
|
Nama_Barang
|
Satuan
|
Harga
|
Jumlah_Barang
|
Total_Barang
|
|
BR-019421
|
INDOMIE
|
KARDUS
|
45000
|
2
|
90000
|
|
BR-019422
|
SAUS
ABC
|
BOTOL
|
3000
|
4
|
12000
|
|
BR-019423
|
KECAP
ABC
|
BOTOL
|
2500
|
2
|
5000
|
|
BR-019424
|
AQUA
GALON
|
GALON
|
55000
|
2
|
110000
|
*Tabel Transaksi
|
Kode_transaksi
|
Id_customer
|
Kode_barang
|
Tgl_transaksi
|
keterangan
|
|
K1111
|
1000
|
BR-019421
|
26-02-2015
|
Bayar lunas
|
|
K1112
|
1001
|
BR-019422
|
27-02-2015
|
Bayar lunas
|
|
K1113
|
1002
|
BR-019422
|
29-02-2015
|
Bayar lunas
|
*Tabel_Karyawan
|
Nik
|
Nama_Karyawan
|
Bagian
|
Gaji
|
|
N131
|
Ucok
|
Marketing
|
Rp.1200000
|
|
N132
|
Putra
|
Logistik
|
Rp.1100000
|
|
N133
|
Butet
|
Logistik
|
Rp.1100000
|
