Relational Domain
A relational domain represents a restricted relational data structure.
Creating a relational domain
To create a relational domain from a database:
1. Click the Architecture > Databases navigation menu.
2. In the edit area, unfold the Database folder.
3. Over over the database concerned and click New > Relational Domain.
The new relational domain is created. You can open its properties to modify or complete its characteristics.
Relational Domain Diagram
A relational schema is made up of tables and/or physical views and can be described in two types of diagram:
• the table diagram which is used to display a set of tables and their relationships (FK).
• the structure diagram that is used to break down a relation a schema into sub-domains.
You can connect one or more diagrams to a relational domain according to what you want to describe.
To create a diagram from a relational domain:
Move the mouse over the relational domain and click the Create a diagram button, followed by the type of diagram (tables or structure).Adding a component to a relational domain
You can connect objects to a relational domain.
A relational domain can include:
• Sub-domains, visible in the structure diagram
• Tables or physical views, to which the type of access (read only, modification, deletion, etc.) is defined and which are visible in the relational domain's table diagram.
To add a sub-domain to the relational domain:
1. Open the properties of the relational domain of interest.
2. Display the Sub-domains page.
The first section allows you to add domains.
The second section allows you to add objects of type table or physical view.
3. Click New to add a component.
Defining the access mode to the referenced object
On components of type table or physical view you can define the access mode to the referenced object (creation, read-only, deletion, etc.).
To define the access mode to the object in the relational domain:
1. Open the properties window of the relational domain.
2. Select the Components page.
3. Select the line of the component in question.
Commands are added, including the CRUD button.
4. Click this button.
5. In the window that appears, select or deselect the check boxes associated with the actions: Create, Read, Update, Delete.