Advise an adequate database modeling to IDEF0. Can Online.
Answer 1, Authority 100%
Comrade, it seems to me that you are confusing the methodology. IDEF0 is designed to simulate business processes. Maybe you meant IDEF1x?
In less than a student and at first work used for this Erwin . It just models on IDEF1X methodology.
Now at the second job I use MS Visio 2010 . It is enough, and if you still get plugins to work with the base – so generally super.
Answer 2
Oracle SQL Developer Data Modeler – free (Logical Model, Relational Model, Domain, Data Types, …)