Database Answers London Heathrow Terminal 5
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for an Air Transport Platform 2020   
An Access Database is available on demand.

The Specifications are derived from our consulting assignments in Travel, Transport and Logistics.

We would be glad to have your comments.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

This is a Top-Level Model which shows only the Subject Areas, each of which is shown in its own Model.

We have also designed a Dimensional Model for Airline Operations, which is very useful for
providing data for Reports and Business Intelligence.
And an Azure Demo

Click here to see the Slide-Show for this Scenario.
User Scenario
This is the final step in this Scenario which is an Alert call to the CEO's Smartphone on the Golf Course

KPI Data
Table to support KPIs for Flight Intervals for POC

POC Data Mart
This Data Mart holds only the data for our POC (Proof-of-Concept)

POC Airport Management Platform (Layers)

Data Mart (Dimensional) Model
(on this page)

Basic Data Mart

Logical Data Model for comprehensive Data Warehouse

Proof-of-Concept Data Warehouse

Conceptual version of Our Canonical Data Model

Canonical Data Model
Our Participants ERwin Canonical Data Model
This is a little different from the Conceptual version

ERwin Canonical Data Model

We have also created Data Models for these Subject Areas :-
  • Aircraft Maintenance
  • Airline Operations
  • Airline Reservations
  • Airport Management
  • Passengers Online Bookings

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    March 24th. 2017

  • © DataBase Answers Ltd. 2017
    About Us Contact Us