The physical data model consists of physical table entities, properties and associations. This is modeled according to the rules of the platform (usually the relational database) and can therefore be worked out in detail in accordance with the rules of the platform.
If desired, a detailed viewpoint can be developed for this purpose. This also applies to physical models for XML schemes and the like.
Versie | 1 | Creatie datum | 08-02-2018 |
The physical table is an implementation within a relational database and is linked via a trace to the logical data model.
Physical tables are converted to table structures in (relational databases). That is why columns and associations are worked out for these tables. Multiple types of constraints or rules can be added to the tables, columns and associations. Think of primary and foreign keys, check constraints and the like.
For XSD entities the same will applu but from a different perspective: the exchange of messages. Based on the selected platform and message standard extensive implementation details can be implemented in the physical model.