create table pelanggan (Id_Pelanggan char (10) primary key, Nama_Pelanggan varchar (30) not null, Jenis_Kelamin boolean, Alamat varchar (30), Telepon char (12), Tanggal_Lahir date, Jenis_Pelanggan varchar (10));
create table karyawan (Id_Karyawan char (10) primary key, Nama_Karyawan varchar (30) not null, Alamat varchar (30), Telepon char (12), Tanggal_Lahir date, Gaji int (6));
create table jenis_barang (Id_Jenis_Barang char (8) primary key, Nama_Jenis_Barang varchar (30) not null);
create table suplier (Id_Suplier char (10), Nama_Suplier varchar (30), Alamat varchar (30), Telepon char (12));
create table transaksi (Kode_Transaksi char (10) primary key, Tanggal_Transaksi date not null, Id_Pelanggan char (10) foreign key references pelanggan(Id_Pelanggan), Id_Karyawan char (10) foreign key references karyawan(Id_Karyawan));
create table barang (Id_Barang char (5) primary key, Nama_Barang varchar (30) not null, Stock int (5), Harga int (6), Persen_Laba char (3), Diskon char (3), Id_Jenis_Barang char (8) foreign key references barang(Id_Jenis_Braang), Id_Suplier char (10) foreign key references suplier(Id_Suplier));
create table detail_transaksi (Kode_Transaksi char (10) foreign key references transaksi(Kode_Transaksi), Id_Barang char (5) foreign key references barang(Id_Barang), Jumlah int (2));

insert into pelanggan values ('1000123456','Yasir',L,'Berbah, Yogyakarta','087839353053',2018-02-20);
insert into karyawan values ('1742101511','Gerrard','Prambanan, Yogyakarta','087342551600',1992-10-30,650000);
insert into jenis_barang values ('10055001','Alat Tulis');
insert into suplier values ('1234567890','Makmur Jaya Abadi','Semin, Gunung Kidul','081877111321');
insert into transaksi (Kode_Transaksi,Tanggal_Transaksi, Id_Pelanggan, Id_Karyawan) values ('1111220001',2018-02-20);
insert into barang (Id_Barang, Nama_Barang, Stock, Harga, Persen_Laba, Diskon, Id_Jenis_Barang, Id_Suplier) values ('00010','Buku Tulis A5',30,4500,'8%','10%');
insert into detail_transaksi (Kode_Transaksi, Id_Barang, Jumlah) values (1);