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

3

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

    
asked by anonymous 29.08.2015 / 20:29

1 answer

2

I use the brModel to create the logical structure, there is also the MySql Workbench that looks much cooler than the brModel, however, I prefer the first because of its simplicity.   Do a google search of how you can use these tools to help your work !! At first my teacher asked us to do it in Word and on paper too !! At first this is how the person gets a bit bewildered, take a look at these tools !!

    
30.08.2015 / 00:58