Database Answers Coat Hangers in a Retail Store
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Top-Level Data Model for Retail   

This Data Model is a variation of the Retail Customers Model.

The Specifications are available for review.

We start by agreeing a Statement of Business Objectives to establish the scope of the Top-Level Data Model.

Once we have agreed the Statement of Business Objectives we can create a draft Top-Level Model with associated Subject Areas, each of which is shown in its own Model.

This is an example of a Statement of Business Objectives for a Retail organization :-
"Our Business objectives are to offer a wide range of affordable Products.
We will control costs to achieve maximum profit potential from a wide range of affordable Products which are sourced
on a 'just-in-time' basis tailored to our target market, with specific Customer profiles.
The Top-Level Data Model will establish the data available for a Data Warehouse to meet Business Intelligence requirements."

Top-Level Data Model for Retail (V1 - Version 1) We have also created Data Models for :-
  • Alternative Top-Level Data Model (EDM) for Retail (v2)
  • Alternative EDM for Retail (v3)
  • Alternative EDM for Retail (v4) - Events-Oriented
  • Customers Subject Area
  • Customers and Orders
  • In-Store Shopping
  • Online Shopping
  • Order History
  • Products Subject Area
  • Products, Stores and Sales Subject Area
  • Registered Users (with CMI)
  • Data Layers and Entities
  • Data Mart


    and here's our DBA Road Map Stages

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    March 22nd. 2011


  • © DataBase Answers Ltd. 2011
    About Us Contact Us