 |
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
2) Logical Basic Hotels Data Mart
3) Our Business Conceptual Data Model
This is a high-level Model to obtain agreement at the top level.
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.
|
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
June 22nd. 2017
|
© Database Answers Ltd. 2017
|
Printer-friendly version