TUGAS DATABASE

create database sri_wahyuni_simanjuntak
create table Buku(
Kode_Buku char (4),
Judul char (20),
Pengarang char (15),
Jml_Buku int ,
Kode_Penerbit char (2))
go
select * from buku
insert into Buku
Values('S001','DOS','M.Urip',10,01)
go
insert into Buku
Values('B001','Dbase III Plus','Epsi B',5,01)
go
insert into Buku
Values('BD04','Clipper','Ahmad G',4,02)
go
insert into Buku
Values('F101','Fisika','Sutris',10,04)
go
select * from buku

create table Penerbit(
Kode_Penerbit char (12),
Nama_Penerbit char (15))
go
insert into Penerbit
values(01,'Piksi ITB')
go
insert into Penerbit
values(02,'Ganesha')
go
insert into Penerbit
values(03,'Epsilon')
go
insert into Penerbit
values(04,'Gramedia')
go
select * from Penerbit

create table Pinjam(
Tgl_Pinjam datetime,
Mhs_no_Induk char (9),
buk_Kode_buku char (4),
Tgl_harus_kembali datetime,
Tgl_kembali datetime)
go

create table Pinjam(
Tgl_Pinjam datetime,
Mhs_no_Induk char (9),
Kode_buku char (4),
Tgl_harus_kembali datetime,
Tgl_kembali datetime)
go
select*from Pinjam
insert into Pinjam
values('2003/04/20',123010001,'S001','2003/04/23','2003/04/23')
go
insert into Pinjam
values('2003/04/20',123010002,'S001','2003/04/23','2003/04/22')
go
insert into Pinjam
values('2003/04/20',123010003,'B001','2003/04/23','2003/04/24')
go
insert into Pinjam
values('2003/04/21',123010003,'B004','2003/04/24','2003/04/25')
go
insert into Pinjam
values('2003/04/21',123010004,'F101','2003/04/23','2003/04/25')
go
insert into Pinjam
values('2003/04/21',123010001,'S001','2003/04/24','2003/04/24')
insert into Pinjam
values('2003/04/21',123010001,'B001','2003/04/24','2003/04/24')
go

Select* From Pinjam