Entity Relationship Modeling - Other Common Errors in ER Modeling
(Page 17 of 21 )
Failing to build flexibility The business needs a way to account for customers and suppliers. You might model it like this-
While instead, you could ask, "Does it ever happen that a customer is also a supplier of other goods?" It happens often. You could solve it like this-
We changed the name of CUSTOMER into BUSINESS CONTACT. Using the many-to-many relationship in an early stage of analysis is a powerful mechanism. It shows that a relationship is more complex than first anticipated, and as long as that many-to-many relationship is there, it is a reminder to resolve it at some point in time.
Even worse, the business need might be to identify customers and suppliers by a number from separate series to identify them, so there is a need for customer type as an additional means of identification. Truly, this happens. The analyst gives them this-
where the unique combination of business contact number and contact type is the primary key. (The vertical bar at the crow’s foot notates part of primary key).
Next: Second Normal Violation >>
More Development Cycles Articles
More By Alf A. Pedersen
/ 50 
