Tag Archives: Customer

Customer & Supplier are Roles – But What Type?

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. Continue reading

Posted in DataQuality, Master Data Management | Tagged , , , , , | 2 Comments

Logical Data Model for Customer & Supplier

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 … Continue reading

Posted in DataQuality, Master Data Management | Tagged , , , | 2 Comments

Which Customer Contact Structure?

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 … Continue reading

Posted in Data Structure Modeling | Tagged , | 4 Comments