Convention RDBMS datamodel

This diagram is a viewpoint for developing a physical data model for SQL Server RDBMS. This viewpoint indicates which tables, constraints and columns can be used when drawing up an RDBMS data model. A few principles apply to the RDBMS data model:

  • Physical data model is for ICT (Database specialists).
  • SQL DDL statements can be generated from the Physical data model.
  • Naming conventions for the database platform (SQL Server/Oracle) serve as the basis for the Naming Conventions.
The associations show the database details for the referrer and primary keys.

Diagram in standard mode

X_Table_B

Same properties apply as the Tablet_A Naming Conventions. Here the X_ convention has been added for tables with special characteristics such as F_ for fact and D_ for dimension.


Details van X_Table_B

Table_A

Parent table without parents, a primary key is defined based on the Naming Conventions. The model also displays and manages the defined indexes so that the SQL DDL can be generated from the model on this basis.


Details van Table_A

Physical RDBMS Modeling and Naming Convention

Checklist of naming conventions for relational databases based on an item on which the modeler can validate a model elaboration based on the items in the checklist.


Details van Physical RDBMS Modeling and Naming Convention

Table_C

Same properties apply as the Table_A Naming Conventions. the referring key is special because in addition to the table name, a role name has also been added. For example, if there are duplicate associations or references to the table itself.


Details van Table_C

Links 2 Tags

Archimate Architecture repository Architectuur Architectuur document Architectuur repository Big data Bpmn Data architectuur Data kwaliteit Data management Data modelleren Database Document Enterprise architect Grafendatabase Idea Image library Intervisie Logisch applicatie model Matrix Mdg Metadata Metamodel Modelleren Releasemanager Repository Sparx enterprise architect Sql Stappenplan Time aware modelleren Tips en tricks Training Videokanaal Viewpoint Webvideo Werkproces Whitepaper Wpp