I recently learned the Entity-Relationship Model, and my teacher taught me that after the logical model is ready it is always interesting to test the model to check for any inaccuracies.
I agree that this is very important, the problem is how to test. He taught us how to create all tables and populate them with real data ... In Microsoft Word ...
It works, but that sucks, ours gives me even a headache ...
I explained my situation to an experienced person, and he gave me a worse suggestion: Draw all the tables on a sheet of paper and test manually ... Honestly, the ER Model has been there for almost 40 years now. God's love, no ...
So, I would like to know if there is any tool to mount the tables more easily (in word it takes too long), or if it is interesting to test directly in the DBMS, and, if this is the case, what are the errors by which ones should I try.Thank you