Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
Verbalization of column names does not work properly for a 1 to 1 fact between entities when a role is Mandatory.
To get around this, I found that I must set the "Name" value on the mandatory Role of the fact.
Kevin M. Owen
Could you please post what the verbalization is currently coming out as, and what part of it is wrong (if it is not obvious)? Thanks.
Company(code) ___*-|-___ Subscription(Nr)
Company has DriverTech Subscription.
Each Company has exactly one DriverTech Subscription.
For each DriverTech Subscription, at most one Company has that DriverTech Subscription.
but Database table:
Company (Company_Code, Company, ...)
UNLESS I provide a name for the Role marked as Mandatory (*)
See the model I posed under General Discussion on the "Core" page (youll have to remove the role name).
When a role is set as Mandatory the constraint name in the Relational View becomes "Constraint" instead of "InternalUniquenessConstraintXX".
Here is an image to illustrate the previous post: