Caveman Database Modeling...FTW
When you are learning you burn a lot of time going in circles and doing things thebhard way. That is what learning is. You do a thing, you think it is good, or at least workable, and then some time later you catch an error or see a gap in logic or implementation and you go back and make changes. It's not lost time... it is the reality of learning. Do, break, fix, check, do, break, fix, check, rinse and repeat. I started out thinking the tdf db needed to be a large number of tables and all kinds of relationships because I wanted to avoid excessive data duplication. I feel that was the right concept, but my skills arent there yet. So the cost for the lack of skill is an increase in time spent. In time skill will increase and time spent will decrease, at the same level of complexity. Once the complexity increases, skill will decrease and time will increase again, for a period of time. The cycle continues. In an old TESTED video Adam Savage used a formula to describe this...