Quick Modeling Question

Anonymous

I have a super type of LegalEntity. It can be part of zero or more subtypes, such as Customer, Employee, etc. I created a public model called EntitySubtype2. Is this a valid way to model the relationships with these multiple subtypes? Is there a better way to model the super type/sub type structure?

Thanks,

Chris

Anonymous

Hi,

I think it is a good way of modeling your entities. If you are to general you will lose the capability to distinct the entities from each other over time. You can be a customer and an employee and the stop being an employee but still be a customer.

Maybe the logical identifiers could be historized to open for the possibility of a customer number change or a ssn change and still keeping track of history for the customer?

/Olle