How to design database having multiple interrelated entities
- by Sharath Chandra
I am designing a new system which is more of a help system for core applications in banks or healthcare sector. Given the nature of the system this is not a heavy transaction oriented system but more of read intensive.
Now within this application I have multiple entities which are related to each other.
For e.g. Assume the following entities in…