Nama : Moro NIM : 1742101567 Tugas BASIS DATA TGL 23 APRIL 2018 CREATE DATABASE penjualan; USE penjualan; CREATE TABLE Pelanggan(id_pelanggan CHAR(10) PRIMARY KEY, nama VARCHAR(30), jenis_kelamin CHAR(10), alamat VARCHAR(30), telepon CHAR(13), tgl_lahir DATE, jenis_pelanggan VARCHAR(20)); 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(20)); CREATE TABLE suplier(id_suplier CHAR(10) PRIMARY KEY, nama VARCHAR(30), alamat VARCHAR(30), telepon CHAR(13)); 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('11111','Ariel','Nikki','Gunawan','085332363710','11-05-1998','Gold'); INSERT INTO karyawan VALUES('11122','Nike Ardila','Laras','085332363711','21-06-1990','1.250.000'); INSERT INTO jenis_barang VALUES('54311','Sabun'); INSERT INTO suplier VALUES('45511','Ayu Ting-Ting','Lesti','0858264556125'); INSERT INTO transaksi VALUES('16611','23-04-2018','11121','53151'); INSERT INTO barang VALUES('16911','Judika','15','200.000','20%','70%','54311','45511'); INSERT INTO detail_transaksi VALUES('16611','16911'); ALTER TABLE transaksi ADD FOREIGN KEY (kode_transaksi) REFERENCES barang(id_barang);