I've been looking a lot at data modeling of late and I must say, it is difficult to create a database out of the structure. Sometimes, the tables are too many. At time, the nested nature of the entities in the diagram makes it difficult to know what goes where.
Let's look at the structure below
- Employment (joins organization with Employee or another organization)
Sometime, there is even the statement that the parent of entity A is either entity B or entity C but not both.
1. Can I be directed as to how to create databases out of these models?
2. Is implementing the models as they are really the best thing?