Customer & Supplier are NOT Master Data Entities in Master Data Management (MDM). They are in fact Roles that can be played by the entity Third Party. But are there roles derivable or declarative, i.e. must they be declared and defined? Using the concept of declarative Roles allows unlimited number of Roles to be defined for any third party over time.
The logical data model below shows the data structure needed to support Customer, Supplier and Employee. Pardoxically, none of these appear as an enitity on model! How can that be? There is a very good reason for this, which is that Supplier, Customer and Employee are all deriveable data entities and, as such, ought NEVER [...]
I made this entry in response to a blog post I read about some anomalies in B2B (Business to Business) structures at Echoes in the Database. That post essentially referred to what seemed like duplicate records in a table relating to an individual within a client company and was trying to decided whether or not [...]