3 Creating Data Model and ER diagram

This topic describes the systematic instruction to Creating Data Model and ER diagram option. This document describes the steps to create data model and ER diagram.

  1. Open the Oracle SQL Developer Data modeler.
    Description of dm1.png follows
    Description of the illustration dm1.png


    Description of dm2.png follows
    Description of the illustration dm2.png


    Description of dm3.png follows
    Description of the illustration dm3.png

  2. Click on File → Import → Data dictionary.
    Description of dm4.png follows
    Description of the illustration dm4.png


    Description of dm5.png follows
    Description of the illustration dm5.png

  3. Click Add.
    Description of dm6.png follows
    Description of the illustration dm6.png

  4. Provide the schema details, and Test the connection.
    Description of dm7.png follows
    Description of the illustration dm7.png


    Description of dm8.png follows
    Description of the illustration dm8.png


    Description of dm9.png follows
    Description of the illustration dm9.png

  5. If connection is successful click Connect.
    Description of dm10.png follows
    Description of the illustration dm10.png

  6. Select the newly created connection and click Next.
    Description of dm11.png follows
    Description of the illustration dm11.png

  7. Select the required schema and click Next. All the schema objects will be listed.
    Description of dm12.png follows
    Description of the illustration dm12.png

  8. Select the entities( tables ) that are to be used in ER diagram.
    Description of dm13.png follows
    Description of the illustration dm13.png

  9. Click Next.
    Description of dm14.png follows
    Description of the illustration dm14.png

  10. Click Finish.
    Description of dm15.png follows
    Description of the illustration dm15.png


    Description of dm16.png follows
    Description of the illustration dm16.png


    Description of dm17.png follows
    Description of the illustration dm17.png


    Description of dm18.png follows
    Description of the illustration dm18.png

  11. The ER diagram can be saved as .dmd file if required.
    Description of dm19.png follows
    Description of the illustration dm19.png


    Description of dm20.png follows
    Description of the illustration dm20.png