7 Other Constraints and Final Checks

Abstract

This chapter provides an overview of step 7 of ORM’s conceptual schema design procedure, then discusses frequency constraints (internal and external), ring constraints, value-comparison constraints, type cardinality constraints, textual constraints, and derivation rules. It then discusses checks on consistency, redundancy, and completeness.

Keywords

ORM; Frequency constraint; Ring constraint; Value-comparison constraint; Type cardinality constraint; Textual constraint; Derivation rule; Consistency check; Redundancy check; Completeness check

Get Information Modeling and Relational Databases, 3rd 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.