Posted on 2009-02-08
I am creating a very simple E-R model of retailing business.
Here is the scanario:
A customer places an order, which is recorded into Sale table. The Sale table should record of the customer and the employee who helped the sale.
The problem with which I need your help is:
The company's employees can also become clients.
How to display this recursive (or sub type-super type relations?) in an E-R diagram?
I spent quite much time trying to figure out.
If you may kindly show me a diagram, it will be tremendously appreciated.