Social Insurance Data Model – ATSC
435 Orchard Road, Unit #11-01, Wisma Atria Office Tower. Singapore 238877

Social Insurance Data Model

Social Insurance Data Model

This document describes the concepts to build subject area and logical data models to be used to support the requirements for the Data Warehouse project of social insurance (DWH).

Data domain in the model
Domains have been used in the model in order to standardize the data lengths and formats of all attributes. The following domains have been used in the Model

Any addition domains will be added as necessary as the development progresses.

Data Architect

The following diagram represents the data architect flow process of a standard DWH system. This architect will have closely rela- tionship with data model design, which will be mentioned details at other part of this document.
– Data model help to captures all information from source system in this architect (Left pane of diagram).
– Data model help to represents all the values information before delivering user business (right pane of diagram).