Database Answers Header Chateau Laurier,Ottawa,Canada
Acommodation Long-term
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
Boschendahl Estate, South Africa A (Dezign) Data Model is available.

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

[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Site Map ]

© Database Answers Ltd. 2001