i am 4 days old learning this stuff, so apologies in for ignorance!
this is not really a TDM specific question, but i hope someone wil be kind enough to give me some pointers as i am learning alone (thanks wikipedia )
im creating a logical model which i originally though would be about 6/7 entities, but has grown to around 40 and i cant even see them on the screen all together. i am thinking to break the model into subprojects.
here is a screenshot of my work so far. i have not put relatinship lines in yet, as i know them mentally and i am yet to decide it i should chop up the model into chunks
is this a good idea?
do people who work in this field do this kind of thing, is it possible, or does it create problems or break the relational model?
also, when i get to the point where i am creating a physical database, should i be trying make smaller databases and somehow get them to telk to eachother in the application (or maybe even at the database level?
not sure which dbms i will learn, probably SQL due it its ubiquity and the fact one of the main reasons for learning this stuff is to get a job?