Data for Hotel
'fb01', 'Grosvenor', 'London'
'fb02', 'Watergate', 'Paris'
'ch01', 'Omni Shoreham', 'London'
'ch02', 'Phoenix Park', 'London'
'dc01', 'Latham', 'Berlin'

Data for Rooms
501, 'fb01', 'single', 19
601, 'fb01', 'double', 29
701, 'fb01', 'family', 39
1001, 'fb02', 'single', 58
1101, 'fb02', 'double', 86
1001, 'ch01', 'single', 29.99
1101, 'ch01', 'family', 59.99
701, 'ch02', 'single', 10
801, 'ch02', 'double', 15
901, 'dc01', 'single', 18
1001, 'dc01', 'double', 30
1101, 'dc01', 'family', 35

Data for Booking
'fb01', 10001, '01-Apr-04', '08-Apr-04', 501
'fb01', 10004, '15-Apr-04', '15-May-04', 601
'fb01', 10005, '02-May-04', '07-May-04', 501
'fb01', 10002, '16-May-04', '29-May-04', 601
'fb01', 10001, '01-May-04', null, 701
'fb02', 10003, '05-Apr-04', '10-Apr-04', 1001
'fb02', 10005, '12-May-04', '30-May-04', 1101
'ch01', 10006, '21-Apr-04', null, 1101
'ch02', 10002, '25-Apr-04', '06-May-04', 801
'dc01', 10007, '13-May-04', '15-May-04', 1001
'dc01', 10003, '20-May-04', null, 1001

Data for guest
10001, 'John Kay', '56 High St, London'
10002, 'Mike Ritchie', '18 Tain St, London'
10003, 'Mary Tregear', '5 Tarbot Rd, Aberdeen'
10004, 'Joe Keogh', '2 Fergus Dr, Aberdeen'
10005, 'Carol Farrel', '6 Achray St, Glasgow'
10006, 'Tina Murphy', '63 Well St, Glasgow'
10007, 'Tony Shaw', '12 Park Pl, Glasgow'