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

4. Uniqueness Constraints

4.1Introduction to CSDP Step 4
  • Static and dynamic constraints

  • Uniqueness constraints and arity checks

4.2Constraining Unaries and Binaries
  • Uniqueness constraints on unary fact types

  • Uniqueness constraints on binary fact types

4.3Constraining Longer Fact Types
  • Uniqueness constraints on ternaries

  • Uniqueness constraints on quaternaries, etc.

4.4External Uniqueness Constraints
  • Conceptual joins

  • External uniqueness constraints

4.5Arity Checks
  • Keys and functional dependencies

  • The n - 1 rule

  • Rephrasing as conjunctions

  • Objectified associations

4.6Projections and Joins
  • The projection operation

  • The projection-join check

4.7Summary
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