Tag Archives: Customer

Customer & Supplier are Roles – But What Type?

Share Button

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.

Share Button
2 Comments Continue Reading →

Logical Data Model for Customer & Supplier

Share Button

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 [...]

Share Button
2 Comments Continue Reading →

Which Customer Contact Structure?

Share Button

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 [...]

Share Button
4 Comments Continue Reading →
Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube