The ORM Foundation

Hi,

I would just like to ask if their is any way to map an ORM model to a relational schema(Chapter 11: Relational Mapping) using NORMA tool? 

Person-->has-->PersonId ==> Person(PersonID) 

 Yes, an ORM tool such as NORMA can map ORM schemas to relational schemas, although currently some of the more advanced constraints are not mapped. If you are using NORMA, just right-click an empty space in the Document Window, select Extension Manager from the context-menu, click Relational View and press OK to see a diagram of the relational schema that is automatically generated.

  For further details on using NORMA to perform a relational map, see the NORMA labs that are accessible at either www.ORMFoundation.org or www.orm.net. For more detailed coverage, see my latest book 'Object-Role Modeling Fundamentals' (there is a link on my website to purchase that book ).

Cheers

Terry

 Hi,

I really appreciate the reply. Uhm, i got the part where NORMA let's me know what is my primary key(single underline in relationship with chapter 11). But how about the foreign keys and other alternative(double underlined, if im not mistaken).?

and just to be sure, NORMA wont let mee see the Person(PersonId,personHasName) ?

*personHasName has two underlines.  

 The NORMA tool does not use underlining technique shown in Chapter 11.

As Terry said, if you are using NORMA and you have the relational extension feature switched on, then a relational schema appears on a separate page. You can see all of the keys in the relational schema.

Here is an example from part of the "Talent" model that you can download from the Library.