Skip to Content
Information Modeling and Relational Databases, 2nd Edition
book

Information Modeling and Relational Databases, 2nd Edition

by Terry Halpin, Tony Morgan
July 2010
Intermediate to advanced content levelIntermediate to advanced
976 pages
30h 19m
English
Morgan Kaufmann
Content preview from Information Modeling and Relational Databases, 2nd Edition

5.6. Summary

For a given state of the database, the population of a role r, pop(r), is the set of objects referenced as playing that role in that state. A ∪ B, the union of sets A and B, is the set of all elements in A, B, or both. The null set or empty set, { }, has no members. The population of an entity type A, pop(A), is the union of the populations of its roles. Roles of an elementary fact type are called fact roles. A relationship type used purely to identify or reference some object is a reference type; its roles are called reference roles. For a given state, the population of a fact type (stored or derived) is its set of fact instances.

Step 5 of the conceptual schema design procedure requires us to add mandatory role constraints and ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Information Modeling and Relational Databases, 3rd Edition

Information Modeling and Relational Databases, 3rd Edition

Terry Halpin, Tony Morgan
Database Modeling and Design, 5th Edition

Database Modeling and Design, 5th Edition

Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

Publisher Resources

ISBN: 9780123735683