Data Model Architecture


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


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


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.


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


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