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

7.1. Introduction to CSDP Step 7

In previous steps of the CSDP, we verbalized familiar examples in terms of elementary facts, sketched the fact types on a diagram, and then added various constraints and derivation rules. Most applications include uniqueness, mandatory role, value, set-comparison, and subtyping constraints. Although less common, other kinds of constraint may also apply. Some of these have graphic notations. The rest are specified textually. Once all the constraints are specified, some final checks can be made to help ensure that our information model is consistent and free of redundancy. This concludes the basic conceptual schema design procedure.

CSDP step 7: Add other constraints, and perform final checks

This chapter deals ...

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