No.

Jumlah Kode
Tanggal Nama Alamat No. Hp Satuan
Faktur Barang Barang
5/1/2022 Fulan Jalan ABC 0812348 035 10 Keping DVD17
2 Buah KBD09
5/10/2022 Andi Jalan XYZ 0812379 040 5 Buah MOS11
5 Buah MPD21
2 Buah SPK02
5/12/2022 Mika Jalan Indah 0821212 055 1 Buah RLG05
1 Buah WBC10
1 Buah USH01
Table Pembelian Table Barang
Kode Nama Harga
No. Faktur Tanggal No. Hp Satuan
Barang Barang Satuan
035 5/1/2022 0812348 DVD17 Keping DVD Blank 2,000
040 5/10/2022 0812379 KBD09 Buah Keyboard 100,000
055 5/12/2022 0821212 MOS11 Buah Mouse 90,000
Table Customer MPD21 Buah Mousepad 5,000
No. Hp Nama Alamat SPK02 Buah Speaker 150,000
0812348 Fulan Jalan ABC RLG05 Buah Ring Light 250,000
0812379 Andi Jalan XYZ WBC10 Buah Web Cam 300,000
0821212 Mika Jalan Indah USH01 Buah USB Hub 50,000
 Nama Harga Jumlah
Total
Barang Satuan Harga
DVD Blank 2,000 20,000
220,000
Keyboard 100,000 200,000
Mouse 90,000 450,000
Mousepad 5,000 25,000 775,000
Speaker 150,000 300,000
Ring Light 250,000 250,000
Web Cam 300,000 300,000 600,000
USB Hub 50,000 50,000
Table Detail_Transaksi
Kode Jumlah
No. Faktur
Barang Barang
035 DVD17 10
035 KBD09 2
040 MOS11 5
040 MPD21 5
040 SPK02 2
055 RLG05 1
055 WBC10 1
055 USH01 1
 No Faktur Tanggal Faktur Nama Pelanggan ID Pelanggan
F-20250605-007 6/5/2025 PT. Global Tech CUST004

F-20250606-008 6/6/2025 CV. Jaya Selalu CUST005

F-20250607-009 6/7/2025 PT. Maju Jaya CUST001

Table Karyawan
Karyawan Penjual ID Karyawan
EMP001 Budi Santoso
EMP002 Ani Fitri

Table Pelanggan
Telepon
ID Pelanggan Nama Pelanggan Alamat Pelanggan
Pelanggan
CUST004 PT. Global Tech Jl. Teknologi Raya No. 8, Jakarta 021-55512345
CUST005 CV. Jaya Selalu Jl. Majapahit No. 12, Semarang 024-11223344
CUST001 PT. Maju Jaya Jl. Merdeka No. 10, Jakarta 021-1234567

Table Barang
Kode Produk Nama Produk Harga Satuan
LAP-ABC01 Laptop ABC 7,500,000
PRINT-PQR03 Printer PQR 2,000,000
MON-DELL07 Monitor Dell 24" 2,500,000
SOFT-OFFC09 MS Office Lisensi 1,000,000
R0-TP-LINK11 Router TP-Link 450,000
WEB-CAM12 Webcam HD 250,000
MOUSE-XYZ02 Mouse XYZ 150,000
KEYB-LOGI04 Keyboard Logitech 300,000
HEAD-SONY05 Headphone Sony 750,000
USB-KING06 Flash Drive 32GB 75,000
SPK-JBL13 Speaker JBL 1,200,000
BAT-AA14 Baterai AA (isi 4) 30,000
CAM-CANON08 Kamera Canon EOS 8,000,000
EXT-HDD10 Eksternal HDD 1TB 900,000

Table Pembelian
No Faktur Tanggal Faktur ID Pelanggan
F-20250605-007 6/5/2025 CUST004
F-20250606-008 6/6/2025 CUST005
F-20250607-009 6/7/2025 CUST001

Table Detail Transaksi

No Faktur Kode Produk Kuantitas
F-20250605-007 LAP-ABC01 5
F-20250605-008 PRINT-PQR03 3
F-20250605-009 MON-DELL07 5
F-20250605-010 SOFT-OFFC09 10
F-20250605-011 R0-TP-LINK11 7
F-20250605-012 WEB-CAM12 8
F-20250606-008 MOUSE-XYZ02 20
F-20250606-009 KEYB-LOGI04 15
F-20250606-010 HEAD-SONY05 10
F-20250606-011 USB-KING06 50
F-20250606-012 SPK-JBL13 5
F-20250606-013 BAT-AA14 30
F-20250607-009 LAP-ABC01 1
F-20250607-010 MON-DELL07 1
F-20250607-011 CAM-CANON08 1
F-20250607-012 SOFT-OFFC09 1
F-20250607-013 EXT-HDD10 1
F-20250607-014 R0-TP-LINK11 1
 Telepon
Alamat Pelanggan Email Pelanggan Karyawan Penjual
Pelanggan
Jl. Teknologi Raya No. 8, Jakarta 021-55512345 [Link]@[Link] Budi Santoso

Jl. Majapahit No. 12, Semarang 024-11223344 [Link]@[Link] Ani Fitri

Jl. Merdeka No. 10, Jakarta 021-1234567 majujaya@[Link] Budi Santoso

Email Pelanggan
[Link]@[Link]
[Link]@[Link]
majujaya@[Link]
 ID Karyawan Kode Produk Nama Produk Kuantitas Harga Satuan Subtotal
EMP001 LAP-ABC01 Laptop ABC 5 7,500,000 37,500,000
PRINT-PQR03 Printer PQR 3 2,000,000 6,000,000
MON-DELL07 Monitor Dell 24" 5 2,500,000 12,500,000
SOFT-OFFC09 MS Office Lisensi 10 1,000,000 10,000,000
R0-TP-LINK11 Router TP-Link 7 450,000 3,150,000
WEB-CAM12 Webcam HD 8 250,000 2,000,000
EMP002 MOUSE-XYZ02 Mouse XYZ 20 150,000 3,000,000
KEYB-LOGI04 Keyboard Logitech 15 300,000 4,500,000
HEAD-SONY05 Headphone Sony 10 750,000 7,500,000

USB-KING06 Flash Drive 32GB 50 75,000 3,750,000

SPK-JBL13 Speaker JBL 5 1,200,000 6,000,000
BAT-AA14 Baterai AA (isi 4) 30 30,000 900,000
EMP001 LAP-ABC01 Laptop ABC 1 7,500,000 7,500,000
MON-DELL07 Monitor Dell 24" 1 2,500,000 2,500,000
CAM-CANON08Kamera Canon EOS 1 8,000,000 8,000,000
SOFT-OFFC09 MS Office Lisensi 1 1,000,000 1,000,000
EXT-HDD10 Eksternal HDD 1TB 1 900,000 900,000
R0-TP-LINK11 Router TP-Link 1 450,000 450,000
 Total

71,150,000

26,650,000

20,350,000