1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Showing erd notation instead of dataflow

Discussion in 'SQL PL/SQL' started by 09williamsad, Dec 2, 2015.

  1. 09williamsad

    09williamsad Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    England
    Hello

    I am using Oracle SQL developer version 4.1.1.19 and when I make then link 2 table with a mandatory one to optional one notation, the model view shows an arrow where there should be an optional one notation.

    I know that the arrow indicates the data flow but I am trying to check that the relationship has been applied correctly by checking the notation which the data flow arrow seems to have replaced.

    I have uploaded an image of the model and here is the code for the two tables:
    Code (SQL):
     CREATE TABLE MAND_ONE_TO_OPT_ONE_A
       (    A_ID VARCHAR2(3 BYTE),
        A_NAME VARCHAR2(3 BYTE),
         PRIMARY KEY (A_ID))
    Code (SQL):
    CREATE TABLE MAND_ONE_TO_OPT_ONE_B
       (    B_ID VARCHAR2(3 BYTE),
        B_NAME VARCHAR2(3 BYTE),
        FK_B_A VARCHAR2(3 BYTE) NOT NULL ENABLE,
         PRIMARY KEY (B_ID)
             UNIQUE (FK_B_A)
             FOREIGN KEY ("FK_B_A")
         REFERENCES MAND_ONE_TO_OPT_ONE_A (A_ID) ENABLE)
    Thank you in advance for any help.
     

    Attached Files:

  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    I don't believe that the physical model displays optionality graphically. In the logical model ERD, a relationship would show as a dashed line. However, I can't say that I ever use the physical model ERD to verify that I have done what I really meant to do.