Tugas 3 Postgres

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