Check out Sparx Software's Enterprise Architect. It'll do a lot more than ER diagrams and it is very low cost and a good tool (though a little clunky). -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh Sent: Monday, August 02, 2010 3:09 PM To: oracle-l@xxxxxxxxxxxxx Subject: ER software tool recommendation Hi, We need to build ER/Chen diagram and looking at 3rd party tools, we only need to use the tool for generating ER diagram and need to show following information in output diagrams (Need a tool that can allow us to group objects in subject-areas/sub-models): * Table Name * Primary key column * Foreign Key column * Relationship (1 to 1 or many) Thanks much in advance for providing the feedback/recommendation. Thanks --Harvinder The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access or use by any other person to this internet email is not authorized and may be unlawful. If you are not the intended recipient, please delete or destroy this email. If you do not wish to receive future emails from this sender, please reply directly to this email requesting you be removed from any mailing list. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l