Database Answers Header Chateau Laurier Hotel,Ottawa,Canada
Hotel Reservations
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
Hotel Reservations
1) A Conceptual Data Model is shown below, and a correspnding Physical Data Model is available,
2) There is also a Popkin Model and a Dezign Model for which an Access Database is available, a Top-Level Model, Revenue Data Mart and a Revenue per Room KPI
3) The Business Rules have been defined.
4) SQL has been drafted for 2 typical Queries and Oracle SQL Scripts to create the Tables.
Conceptual Data Model for a Hotel Reservations System

Barry Williams
Principal Consultant
Database Answers
London, England


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

© Database Answers Ltd. 2004