I would greatly appreciate if you can support me in enrity relationship issue.
The is a one-to-many relationship between EntityA (PK:GUID) and EntityB (PK:GUID, FK: EntityAGUID) . Example, one "Entity" can have multiple "Portfolios". However, i have three types of type Entitiey A which need to be in seperate tables because each has it's own properties. Example,
EntityA can be a Client, a Company, or a Fund
Client Company Fund
| | |
| | |
|_______ Portfolio _____|
I am looking to have the same PK for the three tables "Client / Company / Fund " so that there will be no conflict in the "Portfolio" FK.
Please advise for the best ERD structure.