Re: Equality constraints and their effect in relational models

Ken Evans — Sat, 19 Nov 2011 00:15:02 GMT

Hello Jose,

Here is an example of an equality constraint that I have taken from page 225 of Terry's book.
I would have thought that this constraint would generate some additional DDL but my tests show that the DDL is the same with and without the constraint. I have asked Matt to comment.

Ken

Equality constraints and their effect in relational models

josecarlus — Fri, 18 Nov 2011 21:49:25 GMT

Hi,

I'd like to know if an equality constraint in an ORM model has any effect over its relational view or if it only has an informational role.

I have a model which I've attached to this post. In the Asset_Movement table I'm getting two columns:

FK1: asset_Account_Asset_Sym

FK2: asset_Sym

but these columns should be only one because their values must be equal. I though that the equality constraint could enforce this but nothing is happening.

I'd like if someone could help me with this. I'd also appreciate if someone could point me out to an example showing the usage of an equality constraint.

Thanks,

Jose Carlos

Open Discussion & Feature Requests

Re: Equality constraints and their effect in relational models

Equality constraints and their effect in relational models