in

The ORM Foundation

Get the facts!

Decoding NORMA Relational View

Last post 11-06-2012 10:51 by neutrino0112. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-24-2012 21:13

    Decoding NORMA Relational View

    When I look at the tables created in the NORMA relational view tab, I notice that some table elements are bold and some are not, and that some are prefixed by PK, FK, U# or nothing at all. Where can I find information on how to decode the meaning of all this? Thanks.

     Richard

  • 10-25-2012 0:49 In reply to

    Re: Decoding NORMA Relational View

    PK indicates 'primary key'.

    FK indicates 'foreign key'.

    U indicates a non-primary uniqueness constraint.

    Numbers after the letters help you associate other columns in the same constraint.

    Bold means that the column is not null.

    -Matt

  • 11-06-2012 10:51 In reply to

    Re: Decoding NORMA Relational View

    Matt,

     Just getting back to this. Thanks for the information. This explained a lot.

    I also noticed that there are also entries in the relational view tables with no indicators (PK, FK, U) They seem to correlate with objects for which there are no uniqueness constraints on their role box. I think that I probably need to take another look at section 8.5 of the Big Brown Book to understand the mapping rules/process.

Page 1 of 1 (3 items)
© 2008-2014 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service