Nama : Geo Nelson 
	NIM  : 1742101575

Tugas Basis Data 





CREATE DATABASE penjualan;
USE penjualan;
CREATE TABLE pelanggan(id_pelanggan CHAR(10) PRIMARY KEY, nama VARCHAR(27), jenis_kelamin CHAR(1), alamat VARCHAR(20), telepon CHAR(13), tgl_lahir DATE, jenis_pelanggan VARCHAR(15));
CREATE TABLE karyawan(id_karyawan CHAR(10) PRIMARY KEY, nama VARCHAR(30), alamat VARCHAR(30), telepon CHAR(13), tgl_lahir DATE, gaji CHAR(20));
CREATE TABLE jenis_barang(id_jenis_brg CHAR(10) PRIMARY KEY, nama_jenis_brg VARCHAR(30));
CREATE TABLE suplier(id_suplier CHAR(12) PRIMARY KEY, nama VARCHAR(25), alamat VARCHAR(15), telepon CHAR(14));
CREATE TABLE transaksi(kode_transaksi CHAR(10) PRIMARY KEY, tgl_transaksi DATE, id_pelanggan CHAR(10), id_karyawan CHAR(10));
CREATE TABLE barang(id_barang CHAR(10) PRIMARY KEY, nama VARCHAR(30), stok CHAR(5), harga CHAR(20), persen_laba CHAR(2), diskon CHAR(3), id_jenis_brg CHAR(10), id_suplier CHAR(10));
CREATE TABLE detail_transaksi(kode_transaksi CHAR(10), id_barang CHAR(10), jumlah CHAR(15));
INSERT INTO pelanggan VALUES('12345','KL','L','Cupuwatu','082134357542','24-5-2000','Gold');
INSERT INTO karyawan VALUES('142315','Iman','L','082134526171','21-06-1990','1.000.000');
INSERT INTO jenis_barang VALUES('76869','Sapu');
INSERT INTO suplier VALUES('7686954','Dobiki','selokan mataram','0858264556125');
INSERT INTO transaksi VALUES('16611','23-04-2018','11121','53151');
INSERT INTO barang VALUES('16911','andini','15','200.000','20%','70%','54311','45511');
INSERT INTO detail_transaksi VALUES('87961','09573');
ALTER TABLE transaksi ADD FOREIGN KEY (kode_transaksi) REFERENCES barang(id_barang);