what is the best way to implement the Data Model as described in e.g. Universal Data Models from Len Silverston in Rollbase or in the Arts Data Model.
Both data models try to step away from maintaining information in various entities that are portrayed as completely separate entities.
For instance, there may be a customer table, a supplier table, a manufacturer , and a department table.
The problem is that an organization may play many roles, depending on the particular circumstance. E.g. a supplier can also be a customer.
This is solved by role management
A second problem the data model tries to solve is that different information needs to be stored for "companies" and for physical persons.
For this to work a super entity "Party" is introduced. In the data model you have
If It would be e.g. a java class. Person and Organisation would inherit from Party.
How can this data model be implemented in Rollbase ?
I will try to explain it in Rollbase way of creating a system that includes this data model.
1. Create All objects first with its fields2. Once All objects were created go to Object Definition to start setting up the relationship (See image below)
Then click relationship menu
3. Now choose the Object / Table name you want to create for a relationship with the current object selected then click NEXT4. Then choose the corresponding cardinality the same as your data model, in Rollbase to do that see image below
5. Do the same steps to other object when you create relationships.Attach here is a sample Rollbase implementation with the data model above.
Hope this may help.