mysql> create table jenis_produk(
    -> id integer primary key auto_increment,
    -> nama varchar(50));
Query OK, 0 rows affected (0.11 sec)

mysql> create table satuan(
    -> id integer primary key auto_increment,
    -> kode char(5),
    -> nama varchar(30));
Query OK, 0 rows affected (0.13 sec)

mysql> create table produk(
    -> id integer primary key auto_increment,
    -> id_jenis int,
    -> nama varchar(150),
    -> stok int,
    -> id_satuan int,
    -> harga double);
Query OK, 0 rows affected (0.14 sec)

mysql> insert into jenis_produk(nama) values ('FnB');
mysql> insert into jenis_produk(nama) values ('ATK');
mysql> insert into jenis_produk(nama) values ('Elektronik');

mysql> insert into satuan(kode,nama) values ('kg','kilogram');
mysql> insert into satuan(kode,nama) values ('pc','piece');
mysql> insert into satuan(kode,nama) values ('l','liter');
mysql> insert into satuan(kode,nama) values ('doz','lusin');
mysql> insert into satuan(kode,nama) values ('pax','pack');
mysql> insert into satuan(kode,nama) values('rim','rim');

mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(1,'Wafer Selamat',176,2,10800);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(1,'Air Mineral 600ml',42,5,42700);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(1,'Mie Instan Goreng',196,2,2250);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(1,'Telur Omega 3',16,4,27000);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(2,'Kertas A4',25,6,32000);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(2,'Pulpen',43,4,18000);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(2,'Buku Tulis',30,5,64000);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(3,'Mouse Wireless',15,2,210000);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(3,'TV LCD 32',6,2,3650000);
mysql> insert into produk(id_jenis,nama,stok,id_satuan,harga) values(3,'Netbook i3',3,2,5600000);