Pertemuan ke-6

database : Perpustakaan

create table penerbit (

   kdpenerbit char (4) not null primary key,

   namapenerbit varchar (30))

create table penerbit1(

   kdpenerbit char (4),

   namapenerbit varchar (30))

kdpenerbit                namapenerbit

P001                         Piksi ITB

P002                         Ganesha

P003                          Epsilon

P004                          Gramedia

 

 

SELECT * FROM PENERBIT1

INSERT INTO PENERBIT VALUES ('P001','PIKSI ITB')

INSERT INTO PENERBIT VALUES ('P002','GANESA')

INSERT INTO PENERBIT VALUES ('P003','EPSILON')

INSERT INTO PENERBIT VALUES ('P004','GRAMEDIA')

CREATE TABLE BUKU(

KDBUKU CHAR(4)NOT NULL PRIMARY KEY,

JUDUL VARCHAR (30),

PENGARANG VARCHAR (30),

JML_BUKU INT,

KDPENERBIT CHAR (4) REFERENCES PENERBIT (KDPENERBIT))

SELECT * FROM BUKU

INSERT INTO BUKU VALUES ('B001','DOS','M.URIP',10,'P001')

INSERT INTO BUKU VALUES ('BD02','DBASE III PLUS','EPSI B',5,'P002')

INSERT INTO BUKU VALUES ('BD03','CLIPPER','AHMAD G',4,'P003')

INSERT INTO BUKU VALUES ('B004','FISIKA','SUTRISNO',10,'P004')

INSERT INTO BUKU VALUES (‘B005’,’B.INDONESIA’,’SUSI’,’10’,’P005)