TUGAS DATABASE PERPUSTAKAAN

TUGAS 2

create database Perpustakaan
use Perpustakaan
create table Buku(
  Kode_Buku Char(5),
  Judul_Buku Varchar(30))
  select*from Buku
insert into Buku Values ('01234','Photoshop')
insert into Buku Values ('01235','CorelDraw')
insert into Buku Values ('01236','Pagemaker')
insert into Buku Values ('01237','CorelDraw')
create table Editor(
  Penerbit Char(10),
  Layout_Buku Varchar(25))
  select*from Editor
insert into Editor Values ('Gramedia','Dewiq')
insert into Editor Values ('Gramedia','Ganz')
insert into Editor Values ('Gramedia','Erykson')
insert into Editor Values ('Gramedia','Nia')