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.

Version 1.0
Create date 09-08-2022