Chapter Notes
By depicting each role as a box associated with a table column, Object-Role Modeling enables uniqueness constraints to be portrayed in a natural way where the impact of the constraint on populations is immediately apparent. Entity Relationship modeling (ER) and UML depict internal uniqueness constraints on associations using a variety of notations for “cardinality constraints” or “multiplicity constraints”, as discussed later. ER offers graphical support for some uniqueness constraints on attributes, but UML does not. Neither ER nor UML offers any significant support for external uniqueness constraints.
Object-Role Modeling makes minimal use of the notion of functional dependency, but this notion is central to many other methods. ...
Get Information Modeling and Relational Databases, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
