|
|
External Frequency Constraints |
|
ORM Primers
|
By Scot Becker on
9/27/2004
|
|
|
|
Just as internal uniqueness constraints can be generalized to internal frequency constraints, external uniqueness constraints can be generalized to external frequency constraints.
|
 |
|
|
More...
|
|
|
|
Frequency constraints |
|
ORM Primers
|
By Scot Becker on
7/30/2004
|
|
|
|
Adding a frequency constraint to a role means that once the role is populated with a given object instance, that same object instance must populate the role between some minimum and some maximum number of times.
|
|
|
|
|
More...
|
|
|
Visio FAQ: Creating set constraints in VEA |
|
Visio FAQ
|
By Scot Becker on
7/28/2004
|
|
|
|
The Visio for Enterprise Architects (VEA) constraint editor can be a little confusing when it comes to creating set (subtype, equality, and exclusion) constraints. I’ll describe how to create these constraints using examples from a related entry.
|
|
|
|
|
More...
|
|
|
Join Path Subset Constraints |
|
ORM Primers
|
By Scot Becker on
7/1/2004
|
|
|
|
I thought I would write up a quick post about my favorite ORM constraint. I like this one because it expresses non-trivial business rules, comes up frequently, and is mostly impossible in the (non-note) constraints supported by ER/UML.
|
|
|
|
|
More...
|
|
|
Scot Unplugged |
|
Off-Topic
|
By Scot Becker on
3/4/2004
|
|
|
|
I live in a state where phrases such as "wind-chill advisory", "winter storm warning", and "holy **** is it cold out there" are bantered around.
|
|
|
|
|
More...
|
|
|
|
|
Visio FAQs |
|
Site Announcements
|
By Scot Becker on
2/3/2004
|
|
|
|
I prowl around in the Visio newsgroups a lot and see many of the same questions over and over. So I am going to post some of them from time to time (and revise them as needed).
|
|
|
|
|
More...
|
|
|
|
|
|
|
|
|
|
|
Entity and Value Types |
|
ORM Primers
|
By Scot Becker on
1/26/2004
|
|
|
|
For people new to ORM, perhaps one of the most confusing ORM distinctions is that of entity types vs. value types. This entry is intended to describe value types, entity types, and the differences between the two as well as clear up some common misconceptions about these classifications of objects.
|
|
|
|
|
More...
|
|
|
SQL Hack or SQL Trick? |
|
SQL Tips
|
By Scot Becker on
12/3/2003
|
|
|
|
A while ago, I needed a function that returned a concatenated string of the values found in multiple rows of a SQL table.
|
|
|
|
|
More...
|
|