Data Model Architecture

Overview

Describes how information manipulated by the system is structured as a set of data entities and their relationships.

Elements

Data entity. Properties include:

  • name
  • list of attributes and their data types
  • what attributes identify an entity (primary key)
  • rules used to grant permissions to users or user groups to access the entity in the database
  • expected number of entity instances and expected growth rate

Relations

Describe the data relations. E.g.: one-to-one, one-to-many, and many-to-many relationships or generalization/specialization. Make use of a simple table.

Constraints

Database normalization is often used to impose restrictions based on dependencies between entities and their attributes to avoid duplication of information

Purpose

Describes how this view is used. E.g.:

  • serves as the blueprint for the physical database
  • helps stakeholder communication during domain analysis and requirements elicitation
  • helps to analyze performance of transactions that involve database operations
  • helps in modifiability analysis to assess the impact of changes that involve the database structure
  • enables code generation of data table creation scripts and data access code



Data Model Architecture