shalfa

link :
https://drive.google.com/drive/folders/18w6N4iDNqqjStizCx2YswyaLaF8ZSUGZ

CREATE TABLE Buku(
NIB CHAR (4) PRIMARY KEY,
JUDUL VARCHAR (30) not null,
PENGARANG VARCHAR (20) not null,
ISBN VARCHAR (20) not null
);


CREATE TABLE TRPEMINJAMAND(
KODE_PINJAM CHAR (4) PRIMARY KEY,
NIB CHAR (4) not null,
TGLKEMBALI DATE not null,
DENDA NUMERIC (9,0),

FOREIGN KEY (KODE_PINJAM) REFERENCES Buku,
foreign key (NIB) references Buku
);

CREATE TABLE TRPEMINJAMANH(
KODE_PINJAM CHAR (4) PRIMARY KEY,
NIK CHAR (4) not null,
NIM CHAR (10)not null,
TGLPINJAM DATE not null,

foreign key (NIM) references Mahasiswa,
foreign key (NIK) references Karyawan,

);

CREATE TABLE Mahasiswa(
NIM CHAR (10) primary key not null,
NAMA_MAHASISWA VARCHAR (30) not null,
ALAMAT_MAHASISWA VARCHAR (30) not null,
NOTELP_MAHASISWA VARCHAR (15),

);


CREATE TABLE Karyawan(
NIK CHAR (4) primary key,
NAMA_KARYAWAN VARCHAR (20) not null,
ALAMAT_KARYAWAN VARCHAR (30) not null,
NOTELP_KARYAWAN  VARCHAR (15) not null,
JABATAN VARCHAR (25) not null,

);

cek
drop table trpeminjamand;

CREATE TABLE trpeminjamand (
    kode_pinjam char(4) NOT NULL,
    nib char(4) NOT NULL,
    tgl_kembali date NOT NULL,
    denda numeric(9,0) NOT NULL,
    CONSTRAINT PK_trpeminjamand PRIMARY KEY (kode_pinjam,nib)
);

ALTER TABLE TRPEMINJAMAND
ADD FOREIGN KEY (KODE_PINJAM) REFERENCES TRPEMINJAMAND(kode_pinjam);

ALTER TABLE TRPEMINJAMAND
ADD FOREIGN KEY (nib) REFERENCES Buku(nib);