Virtual entities of ER models can be transformed into the following different elements of SQL models.
- Tables (just as ordinary, non-virtual entities).
- SQL views (ER to SQL(Oracle) transformation has an additional choice of simple views or materialized views).
The choice is controlled by the Virtual Entities Transformed To transformation property.
Related pages