Have a look at these tools. 1.Oracle sql developer DataModeller 2.Oracle Designer ,which is part of Oracle Developer Suite Thank You, Kind Regards, Sreejith Nair From: Harvinder Singh <Harvinder_Singh@xxxxxxxxx> To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Date: 08/03/2010 02:58 AM Subject: ER software tool recommendation Sent by: oracle-l-bounce@xxxxxxxxxxxxx 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 DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."