Adding views

In relational databases, a view is a logical table created by the specification
of relational operations connecting several files.
When you create a view, Open ModelSphere automatically assigns the
default name View. To avoid confusion as the data model becomes more complex, it
is highly recommended to name views as early as possible after their creation. To do
so, use the graphical editing function of a view’s contents, either with the Properties
window or the Design panel.
To add a view:
- Select the View creation tool
from the relational creation toolbar and
then click the desired location in the diagram window.
- Double-click the view’s name, highlight it, change it and press Enter.
- Create and name views as in the following diagram.
It is possible to use views in the same manner as using tables. Therefore, you can:
- create an association between a view and another view or table
- add primary keys
- add unique keys
- generate or delete foreign keys
- add check constraints
- add triggers
- add indexes
The support of tables and views has been standardized in this way to
offer an additional level of abstraction.