The Draft FACTS have been defined and are listed below ...

A. The Area being Modelled is :-
Accommodation - Longterm.

B. The Things of Interest, ('THINGS'), include :-
B.1 Accommodation Locations
B.2 Bookings
B.3 Guests
B.4 Units
B.5 Unit Bookings
B.6 Unit Facilities
B.7 View of Unit Status.
	This is a view derived from basic data and is
	provided to simplify identification of available units.

C. These THINGS are Related as follows :-
C.1 A GUEST can make one or many BOOKINGS
C.2 A UNIT can be booked zero, one or many times

D. Other Characteristics of these THINGS include
D.1 A UNIT has a bedroom count.
D.2 A UNIT has a room count.

E. Sample Data includes :-
To be determined

F. Typical Enquiries include :-
F.1 Find me a 5-Star Hotel in London, England.

G. DESIGN OPTIONS :
G.1 Handling Sub-Categories
       A general approach is to link the Table to itself. This allows flexible structures within the Products.
       A fixed approach is to have separate Tables for Categories and Sub-Categories.
	In this case, the general approach is recommended because change is likely to occur in the future.

G.1 Handling other Stuff associated with a PRODUCT :-
       A general approach like "Other Stuff" and "Other Stuff Type" or list them individually,
       such as SECURITY_ISSUES, etc..

       It's better to spell out the other Stuff because it makes the Database easier to understand.
       Usually the maintenance involved is not an issue.

       Different kinds of other Stuff which may occur in the future should be handled by adding specific Tables,
       reflecting the structure of the other Stuff.


Barry Williams
Principal Consultant
Database Answers
20th. January 2001