CREATE DATABASE tugas;
USE tugas;

CREATE TABLE buku(kd_buku VARCHAR(5) PRIMARY KEY,
judul_buku VARCHAR (50) NOT NULL,
pengarang VARCHAR (100) NOT NULL,
penerbit VARCHAR (100) NOT NULL,
jumlah_buku INT (11) NOT NULL);

CREATE TABLE petugas (kd_petugas VARCHAR (5) PRIMARY KEY,
nama_petugas VARCHAR (100) NOT NULL,
alamat_petugas VARCHAR (100) NOT NULL);

CREATE TABLE pelanggan (kd_pelanggan VARCHAR(5) PRIMARY KEY,
nama_pelanggan VARCHAR(100) NOT NULL,
alamat_pelanggan VARCHAR (100) NOT NULL);

CREATE TABLE pembelian (kd_beli VARCHAR (5) PRIMARY KEY,
kd_petugas VARCHAR (5) NOT NULL,
kd_pelanggan VARCHAR (5) NOT NULL,
tanggal_jual DATE NOT NULL,
total_jual INT (11) NOT NULL,
total_item INT (11) NOT NULL);

CREATE TABLE detailpembelian (kd_detail VARCHAR(5) PRIMARY KEY,
kd_beli VARCHAR(5) NOT NULL,
kd_buku VARCHAR(5) NOT NULL,
jml_beli INT (11) NOT NULL);