The ORM Foundation

Get the facts!

Decoding NORMA Relational View

Last post Tue, Nov 6 2012 10:51 by neutrino0112. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • Wed, Oct 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.


  • Thu, Oct 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.


  • Tue, Nov 6 2012 10:51 In reply to

    Re: Decoding NORMA Relational View


     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-2019 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service