truncate table booking;
truncate table room;
truncate table guest;
truncate table hotel; 

insert into hotel values
 ('H100','Sheraton','Melbourne');
insert into hotel values
 ('H200','Shangra_La','Sydney');
insert into hotel values
 ('H300','Hilton', 'Perth');

insert into room values
 ('1','H100','S',220.00);
insert into room values
 ('2','H100','D',230.00);
insert into room values
 ('3','H100','F',310.00);
insert into room values
 ('1','H200','S',260.00);
insert into room values
 ('2','H200','D',170.00);
insert into room values
 ('3','H200','S',250.00);
insert into room values
 ('4','H200','F',180.00);
insert into room values
 ('5','H200','F',295.00);
insert into room values
 ('1','H300','D',200.00);
insert into room values
 ('2','H300','S',420.00);

insert into guest values
 ('G001','Tina Duncan','Sydney');
insert into guest values
 ('G002','Paul Happy','Sydney');
insert into guest values
 ('G003','Jenny Freeman','Canberra');
insert into guest values
 ('G012','Dianne Kelly','Adelaide');
insert into guest values
 ('G005','Steve Kirkwood','Hobart');
insert into guest values
 ('G006','Martin Ferguson','Darwin');
insert into guest values
 ('G007','Vanessa Horton', 'Hobart');
insert into guest values
 ('G008','Bianca Begg', 'Sydney');

insert into booking values
 ('H100','G001','15-AUG-12','17-AUG-12','1');
insert into booking values
 ('H100','G002','30-AUG-12', '15-SEP-12','2');
insert into booking values
 ('H100','G002','1-AUG-12','2-AUG-12','2');
insert into booking values
 ('H100','G005','10-AUG-12','11-AUG-12','2');
insert into booking values
 ('H100','G003','1-SEP-12','15-SEP-12','3');
insert into booking values
 ('H100','G006','31-JUL-12','2-AUG-12','1');
insert into booking values
 ('H200','G002','11-JUL-12','1-AUG-12','1');
insert into booking values
 ('H200','G005','12-JUL-12','13-JUL-12','1');
insert into booking values
 ('H200','G006','14-JUL-12','15-JUL-12','1');
insert into booking values
 ('H200','G001','17-AUG-12','28-AUG-12','2');
insert into booking values
 ('H200','G003','31-JUL-12','1-SEP-12','1');
insert into booking values
 ('H200','G006','31-AUG-12','1-SEP-12','2');
insert into booking values
 ('H200','G005','31-AUG-12', '15-SEP-12','4');
insert into booking values
 ('H300','G007','1-SEP-12', '15-SEP-12', '1');

commit;