PDM
TABEL
BUKU PENERBIT TERBANYAK
-- Table: buku_penerbit_terbanyak
-- DROP TABLE buku_penerbit_terbanyak;
CREATE TABLE buku_penerbit_terbanyak
(
id_buku character varying(30) NOT NULL,
jenis_buku character varying(30) NOT NULL,
jumlah_ character(40) NOT NULL,
CONSTRAINT pk_buku_penerbit_terbanyak PRIMARY KEY (id_buku, jenis_buku, jumlah_)
)
WITH (
OIDS=FALSE
);
ALTER TABLE buku_penerbit_terbanyak OWNER TO postgres;
BUKU YANG ADA DI TABEL PENERBIT
BUKU YANG TIDAK ADA DI TABEL PENERBIT
PEMINJAM TERBANYAK
SANKSI DENDA
-- Table: sanksi_denda
-- DROP TABLE sanksi_denda;
CREATE TABLE sanksi_denda
(
id_nomor character varying(30) NOT NULL,
nama_peminjam character varying(30) NOT NULL,
jumlah_dipinjam character varying(40) NOT NULL,
cost_denda character varying(40) NOT NULL,
alamat character varying(40) NOT NULL,
no_tlp character varying(40) NOT NULL,
CONSTRAINT pk_sanksi_denda PRIMARY KEY (id_nomor, nama_peminjam, jumlah_dipinjam, cost_denda, alamat, no_tlp)
)
WITH (
OIDS=FALSE
);
ALTER TABLE sanksi_denda OWNER TO postgres;
CDM
