Create Database Perpustakaan
use  Perpustakaan

create table MAHASISWA1(
No_induk Char(5)not null primary key,
Nama varchar(30),
Alamat VARchar(30))

Select*from MAHASISWA
insert into mahasiswa values('001','dian andika','jln.merdeka')
insert into mahasiswa values('002','joko ari','jln.sudirman')
insert into mahasiswa values('003','desman siahaan','jln.tanah jawa')

create table penerbit1(
kd_penerbit char(5)not null primary key,
nama_penerbit varchar(20))

select*from penerbit

insert into penerbit values('H004','DataBAse')
INSERT INTO penerbit values('I005','Pascal')
INSERT INTO penerbit values('J006','dELPHI')

create table BUKU1(
kode_buku char(4)primary key,
Judul char(20),
pengarang char (15),
jml_buku int,
kode_penerbit char (5) references penerbit (kd_penerbit))

select*from buku
insert into buku values('K4','DataBAse','ANDI AZIS','2','H004')
INSERT INTO buku values('I5','Pascal','Desman Siahaan','3','I005')
INSERT INTO buku values('J6','dELPHI','jonatan','1','J006')

create table pinjam(
tgl_pinjam datetime,
No_induk char(5)references Mahasiswa(No_induk),
kode_buku char (4)references buku(kode_buku),
tgl_hrs_kembali datetime,
tgl_kembali datetime,)

select*from pinjam1
insert into pinjam1 values('2012-03-26','001','K4','2102-03-31','2102-03-31')
INSERT INTO pinjam1 values('2012-03-20','002','I5','2012-03-27','2012-03-27')
INSERT INTO pinjam1 values('2012-03-25','003','J6','2012-03-30','2012-03-30')