Information Systems, Databases, and Models › Physical Models › DBMS Model

DBMS Model

The Transformation Model directly translates into a DBMS model, which captures the physical database object definitions in the RDBMS schema or database catalog. The schema generation function directly supports this model. Primary keys become unique indices. Alternate keys and inversion entries also may become indices. Cardinality can be enforced either through the referential integrity capabilities of the DBMS, application logic, or “after the fact” detection and repair of violations.