Previous Next JavaScript must be enabled to correctly display this content

## 3 Creating Data Model and ER diagram

This document describes the steps to create data model and ER diagram

1. Open the Oracle SQL Developer Data modeler.
   Description of the illustration dm1.png
   Description of the illustration dm2.png
   Description of the illustration dm3.png
2. Click on File → Import → Data dictionary.
   Description of the illustration dm4.png
   Description of the illustration dm51.png
3. Click Add.
   Description of the illustration dm6.png
4. Provide the schema details, and Test the connection.
   Description of the illustration dm71.png
   Description of the illustration dm8.png
   Description of the illustration dm9.png
5. If connection is successful click Connect.
   Description of the illustration dm10.png
6. Select the newly created connection and click Next.
   Description of the illustration dm11.png
7. Select the required schema and click Next. All the schema objects will be listed.
   Description of the illustration dm12.png
8. Select the entities( tables ) that are to be used in ER diagram.
   Description of the illustration dm13.png
9. Click Next.
   Description of the illustration dm14.png
10. Click Finish.
    Description of the illustration dm15.png
    Description of the illustration dm16.png
    Description of the illustration dm17.png
    Description of the illustration dm18.png
11. The ER diagram can be saved as .dmd file if required.
    Description of the illustration dm19.png
    Description of the illustration dm20.png