1742101595.
I Created on SQLyog.

SHOW DATABASES;
CREATE DATABASE worksheet;
USE worksheet;
SHOW TABLES;


/* TABLE PELANGGAN */
CREATE TABLE pelanggan (id_pl VARCHAR(8) PRIMARY KEY, 
nama_pl VARCHAR(20), jk_pl CHAR(10), tel_pl CHAR(10), tgl_lhr_pl INT(8), 
jenis_pl CHAR(10));
DROP TABLE pelanggan;
SELECT * FROM pelanggan;
INSERT INTO pelanggan VALUES ('11120002','James','male','0877381212','03052017','premium');

/* TABLE KARYAWAN */
CREATE TABLE karyawan (id_kar INT(6), nama_kar VARCHAR(25), alamat_kar VARCHAR(40),
notelp_kar INT(12), tgllahir_kar INT(8), gaji_kar INT(15));
INSERT INTO karyawan VALUES ('101012','Jack Weisger','Jl.Solo, Maguwo, Sleman, DIY','0871112','03051999','150000000');
SELECT * FROM karyawan;


/* TABLE jenis_barang*/
CREATE TABLE jenis_barang (id_jenis_barang VARCHAR(10) PRIMARY KEY,
nama_jenis_barang VARCHAR (40));
DESC FROM jenis_barang;
INSERT INTO jenis_barang VALUES ('010003','sabun cuci pakaian');
SELECT * FROM jenis_barang;

/* TABLE SUPLIER */
CREATE TABLE suplier (id_suplier CHAR(6) PRIMARY KEY, nama_suplier VARCHAR(25),
alamat CHAR(20), telepon CHAR(12));
DESC suplier;
INSERT INTO suplier VALUES ('100001','Patrick Weiger','Sleman, DIY','088888888');
SELECT * FROM suplier;

/* TABEL TRANSAKSI */
CREATE TABLE transaksi (id_transaksi VARCHAR(6) PRIMARY KEY,
tgl_transaksi INT(10), id_pelanggan CHAR(6), id_karyawan CHAR(6));
DESC transaksi;
INSERT INTO transaksi VALUES ('120001','23032008','000001','101012');
SELECT * FROM transaksi;



/*TABLE BARANG */
CREATE TABLE barang (id_barang CHAR(6) PRIMARY KEY, nama_barang VARCHAR(15), 
stok INT(5), harga INT(10), persen_laba INT(10), diskon INT(10),
id_jenis_barang CHAR(6), id_suplier CHAR(6));
DESC barang;
INSERT INTO barang VALUES ('020003','rinso','20','2500','10','1','010003','100001');
SELECT * FROM barang;


/* TABLE DETAIL TRANSAKSI */
CREATE TABLE detail_transaksi (id_tranksaksi VARCHAR(6) NOT NULL,
id_barang VARCHAR(10) NOT NULL, jumlah INT(10));
ALTER TABLE detail transaksi ADD FOREIGN KEY id_transaksi
DESC detail_transaksi;
INSERT INTO detail_transaksi VALUES ('120001','020003','5');
SELECT * FROM detail_transaksi;