Pembuatan Database Hotel Menggunakan SQL

1. Table Kamar

   

CREATE table Kamar (

KdKamar text (5) Primary Key, NoKamar text (5), JenisKamar text (15), Tarif currency);

INSERT into Kamar

   Values (“02101”,”101”,”Standard-Room”,”300000”)

INSERT into Kamar

   Values (“02102”,”102”,”Standard-Room”,”300000”)

INSERT into Kamar

   Values (“02201”,”201”,”Suite”,”450000”)

INSERT into Kamar

   Values (“02202”,”202”,”Suite”,”450000”)

INSERT into Kamar

   Values (“02203”,”203”,”Suite”,”450000”)

 

2. Table Penyewa

CREATE table Penyewa (

KdPenyewa text (10) Primary Key, NmPenyewa text (20), Alamat text (30), NoTelp text (12));

INSERT into Penyewa

   Values (“10103”,”Dimas Rizki”,”Semarang”,”085642319756”)

INSERT into Penyewa

   Values (“10104”,”Budi Darmawan”,”Jakarta”,”081223954781”)

INSERT into Penyewa

   Values (“11001”,”Dewi Ayu”,”Surabaya”,”081852963743”)

INSERT into Penyewa

   Values (“11002”,”Adisetya”,”Surabaya”,”085740369258”)

INSERT into Penyewa

   Values (“11003”,”Diana S”,”Jakarta”,”085987689633”)

  

3. Table Penyewaan

CREATE table Penyewaan (

NoKamar text (5) Primary Key, NamaPenyewa text (20), TglMasuk DateTime, TglKeluar DateTime, Tarif currency);

INSERT into Penyewaan

   Values (“101”,”Dimas Rizki”, ”29/10/2011”, “30/10/2011”, ”300000”)

INSERT into Penyewaan

   Values (“102”,”Budi Darmawan”, ”29/10/2011”, “30/10/2011”, ”300000”)

INSERT into Penyewaan

   Values (“101”,”Dewi Ayu”, ”02/11/2011”, “05/11/2011”, ”900000”)

INSERT into Penyewaan

   Values (“202”,”Adisetya”, ”04/11/2011”, “06/11/2011”, ”900000”)

INSERT into Penyewaan

   Values (“203”,”Diana S”,”05/11/2011”,“06/11/2011”,”450000”)