How to generate ER diagram using Oracle SQL developer

Tool Used : SQL Developer version 3.1.07

Schema Used : HR
Tables Used : Countries, Departments, Employees, Job_History, Jobs, Locations, Regions

Navigate the below path and step by step screen shots:

File > Data Modeler > Import > Data Dictionary

1# Select DB Connection and click on next

2# Select Schema/DB you wish to import and select Import to New Relational Model and click on next

3# select the objects you wish to import and click on next and finish

4# E-R relationship diagram is created between list of tables

5# You can save and print ER relationship by following below path

File > Data Modeler > Print Diagram or Print

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: