Relational Domain
A relational domain represents a restricted physical data structure.
Creating a Relational Domain
To create a relational domain from a database:
1. Click the Databases > Databases navigation menu.
2. Move the mouse over the relevant database and click the New > Relational Domain button.
The new relational domain is created. You can open its properties to modify or add to its characteristics.
Relational Domain Diagram
A relational domain is made up of tables and/or physical views and can be described by 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 domain into sub-domains (components).
To create a diagram from a relational domain:
Hover the mouse over the relational domain and click Create a diagram, followed by the type of diagram (tables or structure).Relational Domain Components
A relational domain can include:
• Sub-domains, visible in the structure diagram
• Business data, for which you define the type of access (read-only, modification, deletion, etc)
• 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.
Adding sub-domains
To add sub-domains to the relational domain:
1. Open the properties of the relational domain.
2. Click Sub-Domains.
3. Create a domain.
Adding data and defining their access mode
To add data to the relational domain:
1. Open the properties of the relational domain.
2. Click the Domain Entities page.
Here you can add:
• Business data
• Physical Data (tables or physical views)
To define the access mode to the object in the relational domain:
1. In the Domain Entities page, select the line of the component of interest.
2. Click the CRUD button.
3. In the windows that appears, select or deselect:
• Data creation
• Data language
• Data modification
• Data deletion