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.

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

This Dimensional Data Mart Model on this page

Conceptual Data Model
Logical Data Model

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
The Conceptual Model

Conceptual 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
    January 23rd. 2017

  • © DataBase Answers Ltd. 2011
    About Us Contact Us