1. OBTR Data Model Getting Started
  2. Oracle Banking Treasury Management Data Model
  3. Creating Data Model and ER diagram

1.4 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 image_1.png follows
    Description of the illustration image_1.png
    Description of image_2.png follows
    Description of the illustration image_2.png
  2. Click on File → Import → Data dictionary.
    Description of image_3.png follows
    Description of the illustration image_3.png
  3. Click Add.
    Description of image_4.png follows
    Description of the illustration image_4.png
  4. Provide the database connectivity.
    Description of image_5.png follows
    Description of the illustration image_5.png
  5. Click Test Connection and ensure it is successful. If connection fails, verify and repeat step4.
    Description of image_6.png follows
    Description of the illustration image_6.png
  6. Click database connection row.
    Description of image_7.png follows
    Description of the illustration image_7.png
  7. Select the database schema name.
    Description of image_8.png follows
    Description of the illustration image_8.png
  8. Select the entities( tables ) that are to be used in ER diagram.
    Description of image_9.png follows
    Description of the illustration image_9.png
    Description of image_10.png follows
    Description of the illustration image_10.png
  9. Click Next.
    Description of image_11.png follows
    Description of the illustration image_11.png
  10. Click Finish.
    Description of image_12.png follows
    Description of the illustration image_12.png
    Description of image_13.png follows
    Description of the illustration image_13.png
    Description of image_14.png follows
    Description of the illustration image_14.png
  11. The ER diagram can be saved as .dmd file if required.
    Description of image_15.png follows
    Description of the illustration image_15.png
    Description of image_16.png follows
    Description of the illustration image_16.png
    dmd file

Parent topic: Oracle Banking Treasury Management Data Model