Sales Receipts Generic Data Model


Printer-friendly version

Dutch Railways Sales Receipts Data Model

An Access Database is available on demand. This Model is based on our Canonical Data Model.

Here is the design of Customers and Flights Data Marts with Conformed Dimensions which is an excellent start for Enquiries and producing Reports.

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

Here is an Airline Boarding Pass

Airline Boarding Pass Sales Receipt
Data Model for Sales Receipt for Airline Boarding Pass

The corresponding normalized Data Model
3NF Normalised Data Model for a Boarding Pass

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
December 11th. 2012