Is there a simple method to test a logical data model?

Question

It’s been a while since I learned the Entity-Relationship Model, and my teacher taught me that after the logical model is ready it’s always interesting to test the model to check for possible inaccuracies.

I agree that this is very important, the problem is how to test. He taught us to create all the tables and populate them with real data... In Microsoft Word...

It works, but it sucks, it gives me a headache...

I explained my situation to an experienced person, and he gave me an even worse suggestion: Draw all the tables on a sheet of paper and test manually... Honestly, it’s been almost 40 years that Model E-R is there, for God’s sake ...

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 DBMS, and, if this is the case, what are the errors by which I should try.

Thank you

Answer 1

I use brModel to create the logical structure, there is also Mysql Workbench which has a much nicer look than brModel, however, I prefer the first due to its simplicity. Do a google search of how you can use these tools to help your work!! At the beginning my teacher asked us to do it in Word and on paper too!! At first it is so the person gets a little bewildered, from a look at these tools!!