The tables used in this manual for the application 'travel agency' are completely listed in this section. The tables concerned are the tables 'customer', 'hotel', 'room', and 'reservation'.
CREATE TABLE customer
(cno FIXED(4) KEY CONSTRAINT cno BETWEEN 1 AND 9999,
title CHAR(5)
CONSTRAINT title IN ('Mr','Mrs','Comp'),
name CHAR(8) NOT NULL,
firstname CHAR(7),
city CHAR(11) NOT NULL,
CONSTRAINT zip BETWEEN 10000 AND 99999,
state CHAR(2),
zip FIXED(5),
account FIXED(7,2)
CONSTRAINT account BETWEEN -10000 AND 10000)
CREATE TABLE hotel
(hno FIXED (4) KEY,
CONSTRAINT hno BETWEEN 1 AND 9999,
name CHAR (13) NOT NULL,
city CHAR (11) NOT NULL,
state CHAR (2) NOT NULL,
zip FIXED (5)
CONSTRAINT zip BETWEEN 10000 AND 99999,
address CHAR (25) NOT NULL)
CREATE TABLE room
(hno FIXED (4) KEY,
roomtype CHAR (6)
CONSTRAINT roomtype IN
('single', 'double', 'suite'),
max_free FIXED (3) CONSTRAINT max_free >= 0,
price FIXED (6,2)
CONSTRAINT price BETWEEN 0.00 AND 1000.00)
CREATE TABLE reservation
(rno FIXED(4) KEY
CONSTRAINT rno BETWEEN 1 AND 9999,
cno FIXED(4)
CONSTRAINT cno BETWEEN 1 AND 9999,
hno FIXED(4)
CONSTRAINT rno BETWEEN 1 AND 9999,
roomtype CHAR (6)
CONSTRAINT roomtype IN
('single', 'double', 'suite'),
arrival DATE NOT NULL,
departure DATE
CONSTRAINT departure > arrival)
