Hotel (SAP Library - Reference Manual 7.2 (BC))

Hotel

The hotel table contains a list of hotels with the following information:

HNO	NAME	ZIP	CITY	ADDRESS
10	Congress	48226	Detroit	155 Beechwood Str.
20	Long Island	45211	Cincinnati	1499 Grove Street
30	Regency	97213	Portland	477 17^th Avenue
40	Eight Avenue	60601	Chicago	112 8^th Avenue
50	Lake Michigan	60615	Chicago	354 OAK Terrace 43
60	Airport	70112	New Orleans	650 C Parkway
70	Empire State	10019	New York	65 Yellowstone Dr.
80	Midtown	60607	Chicago	12 Barnard Street
90	Long Beach	90804	Long Beach	200 Yellowstone Dr.
100	Dallas	75225	Dallas	1980 34^th Str.
110	Atlantic	10570	New York	111 78^th Street
120	Sunshine	90018	Los Angeles	35 Broadway 77
130	Star	90030	Hollywood	13 Beechwood Place 2
140	River Boat	20019	Washington	788 MAIN STREET 14
150	Indian Horse	95054	Santa Clara	16 MAIN STREET

SQL statement for creating the table structure

CREATE TABLE hotel
(hno     FIXED(4) KEY CONSTRAINT hno BETWEEN 1 AND 9999,
name    CHAR(10) NOT NULL,
zip     CHAR(5) CONSTRAINT zip like '(0-9)(0-9)(0-9)(0-9)(0-9)',
city     CHAR(12) NOT NULL,
address CHAR(25) NOT NULL)