Example ER Diagrams
When Normal Forms are Not Enough
by Paweł Zabrowski
22 Nov 2013
A real-life example: Let’s assume that we have a system which stores data for distributors who sell products manufactured by some company. Each distributor receives points for selling products and may redeem a specified number of points to obtain a discount or extra bonus. Points are calculated by an external system and updated very frequently – after processing of each order placed by the distributor himself, a member of the distributor group, or a customer assigned to the distributor.