create database toko_kukuh;

create table pelanggan (id_pelanggan char(10) primary key,nama varchar(30),jenis kelamin varchar(1),alamat varchar(50),telepon char(13),tgl_lahir date,jenis_pelanggan varchar(10));
insert into pelanggan value ('0000000001','Paijo','L','jl.Sukarno no.14 Bandung','081321334244','20-04-1985','tetap');

create table karyawan (id_karyawan char(10) primary key,nama varchar(30),alamat varchar(50),telepon char(13),tgl_lahir date,gaji char(13));
insert into karyawan value('1000000003','Bambang','Jakarta','081367455354','12-08-1980','2500000');

create table jenis_brg (id_jenis_brg char(10)primary key,nama_jenis_brg varchar(30));
insert into jeins_brg value('4489892456','bengbeng');

create suplier (id_suplier char(10) primary key,nama varchar(30),alamat varchar(50),telepn char(13));
insert into suplier value('1234567890','Permata hijau','Bogor','081367456345');

create table transaksi (kode_transaksi char(20) primary key,tgl_transaksi date,id_pelanggan char(10));
alter table transaksi add foreign key (kode_transaksi)references barang(id_barang);

create table barang(id_barang char(10) primary key, nama varchar (30),stok char(30),harga int,persen_laba decimal(3),diskon decimal(2),id_jenis_barang char(5),id suplier char(10));
alter table transaksi add foreign key (kode_transaksi) references barang (id_barang);