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”)