Database Answers My favourite Hotel (in Santa Barbara, California)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
The Hotels Platform   

Click here to see a Backup-up version of this Home Page, here for the Apex version and here for the End2End View.

Screenshot of Hotels POC

0) POC Hotel and Generic Events Model
Demo data loaded on June 24th. 2017


0b) POC Hotel and Generic Events Model


1) Conceptual Basic Hotels Data Mart


Basic Data Mart for Hotels Platform
2) Logical Basic Hotels Data Mart


Logical Basic Data Mart for Hotels Platform
3) Our Business Conceptual Data Model
This is a high-level Model to obtain agreement at the top level.

Conceptual Data Model for Hotels Platform
CRUD Services will include the following :-
1) 'Make a Booking' by Creating a record in the Hotel Events Entity in the Logical Model.
2) 'Check in' by Updating a Booking record or Creating a new record for a Guest who does not have a booking.
3) 'Check out' by Updating the record for a Guest who is checked in.
4) 'Make a Payment' by Creating a record in the Hotel Events Table

4) Physical Data Model
The 'Hotel Users' Entity allows for Users to maintain their own confidential Data.
This Model is used to generate SQL Scripts to create Databases.
I started creating Tables in Apex at 9.30 pm on Wednesday, June 14th. 2017.

Physical Data Model for Hotels Platform

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
June 22nd. 2017


© Database Answers Ltd. 2017
About Us Contact Us