insert into City
Values ('Canberra');

insert into Hotel
values ('Ridges Lakeside', '25 Lake Way', '6328 4383',
'Jones', 'Canberra', 75);

insert into RoomType
values ('Small', 2);
insert into RoomType
values ('Medium', 4);
insert into RoomType
values ('Huge', 75);

insert into Room
values (1, 'Ridges Lakeside', 'Small', 2, 'No');
insert into Room
values (2, 'Ridges Lakeside', 'Medium', 3, 'Yes');
insert into Room
values (3, 'Ridges Lakeside', 'Huge', 5, 'No');
insert into Room
values (4, 'Ridges Lakeside', 'Small', 1, 'No');

insert into RoomTarrif
values (25, 35, 10, 'Ridges Lakeside', 'Small');
insert into RoomTarrif
values (35, 50, 15, 'Ridges Lakeside', 'Medium');
insert into RoomTarrif
values (50, 70, 20, 'Ridges Lakeside', 'Huge');

insert into Guest
values ('Joseph', '24 Hurley', '6161 5596', '1234', 'Money');
insert into Guest
values ('Jim', '9 Pyke', '6296 3975', '4321', 'Cash');
insert into Guest
values ('Matt', '1 Rymell', '6284 4586', '1010', 'Visa');
insert into Guest
values ('Warren', '77 Bing', '6298 5456', '0101', 'Mastercard');

insert into AdvanceBooking
values ('3-JUN-1923', '7-JUN-1927', 62, 1, 2, 'Ridges Lakeside', 'Joseph');
insert into AdvanceBooking
values ('3-SEP-1999', '7-SEP-1999', 232, 2, 3, 'Ridges Lakeside', 'Jim');
insert into AdvanceBooking
values ('30-NOV-2002', '30-DEC-2002', 666, 3, 1, 'Ridges Lakeside', 'Matt');
insert into AdvanceBooking
values ('12-OCT-2001', '7-JUN-2009', 1281, 4, 77, 'Ridges Lakeside', 'Warren');

insert into Allocation
values (2, '6-NOV-2002', 'Yes', 2, 'Joseph', 'Ridges Lakeside');
insert into Allocation
values (1, '12-JUL-2002', 'No', 1, 'Jim', 'Ridges Lakeside');
insert into Allocation
values (3, '9-FEB-2003', 'Yes', 3, 'Warren', 'Ridges Lakeside');
insert into Allocation
values (3, '10-FEB-2003', 'Yes', 3, 'Warren', 'Ridges Lakeside');
insert into Allocation
values (3, '11-FEB-2003', 'Yes', 3, 'Warren', 'Ridges Lakeside');
insert into Allocation
values (6, '11-OCT-2002', 'Yes', 4, 'Matt', 'Ridges Lakeside');
insert into Allocation
values (6, '15-SEP-02', 'Yes', 3, 'Joseph', 'Ridges Lakeside');

insert into ResturauntCharge
values ('Breakfast', 7, 'Cash?', 812, '9-FEB-2003', 'Warren');
insert into ResturauntCharge
values ('Lunch', 7, 'Yum!', 384, '10-FEB-2003', 'Warren');
insert into ResturauntCharge
values ('Dinner', 7, 'Credit', 9328, '11-FEB-2003', 'Warren');