Discuss documentation

Re: Decoding NORMA Relational View

neutrino0112 — Tue, 06 Nov 2012 15:51:01 GMT

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.

Re: Decoding NORMA Relational View

Matthew Curland — Thu, 25 Oct 2012 04:49:25 GMT

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

Decoding NORMA Relational View

neutrino0112 — Thu, 25 Oct 2012 01:13:38 GMT

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