10) Revenue Data Mart (a starting-point for discussion)
9) Conceptual Bookings Data Mart
8) Logical Data Model for Reporting Services
7) Layers in Hotel Platform
6) Customers and Guests Data Model
5) DBA Business Platform showing Services
4) Apex Logical Data Model
CRUD Operations are required for these Entities :-
1) Transaction Data - Bookings, Check-ins,Check-outs, Guests, events, Payments
2) Master Data - Hotels, Hotel Users, Rooms, Services.
3) Reference Data - Booking Status, Calendar, Country Codes, Event Types, Payment Methods.
TRANSACTIONS and PSEUDO-SQL
Transaction 1) - 'Customer makes a Booking' -
Create - INSERT INTO Hotel_Events (Customer_ID '1', Platform_Code 'Hotel', Service_Code 'Make Booking' Date_Time SYSDATE(Now'))
Transaction 2) - 'Customer checks in' -
Update - UPATE Event
Customer_ID 'Customer_ID',
Platform_Code 'Hotel',
Service_Code 'Check in'
Date_Time SYSDATE(Now)
WHERE Customer_Name = 'John Doe'
Transaction 3) - 'Customer makes Payment' -
Upate - UPDATE Event
Customer_ID 'Customer_ID',
Platform_Code 'Hotel',
Customer_ID,
Service_Code 'Make Payment'
Date_Time SYSDATE(Now')
Transaction 4) - 'Customer checks out' -
Update - UPDATE Event
Customer_ID 'Customer_ID',
Platform_Code 'Hotel',
Service_Code 'Check out'
Date_Time SYSDATE(Now')
3.1) Events and Sub-Events
3.2) Gen Events and Sub-Events
2) Generic Data Platform
1) Canonical Data Model