How is a specialization implemented in a bank? [closed]

0

In my ER model and in the diagram I created a specialization for an entity called clients, where it relates to the physical and legal entities coming from that specialization. Do I simply create the relationships between these tables as if it were a normal relationship or is there something else I should do in the implementation?

    
asked by anonymous 05.03.2016 / 14:08

1 answer

1

It depends on the need but essentially it is that. It has the basic data in the person's table and the specific data in the relationship type table (I imagine you will have others besides clients, otherwise it does not make much sense). The relationship is given by an ID of the person on the customer or with a customer ID in person (would have to have a column for each type of relationship or some more elaborate trick). If there is something else to do I can not say, it depends on the specific need not explicitly stated.

    
05.03.2016 / 15:51