Thanks for replying.


I can see where you are coming from regarding the subtypes and supertypes (frankly after looking at it i thought it was too much hence the cry for help!!)

My questions here are:
If i was to create the table as suggested what will happen to the subtypes under the loan entity will they still remain as subtypes and is there a better way of designing the erd to remove the subtypes under commercial loan used for the collateral type.

Should i just make the make the locations under branch attributes.

How do i create the relationship. Please help